Differences

This shows you the differences between two versions of the page.

--- docs:mysql:create_table [2007/03/23 11:35] – created billh
+++ docs:mysql:create_table [2008/08/03 00:25] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ====== CREATE TABLE ======
+===== Basic Syntax =====
+<code sql>
+CREATE TABLE tablename
+(
+  column  datatype  [NULL|NOT NULL]  [CONSTRAINTS],
+  column  datatype  [NULL|NOT NULL]  [CONSTRAINTS],
+  ...
+);
+</code>
+===== Basic Example =====
+<code sql>
+CREATE TABLE Vendors
+(
+  vend_id       CHAR(10)     NOT NULL,
+  vend_name     CHAR(50)     NOT NULL,
+  vend_address  CHAR(50)     ,
+  vend_city     CHAR(50)     ,
+  vend_state    CHAR(5)      ,
+  vend_zip      CHAR(10)     ,
+  vend_country  CHAR(50)
+);
+</code>
 ===== from SELECT statement =====
   * CREATE TABLE mytable SELECT * FROM myothertable WHERE somefield = NULL