Posts Tagged ‘инкримент’

CREATE TABLE

СИНТАКСИС:
CREATE TABLE table_name (create_definition, …)

Здесь create_definition имеет следующий формат:
create_definition:
column_name type NOT NULL [DEFAULT default_value] [ PRIMARY KEY ] or
column_name type [NULL] [ PRIMARY KEY ] or
PRIMARY (KEY|INDEX) [key_name] ( column_name,… ) or
(KEY|INDEX) [key_name] ( column_name[length],…) or
INDEX [key_name] ( column_name[length],…) or
UNIQUE (column_name[length],…) or
FOREIGN (KEY|INDEX) [key_name] (column_name[length],…)
REFERENCES table_name
[ON DELETE (RESTRICT | CASCADE | SET NULL) ]
(далее…)