) [MERKISTÖ charset_name] [Lajittele collation_name] | SET (arvo1, arvo2, value3, ...) [MERKISTÖ charset_name] [Lajittele collation_name] | spatial_type syntaksi index_col_name on: index_col_name: col_name [(pituus)] [ASC | DESC] syntaksi index_type on: index_type: painamalla {btree | HASH} syntaksi indexc_option on: index_option: KEY_BLOCK_SIZE [=] arvo | index_type | KANSSA Parser parser_name syntaksi reference_definition on: reference_definition: Viitteitä tbl_name (index_col_name, ...
) [VASTINE TÄYSI | MATCH OSITTAISTA | MATCH Simple] [Delete reference_option] [ON UPDATE reference_option] syntaksi reference_option on: reference_option: RESTRICT | CASCADE | SET NULL | NO ACTION syntaksi table_option on: table_options: table_option [[,] table_option] ... table_option: MOOTTORIN [=] engine_name | AUTO_INCREMENT [=] arvo | AVG_ROW_LENGTH [=] arvo | [Oletus] MERKISTÖ [=] charset_name | CHECKSUM [=] {0 | 1} | [Oletus] COLLATE [=] collation_name | KOMMENTTI [=] 'merkkijono' | Liitäntä [=] 'connect_string "| Tietohakemisto [=] 'absoluuttinen polku hakemistoon "| DELAY_KEY_WRITE [=] {0 | 1} | INDEX DIRECTORY [=] 'absoluuttinen polku hakemistoon "| INSERT_METHOD [=] {EI | ENSIMMÄINEN | LAST} | KEY_BLOCK_SIZE [=] arvo | MAX_ROWS [=] arvo | MIN_ROWS [=] arvo | PACK_KEYS [=] {0 | 1 | DEFAULT} | PASSWORD [=] 'merkkijono' | ROW_FORMAT [=] {Oletus | DYNAMIC | KIINTEÄ | puristetut | REDUNDANT | COMPACT} | TABLESPACE taulukkotila [VARASTOINTI {DISK | Muisti | default}] | Unionissa [=] (tbl_name [, tbl_name] .
..) syntaksi partition_options on: partition_options: osio {[LINEAR] HASH (expr) | [LINEAR] KEY (column_list) | ALUE (expr) | LIST (expr)} [PARTITIONS num] [SUBPARTITION BY {[LINEAR] HASH (expr) | [LINEAR] KEY (column_list)} [SUBPARTITIONS num]] [(partition_definition [, partition_definition] ...)] syntaksi partition_definition vaihtoehto on: partition_definition: OSIO osion_nimi [ARVOT {pienemp