Return to Snippet

Revision: 17712
at September 12, 2009 03:48 by fizzer


Initial Code
CREATE TABLE users(
user_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT ,
first_name VARCHAR( 20 ) NOT NULL ,
last_name VARCHAR( 40 ) NOT NULL ,
email VARCHAR( 60 ) NOT NULL ,
pass CHAR( 40 ) NOT NULL ,
registration_date DATETIME NOT NULL ,
PRIMARY KEY ( user_id )
)

Initial URL

                                

Initial Description
Example CREATE  TABLE script

Initial Title
MYSQL - CREATE TABLE users - example script

Initial Tags

                                

Initial Language
MySQL