MySQL create table syntax - MySQL Snipplr Social Repository

Revision: 29043

at July 20, 2010 06:04 by dkynyc

Initial Code

CREATE TABLE people (`first_name` char(20), `last_name` char(20), 
`bus_phone1` char(20), `email` char(30), PRIMARY KEY (`email`));

Initial URL

Initial Description

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

Initial Title

MySQL create table syntax

Initial Tags

mysql

Initial Language

MySQL