Advanced Search

MySQL create table syntax

/ Published in: MySQL
Save to your folder(s)
Syntax used to create a table in MySQL. Replace column names as appropriate. Primary key should also be modified to suite needs.

Expand | Embed | Plain Text

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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.