advanced code snippet search

Posted By

fizzer on 09/12/09


Tagged

create


Versions (?)

Who likes this?

2 people have marked this snippet as a favorite

nerdfiles
fyreflyX


MYSQL - CREATE TABLE users - example script

 / Published in: MySQL
 

Example CREATE TABLE script

Expand | Embed | Plain Text 
  1. CREATE TABLE users(
  2. user_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT ,
  3. first_name VARCHAR( 20 ) NOT NULL ,
  4. last_name VARCHAR( 40 ) NOT NULL ,
  5. email VARCHAR( 60 ) NOT NULL ,
  6. pass CHAR( 40 ) NOT NULL ,
  7. registration_date DATETIME NOT NULL ,
  8. PRIMARY KEY ( user_id )
  9. )

Report this snippet  

You need to login to post a comment.