CREATE TABLE
defines a table in the database. Unlike the regular CREATE TABLE statement in MySQL, in MySQL SDL, only columns, PRIMARY KEY, FOREIGN KEY constraints, and CHECK constraints can be defined.
table_name
column_name
column_definition
key_part
index_option
reference_definition
CHECK
Constraints
table_options
CREATE INDEX
defines an index. Unlike the regular CREATE TABLE statement in MySQL, in MySQL SDL, indexes and unique indexes can only be defined by CREATE INDEX
statements. MySQL SDL does not allow the definition of index and unique index in CREATE TABLE statements.
index_name
index_type
key_part
index_option
algorithm_option
lock_option