Posted By

dkynyc on 07/20/10


Tagged

mysql


Versions (?)

Who likes this?

2 people have marked this snippet as a favorite

mgerdt
jeremydouglass


MySQL create table syntax


 / Published in: MySQL
 

Syntax used to create a table in MySQL. Replace column names as appropriate. Primary key should also be modified to suite needs.

  1. CREATE TABLE people (`first_name` CHAR(20), `last_name` CHAR(20),
  2. `bus_phone1` CHAR(20), `email` CHAR(30), PRIMARY KEY (`email`));

Report this snippet  

You need to login to post a comment.