Differences

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

--- docs:mysql:create_table [2007/08/02 09:15] – 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 =====
+===== Basic Syntax =====
-<code>
+<code sql>
 CREATE TABLE tablename
 (
@@ Line 8: / Line 8: @@
   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>