Advanced Search

MYSQL - CREATE TABLE users - example script

/ Published in: MySQL
Save to your folder(s)
Example CREATE TABLE script

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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


Comments

You need to login to view comments.