Creating a MySQL Table in PHPMyAdmin
Posted on : 08-11-2009 | By : Karthik | In : PHP Tutorial, Tutorials
1
I hope you know how to install Apache, PHP, MySQL . Now, You are going to create your first MySQL database table for storing username, password & email of members.
SQL Query to create a mysql table
CREATE TABLE `myweb`.`members` (
`id` INT( 12 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`username` VARCHAR( 16 ) NOT NULL ,
`password` VARCHAR( 16 ) NOT NULL ,
`email` VARCHAR( 100 ) NOT NULL
) ENGINE = MYISAM ;
[...] Make sure you have created a mysql database & members table [...]