Creating a MySQL Table in PHPMyAdmin

5 46

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 ;

You might also like
5 Comments
  1. […] Make sure you have created a mysql database & members table […]

  2. […] Make sure you have created a mysql database & members table […]

  3. kiruba says

    very good explanation

  4. kiruba says

    very good explanation

  5. sivasamy says

    good explanation……..

Leave A Reply