CREATE TABLE Statement By default, if a storage engine is specified that is not available, the statement fails with an error. You can override this behavior by removing  NO_ENGINE_SUBSTITUTION  from the server SQL mode (see Section 5.1.11, “Server SQL Modes” ) so that MySQL allows substitution of the specified engine with the default storage engine instead. Normally in such cases, this is  InnoDB , which is the default value for the  default_storage_engine  system variable. When  NO_ENGINE_SUBSTITUTION  is disabled, a warning occurs if the storage engine specification is not honored. Defines the amount by which  InnoDB  extends the size of the tablespace when it becomes full. Introduced in MySQL 8.0.23. The setting must be a multiple of 4MB. The default setting is 0, which causes the tablespace to be extended according to the implicit default behavior. For more information, see Section 15.6.3.9, “Tablespace AUTOEXTEND_SIZE Configuration” . The initial  AUTO_INCREMENT  value for the table. In MySQL 8.0, this works for  MyISAM ,  MEMORY , InnoDB , and  ARCHIVE  tables. To set the first auto-increment value for engines that do not support the 2553 • AUTOEXTEND_SIZE • AUTO_INCREMENT Storage Engine Description InnoDB Transaction-safe tables with row locking and foreign keys. The default storage engine for new tables. See Chapter 15,  The InnoDB Storage Engine , and in particular Section 15.1, “Introduction to InnoDB”  if you have MySQL experience but are new to  InnoDB . MyISAM The binary portable storage engine that is primarily used for read-only or read-mostly workloads. See Section 16.2, “The MyISAM Storage Engine” . MEMORY The data for this storage engine is stored only in memory. See Section 16.3, “The MEMORY Storage Engine” . CSV Tables that store rows in comma-separated values format. See Section 16.4, “The CSV Storage Engine” . ARCHIVE The archiving storage engine. See Section 16.5, “The ARCHIVE Storage Engine” . EXAMPLE An example engine. See Section 16.9, “The EXAMPLE Storage Engine” . FEDERATED Storage engine that accesses remote tables. See Section 16.8, “The FEDERATED Storage Engine” . HEAP This is a synonym for  MEMORY . MERGE A collection of  MyISAM  tables used as one table. Also known as  MRG_MyISAM . See Section 16.7, “The MERGE Storage Engine” . NDB Clustered, fault-tolerant, memory-based tables, supporting transactions and foreign keys. Also known as  NDBCLUSTER . See Chapter 23,  MySQL NDB Cluster 8.0 .