content_image/763428.jpg
<img src='content_image/763428.jpg'>

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. 

## • AUTOEXTEND_SIZE 

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” . 

## • AUTO_INCREMENT 

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 

