MySQL 9.0.0
Source Code Documentation

TABLE . More...

Collaboration diagram for Table options of CREATE/ALTER:

Classes

class  PT_ddl_table_option
 Common base class for CREATE TABLE and ALTER TABLE option nodes. More...
 
class  PT_create_table_option
 Base class for CREATE TABLE option nodes. More...
 
class  PT_create_table_engine_option
 Node for the ENGINE [=] <identifier>|<string> table option. More...
 
class  PT_create_table_secondary_engine_option
 Node for the SECONDARY_ENGINE [=] <identifier>|<string>|NULL table option. More...
 
class  PT_create_stats_auto_recalc_option
 Node for the STATS_AUTO_RECALC [=] <0|1|DEFAULT>) table option. More...
 
class  PT_create_stats_stable_pages
 Node for the STATS_SAMPLE_PAGES [=] <integer>|DEFAULT table option. More...
 

Typedefs

typedef PT_traceable_create_table_option< TYPE_AND_REF(HA_CREATE_INFO::max_rows), HA_CREATE_USED_MAX_ROWSPT_create_max_rows_option
 Node for the MAX_ROWS [=] <integer> table option. More...
 
typedef PT_traceable_create_table_option< TYPE_AND_REF(HA_CREATE_INFO::min_rows), HA_CREATE_USED_MIN_ROWSPT_create_min_rows_option
 Node for the MIN_ROWS [=] <integer> table option. More...
 
typedef PT_traceable_create_table_option< TYPE_AND_REF(HA_CREATE_INFO::avg_row_length), HA_CREATE_USED_AVG_ROW_LENGTHPT_create_avg_row_length_option
 Node for the AVG_ROW_LENGTH_ROWS [=] <integer> table option. More...
 
typedef PT_traceable_create_table_option< TYPE_AND_REF(HA_CREATE_INFO::password), HA_CREATE_USED_PASSWORDPT_create_password_option
 Node for the PASSWORD [=] <string> table option. More...
 
typedef PT_traceable_create_table_option< TYPE_AND_REF(HA_CREATE_INFO::comment), HA_CREATE_USED_COMMENTPT_create_commen_option
 Node for the COMMENT [=] <string> table option. More...
 
typedef PT_traceable_create_table_option< TYPE_AND_REF(HA_CREATE_INFO::compress), HA_CREATE_USED_COMPRESSPT_create_compress_option
 Node for the COMPRESSION [=] <string> table option. More...
 
typedef PT_traceable_create_table_option< TYPE_AND_REF(HA_CREATE_INFO::encrypt_type), HA_CREATE_USED_ENCRYPTPT_create_encryption_option
 Node for the ENGRYPTION [=] <string> table option. More...
 
typedef PT_traceable_create_table_option< TYPE_AND_REF(HA_CREATE_INFO::auto_increment_value), HA_CREATE_USED_AUTOPT_create_auto_increment_option
 Node for the AUTO_INCREMENT [=] <integer> table option. More...
 
typedef PT_ternary_create_table_option< HA_CREATE_USED_PACK_KEYS, 0, HA_OPTION_PACK_KEYS, HA_OPTION_NO_PACK_KEYSPT_create_pack_keys_option
 Node for the PACK_KEYS [=] 1|0|DEFAULT table option. More...
 
typedef PT_ternary_create_table_option< HA_CREATE_USED_STATS_PERSISTENT, 0, HA_OPTION_STATS_PERSISTENT, HA_OPTION_NO_STATS_PERSISTENTPT_create_stats_persistent_option
 Node for the STATS_PERSISTENT [=] 1|0|DEFAULT table option. More...
 
typedef PT_bool_create_table_option< HA_CREATE_USED_CHECKSUM, HA_OPTION_CHECKSUM, HA_OPTION_NO_CHECKSUMPT_create_checksum_option
 Node for the CHECKSUM|TABLE_CHECKSUM [=] 0|<not 0> table option. More...
 
typedef PT_bool_create_table_option< HA_CREATE_USED_DELAY_KEY_WRITE, HA_OPTION_DELAY_KEY_WRITE, HA_OPTION_NO_DELAY_KEY_WRITEPT_create_delay_key_write_option
 Node for the DELAY_KEY_WRITE [=] 0|<not 0> table option. More...
 

Detailed Description

TABLE .

Typedef Documentation

◆ PT_create_auto_increment_option

◆ PT_create_avg_row_length_option

◆ PT_create_checksum_option

Node for the CHECKSUM|TABLE_CHECKSUM [=] 0|<not 0> table option.

TABLE_CHECKSUM Constructor parameter
0 false
not 0 true

◆ PT_create_commen_option

◆ PT_create_compress_option

◆ PT_create_delay_key_write_option

Node for the DELAY_KEY_WRITE [=] 0|<not 0> table option.

TABLE_CHECKSUM Constructor parameter
0 false
not 0 true

◆ PT_create_encryption_option

◆ PT_create_max_rows_option

◆ PT_create_min_rows_option

◆ PT_create_pack_keys_option

Node for the PACK_KEYS [=] 1|0|DEFAULT table option.

PACK_KEYS Constructor parameter
1 Ternary_option::ON
0 Ternary_option::OFF
DEFAULT Ternary_option::DEFAULT

◆ PT_create_password_option

◆ PT_create_stats_persistent_option

Node for the STATS_PERSISTENT [=] 1|0|DEFAULT table option.

STATS_PERSISTENT Constructor parameter
1 Ternary_option::ON
0 Ternary_option::OFF
DEFAULT Ternary_option::DEFAULT