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

Popular posts from this blog

Roll Up Banner Design Service, Professional Roll Up Banner Design for your Company, Organization, Church, Firm, Institution, Business, e.t.c