PHP code to create table in a database
CREATE TABLE `dbtest`.`users` (
`user_id` INT PRIMARY KEY AUTO_INCREMENT, username` VARCHAR( 20 ) NOT NULL,
`email` VARCHAR( 100 ) NOT NULL,
`password` VARCHAR( 15 ) NOT NULL
)
ENGINE = MYISAM;
Note:dbtest is the database name while users is the table name you are creating and the user_id, username, email and password are the fields of the table declared as integer and characters (varchar) respectively.
Try it out!! Happy coding
Comments
Post a Comment