Creating a MySQL Table in PHPMyAdmin

 3,858 total views

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 ;