This is an old revision of the document!
CREATE TABLE
basic syntax
CREATE TABLE tablename ( column datatype [NULL|NOT NULL] [CONSTRAINTS], column datatype [NULL|NOT NULL] [CONSTRAINTS], ... );
from SELECT statement
- CREATE TABLE mytable SELECT * FROM myothertable WHERE somefield = NULL