Show pageOld revisionsBacklinksBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== 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 docs/mysql/create_table.txt Last modified: 2008/08/03 00:25by 127.0.0.1