Syntax diagrams for MySQL

Created August 16, 2017, from sql_yacc.yy, using Grammar Conversion and Railroad Diagram Generator.


query: END_OF_INPUT verb_clause ; opt_end_of_input END_OF_INPUT no referencesopt_end_of_input: END_OF_INPUT referenced by: query verb_clause: statement begin referenced by: query statement: alter analyze binlog_base64_event call change check checksum commit create deallocate delete_stmt describe do_stmt drop execute flush get_diagnostics group_replication grant handler help insert_stmt install kill load lock optimize keycache parse_gcol_expr partition_entry preload prepare purge release rename repair replace_stmt reset resignal_stmt revoke rollback savepoint select set signal_stmt show shutdown_stmt slave start truncate uninstall unlock update_stmt use xa referenced by: sp_proc_stmt_statement verb_clause deallocate: deallocate_or_drop PREPARE_SYM ident referenced by: statement deallocate_or_drop: DEALLOCATE_SYM DROP referenced by: deallocate prepare: PREPARE_SYM ident FROM prepare_src referenced by: statement prepare_src: TEXT_STRING_sys @ ident_or_text referenced by: prepare execute: EXECUTE_SYM ident execute_using referenced by: statement execute_using: USING execute_var_ident , referenced by: execute execute_var_ident: @ ident_or_text referenced by: execute_using help: HELP_SYM ident_or_text referenced by: statement change: CHANGE MASTER_SYM TO_SYM master_def , opt_channel REPLICATION FILTER_SYM filter_def , referenced by: statement filter_def: REPLICATE_DO_DB REPLICATE_IGNORE_DB EQ opt_filter_db_list REPLICATE_DO_TABLE REPLICATE_IGNORE_TABLE EQ opt_filter_table_list REPLICATE_WILD_DO_TABLE REPLICATE_WILD_IGNORE_TABLE EQ opt_filter_string_list REPLICATE_REWRITE_DB EQ opt_filter_db_pair_list referenced by: change opt_filter_db_list: ( filter_db_ident , ) referenced by: filter_def filter_db_ident: ident referenced by: opt_filter_db_list opt_filter_db_pair_list opt_filter_db_pair_list: ( ( filter_db_ident , filter_db_ident ) , ) referenced by: filter_def opt_filter_table_list: ( filter_table_ident , ) referenced by: filter_def filter_table_ident: ident . ident referenced by: opt_filter_table_list opt_filter_string_list: ( filter_string , ) referenced by: filter_def filter_string: filter_wild_db_table_string referenced by: opt_filter_string_list master_def: MASTER_HOST_SYM MASTER_BIND_SYM MASTER_USER_SYM MASTER_PASSWORD_SYM MASTER_SSL_CA_SYM MASTER_SSL_CAPATH_SYM MASTER_TLS_VERSION_SYM MASTER_SSL_CERT_SYM MASTER_SSL_CIPHER_SYM MASTER_SSL_KEY_SYM MASTER_SSL_CRL_SYM MASTER_SSL_CRLPATH_SYM EQ TEXT_STRING_sys_nonewline MASTER_PORT_SYM MASTER_CONNECT_RETRY_SYM MASTER_RETRY_COUNT_SYM MASTER_DELAY_SYM MASTER_SSL_SYM MASTER_SSL_VERIFY_SERVER_CERT_SYM MASTER_AUTO_POSITION_SYM EQ ulong_num MASTER_HEARTBEAT_PERIOD_SYM EQ NUM_literal IGNORE_SERVER_IDS_SYM EQ ( ignore_server_id , ignore_server_id ) master_file_def referenced by: change ignore_server_id: ulong_num referenced by: master_def master_file_def: MASTER_LOG_FILE_SYM RELAY_LOG_FILE_SYM EQ TEXT_STRING_sys_nonewline MASTER_LOG_POS_SYM EQ ulonglong_num RELAY_LOG_POS_SYM EQ ulong_num referenced by: master_def slave_until opt_channel: FOR_SYM CHANNEL_SYM TEXT_STRING_sys_nonewline referenced by: change flush_option reset_option show_param slave start_slave_opts create: CREATE opt_table_options TABLE_SYM opt_if_not_exists table_ident create2 opt_unique INDEX_SYM ident key_alg ON table_ident ( key_list ) normal_key_options fulltext INDEX_SYM ident init_key_options ON table_ident ( key_list ) fulltext_key_options spatial INDEX_SYM ident init_key_options ON table_ident ( key_list ) spatial_key_options opt_index_lock_algorithm DATABASE opt_if_not_exists ident opt_create_database_options view_or_trigger_or_sp_or_event USER opt_if_not_exists clear_privileges grant_list require_clause connect_options opt_account_lock_password_expire_options LOGFILE_SYM GROUP_SYM logfile_group_info TABLESPACE_SYM tablespace_info SERVER_SYM ident_or_text FOREIGN DATA_SYM WRAPPER_SYM ident_or_text OPTIONS_SYM ( server_options_list ) referenced by: statement server_options_list: server_option , referenced by: alter create server_option: USER HOST_SYM DATABASE OWNER_SYM PASSWORD SOCKET_SYM TEXT_STRING_sys PORT_SYM ulong_num referenced by: server_options_list event_tail: EVENT_SYM opt_if_not_exists sp_name ON SCHEDULE_SYM ev_schedule_time opt_ev_on_completion opt_ev_status opt_ev_comment DO_SYM ev_sql_stmt referenced by: definer_tail no_definer_tail ev_schedule_time: EVERY_SYM expr interval ev_starts ev_ends AT_SYM expr referenced by: ev_alter_on_schedule_completion event_tail opt_ev_status: ENABLE_SYM DISABLE_SYM ON SLAVE referenced by: alter event_tail ev_starts: STARTS_SYM expr referenced by: ev_schedule_time ev_ends: ENDS_SYM expr referenced by: ev_schedule_time opt_ev_on_completion: ev_on_completion referenced by: event_tail ev_on_completion: ON COMPLETION_SYM NOT_SYM PRESERVE_SYM referenced by: ev_alter_on_schedule_completion opt_ev_on_completion opt_ev_comment: COMMENT_SYM TEXT_STRING_sys referenced by: alter event_tail ev_sql_stmt: ev_sql_stmt_inner referenced by: event_tail opt_ev_sql_stmt ev_sql_stmt_inner: sp_proc_stmt_statement sp_proc_stmt_return sp_proc_stmt_if case_stmt_specification sp_labeled_block sp_unlabeled_block sp_labeled_control sp_proc_stmt_unlabeled sp_proc_stmt_leave sp_proc_stmt_iterate sp_proc_stmt_open sp_proc_stmt_fetch sp_proc_stmt_close referenced by: ev_sql_stmt clear_privileges: clear_password_expire_options referenced by: alter_user_command create drop grant rename revoke show_param clear_password_expire_options: referenced by: clear_privileges password_expire sp_name: ident . ident referenced by: alter call drop event_tail opt_ev_rename_to sf_tail show_param sp_tail trigger_tail sp_a_chistics: sp_chistic referenced by: alter sp_c_chistics: sp_c_chistic referenced by: sf_tail sp_tail sp_chistic: COMMENT_SYM TEXT_STRING_sys LANGUAGE_SYM NO_SYM CONTAINS_SYM SQL_SYM READS_SYM MODIFIES_SYM SQL_SYM DATA_SYM sp_suid referenced by: sp_a_chistics sp_c_chistic sp_c_chistic: sp_chistic not DETERMINISTIC_SYM referenced by: sp_c_chistics sp_suid: SQL_SYM SECURITY_SYM DEFINER_SYM INVOKER_SYM referenced by: sp_chistic call: CALL_SYM sp_name opt_sp_cparam_list referenced by: statement opt_sp_cparam_list: ( opt_sp_cparams ) referenced by: call opt_sp_cparams: expr , referenced by: opt_sp_cparam_list sp_fdparam_list: sp_fdparam , referenced by: sf_tail sp_init_param: referenced by: sp_fdparam sp_pdparam sp_fdparam: ident sp_init_param type_with_opt_collate referenced by: sp_fdparam_list sp_pdparam_list: sp_pdparam , referenced by: sp_tail sp_pdparam: sp_opt_inout sp_init_param ident type_with_opt_collate referenced by: sp_pdparam_list sp_opt_inout: IN_SYM OUT_SYM INOUT_SYM referenced by: sp_pdparam sp_proc_stmts1: sp_proc_stmt ; referenced by: else_clause_opt searched_when_clause simple_when_clause sp_elseifs sp_if sp_unlabeled_control sp_decl: DECLARE_SYM ident , ident type_with_opt_collate sp_opt_default CONDITION_SYM FOR_SYM sp_cond CURSOR_SYM FOR_SYM select sp_handler_type HANDLER_SYM FOR_SYM sp_hcond_element , sp_proc_stmt referenced by: sp_block_content sp_handler_type: EXIT_SYM CONTINUE_SYM referenced by: sp_decl sp_hcond_element: sp_hcond referenced by: sp_decl sp_cond: ulong_num sqlstate referenced by: sp_decl sp_hcond sqlstate: SQLSTATE_SYM opt_value TEXT_STRING_literal referenced by: signal_value sp_cond opt_value: VALUE_SYM referenced by: sqlstate sp_hcond: sp_cond ident SQLWARNING_SYM not FOUND_SYM SQLEXCEPTION_SYM referenced by: sp_hcond_element signal_stmt: SIGNAL_SYM signal_value opt_set_signal_information referenced by: statement signal_value: ident sqlstate referenced by: opt_signal_value signal_stmt opt_signal_value: signal_value referenced by: resignal_stmt opt_set_signal_information: SET signal_condition_information_item_name EQ signal_allowed_expr , referenced by: resignal_stmt signal_stmt signal_allowed_expr: literal variable simple_ident referenced by: condition_number opt_set_signal_information signal_condition_information_item_name: CLASS_ORIGIN_SYM SUBCLASS_ORIGIN_SYM CONSTRAINT_CATALOG_SYM CONSTRAINT_SCHEMA_SYM CONSTRAINT_NAME_SYM CATALOG_NAME_SYM SCHEMA_NAME_SYM TABLE_NAME_SYM COLUMN_NAME_SYM CURSOR_NAME_SYM MESSAGE_TEXT_SYM MYSQL_ERRNO_SYM referenced by: opt_set_signal_information resignal_stmt: RESIGNAL_SYM opt_signal_value opt_set_signal_information referenced by: statement get_diagnostics: GET_SYM which_area DIAGNOSTICS_SYM diagnostics_information referenced by: statement which_area: CURRENT_SYM STACKED_SYM referenced by: get_diagnostics diagnostics_information: statement_information_item , CONDITION_SYM condition_number condition_information_item , referenced by: get_diagnostics statement_information_item: simple_target_specification EQ statement_information_item_name referenced by: diagnostics_information simple_target_specification: ident @ ident_or_text referenced by: condition_information_item statement_information_item statement_information_item_name: NUMBER_SYM ROW_COUNT_SYM referenced by: statement_information_item condition_number: signal_allowed_expr referenced by: diagnostics_information condition_information_item: simple_target_specification EQ condition_information_item_name referenced by: diagnostics_information condition_information_item_name: CLASS_ORIGIN_SYM SUBCLASS_ORIGIN_SYM CONSTRAINT_CATALOG_SYM CONSTRAINT_SCHEMA_SYM CONSTRAINT_NAME_SYM CATALOG_NAME_SYM SCHEMA_NAME_SYM TABLE_NAME_SYM COLUMN_NAME_SYM CURSOR_NAME_SYM MESSAGE_TEXT_SYM MYSQL_ERRNO_SYM RETURNED_SQLSTATE_SYM referenced by: condition_information_item sp_opt_default: DEFAULT expr referenced by: sp_decl sp_proc_stmt: sp_proc_stmt_statement sp_proc_stmt_return sp_proc_stmt_if case_stmt_specification sp_labeled_block sp_unlabeled_block sp_labeled_control sp_proc_stmt_unlabeled sp_proc_stmt_leave sp_proc_stmt_iterate sp_proc_stmt_open sp_proc_stmt_fetch sp_proc_stmt_close referenced by: sf_tail sp_block_content sp_decl sp_proc_stmts1 sp_tail trigger_tail sp_proc_stmt_if: IF sp_if END IF referenced by: ev_sql_stmt_inner sp_proc_stmt sp_proc_stmt_statement: statement referenced by: ev_sql_stmt_inner sp_proc_stmt sp_proc_stmt_return: RETURN_SYM expr referenced by: ev_sql_stmt_inner sp_proc_stmt sp_proc_stmt_unlabeled: sp_unlabeled_control referenced by: ev_sql_stmt_inner sp_proc_stmt sp_proc_stmt_leave: LEAVE_SYM label_ident referenced by: ev_sql_stmt_inner sp_proc_stmt sp_proc_stmt_iterate: ITERATE_SYM label_ident referenced by: ev_sql_stmt_inner sp_proc_stmt sp_proc_stmt_open: OPEN_SYM ident referenced by: ev_sql_stmt_inner sp_proc_stmt sp_proc_stmt_fetch: FETCH_SYM sp_opt_fetch_noise ident INTO ident , referenced by: ev_sql_stmt_inner sp_proc_stmt sp_proc_stmt_close: CLOSE_SYM ident referenced by: ev_sql_stmt_inner sp_proc_stmt sp_opt_fetch_noise: NEXT_SYM FROM referenced by: sp_proc_stmt_fetch sp_if: expr THEN_SYM sp_proc_stmts1 sp_elseifs referenced by: sp_elseifs sp_proc_stmt_if sp_elseifs: ELSEIF_SYM sp_if ELSE sp_proc_stmts1 referenced by: sp_if case_stmt_specification: simple_case_stmt searched_case_stmt referenced by: ev_sql_stmt_inner sp_proc_stmt simple_case_stmt: CASE_SYM expr simple_when_clause else_clause_opt END CASE_SYM referenced by: case_stmt_specification searched_case_stmt: CASE_SYM searched_when_clause else_clause_opt END CASE_SYM referenced by: case_stmt_specification simple_when_clause: WHEN_SYM expr THEN_SYM sp_proc_stmts1 referenced by: simple_case_stmt searched_when_clause: WHEN_SYM expr THEN_SYM sp_proc_stmts1 referenced by: searched_case_stmt else_clause_opt: ELSE sp_proc_stmts1 referenced by: searched_case_stmt simple_case_stmt sp_labeled_control: label_ident : sp_unlabeled_control sp_opt_label referenced by: ev_sql_stmt_inner sp_proc_stmt sp_opt_label: label_ident referenced by: sp_labeled_block sp_labeled_control sp_labeled_block: label_ident : sp_block_content sp_opt_label referenced by: ev_sql_stmt_inner sp_proc_stmt sp_unlabeled_block: sp_block_content referenced by: ev_sql_stmt_inner sp_proc_stmt sp_block_content: BEGIN_SYM sp_decl ; sp_proc_stmt ; END referenced by: sp_labeled_block sp_unlabeled_block sp_unlabeled_control: LOOP_SYM sp_proc_stmts1 END LOOP_SYM WHILE_SYM expr DO_SYM sp_proc_stmts1 END WHILE_SYM REPEAT_SYM sp_proc_stmts1 UNTIL_SYM expr END REPEAT_SYM referenced by: sp_labeled_control sp_proc_stmt_unlabeled trg_action_time: BEFORE_SYM AFTER_SYM referenced by: trigger_tail trg_event: INSERT UPDATE_SYM DELETE_SYM referenced by: trigger_tail change_tablespace_access: tablespace_name ts_access_mode referenced by: alter change_tablespace_info: tablespace_name CHANGE ts_datafile change_ts_option_list referenced by: alter tablespace_info: tablespace_name ADD ts_datafile opt_logfile_group_name tablespace_option_list referenced by: create opt_logfile_group_name: USE_SYM LOGFILE_SYM GROUP_SYM ident referenced by: tablespace_info alter_tablespace_info: tablespace_name ADD DROP ts_datafile alter_tablespace_option_list referenced by: alter logfile_group_info: logfile_group_name add_log_file logfile_group_option_list referenced by: create alter_logfile_group_info: logfile_group_name add_log_file alter_logfile_group_option_list referenced by: alter add_log_file: ADD lg_undofile lg_redofile referenced by: alter_logfile_group_info logfile_group_info change_ts_option_list: change_ts_option , referenced by: change_tablespace_info change_ts_option: opt_ts_initial_size opt_ts_autoextend_size opt_ts_max_size referenced by: change_ts_option_list tablespace_option_list: tablespace_option , referenced by: tablespace_info tablespace_option: opt_ts_initial_size opt_ts_autoextend_size opt_ts_max_size opt_ts_extent_size opt_ts_nodegroup opt_ts_engine ts_wait opt_ts_comment opt_ts_file_block_size referenced by: tablespace_option_list alter_tablespace_option_list: alter_tablespace_option , referenced by: alter_tablespace_info alter_tablespace_option: opt_ts_initial_size opt_ts_autoextend_size opt_ts_max_size opt_ts_engine ts_wait referenced by: alter_tablespace_option_list logfile_group_option_list: logfile_group_option , referenced by: logfile_group_info logfile_group_option: opt_ts_initial_size opt_ts_undo_buffer_size opt_ts_redo_buffer_size opt_ts_nodegroup opt_ts_engine ts_wait opt_ts_comment referenced by: logfile_group_option_list alter_logfile_group_option_list: alter_logfile_group_option , referenced by: alter_logfile_group_info alter_logfile_group_option: opt_ts_initial_size opt_ts_engine ts_wait referenced by: alter_logfile_group_option_list ts_datafile: DATAFILE_SYM TEXT_STRING_sys referenced by: alter_tablespace_info change_tablespace_info tablespace_info lg_undofile: UNDOFILE_SYM TEXT_STRING_sys referenced by: add_log_file lg_redofile: REDOFILE_SYM TEXT_STRING_sys referenced by: add_log_file tablespace_name: ident referenced by: alter_tablespace_info change_tablespace_access change_tablespace_info drop tablespace_info logfile_group_name: ident referenced by: alter_logfile_group_info drop logfile_group_info ts_access_mode: READ_ONLY_SYM READ_WRITE_SYM NOT_SYM ACCESSIBLE_SYM referenced by: change_tablespace_access opt_ts_initial_size: INITIAL_SIZE_SYM opt_equal size_number referenced by: alter_logfile_group_option alter_tablespace_option change_ts_option logfile_group_option tablespace_option opt_ts_autoextend_size: AUTOEXTEND_SIZE_SYM opt_equal size_number referenced by: alter_tablespace_option change_ts_option tablespace_option opt_ts_max_size: MAX_SIZE_SYM opt_equal size_number referenced by: alter_tablespace_option change_ts_option tablespace_option opt_ts_extent_size: EXTENT_SIZE_SYM opt_equal size_number referenced by: tablespace_option opt_ts_undo_buffer_size: UNDO_BUFFER_SIZE_SYM opt_equal size_number referenced by: logfile_group_option opt_ts_redo_buffer_size: REDO_BUFFER_SIZE_SYM opt_equal size_number referenced by: logfile_group_option opt_ts_nodegroup: NODEGROUP_SYM opt_equal real_ulong_num referenced by: logfile_group_option tablespace_option opt_ts_comment: COMMENT_SYM opt_equal TEXT_STRING_sys referenced by: logfile_group_option tablespace_option opt_ts_engine: opt_storage ENGINE_SYM opt_equal storage_engines referenced by: alter_logfile_group_option alter_tablespace_option drop_ts_option logfile_group_option tablespace_option opt_ts_file_block_size: FILE_BLOCK_SIZE_SYM opt_equal size_number referenced by: tablespace_option ts_wait: WAIT_SYM NO_WAIT_SYM referenced by: alter_logfile_group_option alter_tablespace_option drop_ts_option logfile_group_option tablespace_option size_number: real_ulonglong_num IDENT_sys referenced by: opt_ts_autoextend_size opt_ts_extent_size opt_ts_file_block_size opt_ts_initial_size opt_ts_max_size opt_ts_redo_buffer_size opt_ts_undo_buffer_size create2: ( create2a LIKE table_ident ) opt_create_table_options opt_create_partitioning create3 LIKE table_ident referenced by: create create2a: create_field_list ) opt_create_table_options opt_create_partitioning create3 opt_create_partitioning create_select ) union_opt referenced by: create2 create3: opt_duplicate opt_as create_select opt_union_clause ( create_select ) union_opt referenced by: create2 create2a opt_create_partitioning: opt_partitioning referenced by: create2 create2a opt_partitioning: partitioning referenced by: opt_create_partitioning partitioning: PARTITION_SYM partition referenced by: alter_commands opt_partitioning partition_entry: PARTITION_SYM partition referenced by: statement partition: BY part_type_def opt_num_parts opt_sub_part part_defs referenced by: partition_entry partitioning part_type_def: opt_linear KEY_SYM opt_key_algo ( part_field_list ) HASH_SYM part_func RANGE_SYM LIST_SYM part_func part_column_list referenced by: partition opt_linear: LINEAR_SYM referenced by: opt_sub_part part_type_def opt_key_algo: ALGORITHM_SYM EQ real_ulong_num referenced by: opt_sub_part part_type_def part_field_list: part_field_item , referenced by: part_column_list part_type_def part_field_item: ident referenced by: part_field_list part_column_list: COLUMNS ( part_field_list ) referenced by: part_type_def part_func: ( part_func_expr ) referenced by: part_type_def sub_part_func: ( part_func_expr ) referenced by: opt_sub_part opt_num_parts: PARTITIONS_SYM real_ulong_num referenced by: partition opt_sub_part: SUBPARTITION_SYM BY opt_linear HASH_SYM sub_part_func KEY_SYM opt_key_algo ( sub_part_field_item , ) opt_num_subparts referenced by: partition sub_part_field_item: ident referenced by: opt_sub_part part_func_expr: bit_expr referenced by: part_func sub_part_func opt_num_subparts: SUBPARTITIONS_SYM real_ulong_num referenced by: opt_sub_part part_defs: ( part_def_list ) referenced by: partition part_def_list: part_definition , referenced by: add_part_extra part_defs reorg_parts_rule part_definition: PARTITION_SYM part_name opt_part_values opt_part_options opt_sub_partition referenced by: part_def_list part_name: ident referenced by: part_definition opt_part_values: VALUES LESS_SYM THAN_SYM part_func_max IN_SYM part_values_in referenced by: part_definition part_func_max: MAX_VALUE_SYM part_value_item referenced by: opt_part_values part_values_in: part_value_item ( part_value_item , ) referenced by: opt_part_values part_value_item: ( part_value_expr_item , ) referenced by: part_func_max part_values_in part_value_expr_item: MAX_VALUE_SYM bit_expr referenced by: part_value_item opt_sub_partition: ( sub_part_definition , ) referenced by: part_definition sub_part_definition: SUBPARTITION_SYM sub_name opt_part_options referenced by: opt_sub_partition sub_name: ident_or_text referenced by: sub_part_definition opt_part_options: opt_part_option referenced by: part_definition sub_part_definition opt_part_option: TABLESPACE_SYM opt_equal ident opt_storage ENGINE_SYM opt_equal storage_engines NODEGROUP_SYM opt_equal real_ulong_num MAX_ROWS MIN_ROWS opt_equal real_ulonglong_num DATA_SYM INDEX_SYM DIRECTORY_SYM COMMENT_SYM opt_equal TEXT_STRING_sys referenced by: opt_part_options create_select: SELECT_SYM select_options select_item_list table_expression referenced by: create2a create3 insert_query_expression opt_as: AS referenced by: create3 opt_create_database_options: create_database_options referenced by: create create_database_options: create_database_option referenced by: alter opt_create_database_options create_database_option: default_collation default_charset referenced by: create_database_options opt_table_options: table_option referenced by: create table_option: TEMPORARY referenced by: opt_table_options opt_if_not_exists: IF not EXISTS referenced by: create event_tail show_param opt_create_table_options: create_table_option , referenced by: create2 create2a create_table_option: ENGINE_SYM opt_equal storage_engines MAX_ROWS MIN_ROWS AUTO_INC opt_equal ulonglong_num AVG_ROW_LENGTH CHECKSUM_SYM TABLE_CHECKSUM_SYM DELAY_KEY_WRITE_SYM KEY_BLOCK_SIZE opt_equal ulong_num PASSWORD COMMENT_SYM COMPRESSION_SYM ENCRYPTION_SYM DATA_SYM INDEX_SYM DIRECTORY_SYM CONNECTION_SYM opt_equal TEXT_STRING_sys PACK_KEYS_SYM STATS_AUTO_RECALC_SYM STATS_PERSISTENT_SYM STATS_SAMPLE_PAGES_SYM opt_equal ulong_num DEFAULT ROW_FORMAT_SYM opt_equal row_types UNION_SYM opt_equal ( opt_table_list ) default_charset default_collation INSERT_METHOD opt_equal merge_insert_types TABLESPACE_SYM opt_equal ident STORAGE_SYM DISK_SYM MEMORY_SYM referenced by: alter_list_item opt_create_table_options default_charset: opt_default charset opt_equal charset_name_or_default referenced by: create_database_option create_table_option default_collation: opt_default COLLATE_SYM opt_equal collation_name_or_default referenced by: create_database_option create_table_option storage_engines: ident_or_text referenced by: create_table_option opt_part_option opt_ts_engine known_storage_engines: ident_or_text referenced by: show_param row_types: DEFAULT FIXED_SYM DYNAMIC_SYM COMPRESSED_SYM REDUNDANT_SYM COMPACT_SYM referenced by: create_table_option merge_insert_types: NO_SYM FIRST_SYM LAST_SYM referenced by: create_table_option udf_type: STRING_SYM REAL DECIMAL_SYM INT_SYM referenced by: udf_tail create_field_list: field_list_item , referenced by: alter_list_item create2a field_list_item: column_def key_def referenced by: create_field_list column_def: field_spec opt_check_constraint references referenced by: alter_list_item field_list_item key_def: normal_key_type opt_ident key_alg ( key_list ) normal_key_options fulltext opt_key_or_index opt_ident init_key_options ( key_list ) fulltext_key_options spatial opt_key_or_index opt_ident init_key_options ( key_list ) spatial_key_options opt_constraint constraint_key_type opt_ident key_alg ( key_list ) normal_key_options FOREIGN KEY_SYM opt_ident ( key_list ) references check_constraint referenced by: alter_list_item field_list_item opt_check_constraint: check_constraint referenced by: column_def check_constraint: CHECK_SYM ( expr ) referenced by: key_def opt_check_constraint opt_constraint: constraint referenced by: key_def constraint: CONSTRAINT opt_ident referenced by: opt_constraint field_spec: field_ident field_def referenced by: alter_list_item column_def field_def: type opt_attribute opt_collate_explicit opt_generated_always AS ( generated_column_func ) opt_stored_attribute opt_gcol_attribute_list referenced by: alter_list_item field_spec opt_generated_always: GENERATED ALWAYS_SYM referenced by: field_def opt_gcol_attribute_list: gcol_attribute referenced by: field_def gcol_attribute: UNIQUE_SYM KEY_SYM COMMENT_SYM TEXT_STRING_sys not NULL_SYM opt_primary KEY_SYM referenced by: opt_gcol_attribute_list opt_stored_attribute: VIRTUAL_SYM STORED_SYM referenced by: field_def parse_gcol_expr: PARSE_GCOL_EXPR_SYM ( generated_column_func ) referenced by: statement generated_column_func: expr referenced by: field_def parse_gcol_expr type: int_type YEAR_SYM opt_field_length real_type opt_precision FLOAT_SYM DECIMAL_SYM NUMERIC_SYM FIXED_SYM float_options field_options BIT_SYM BINARY field_length BOOL_SYM BOOLEAN_SYM char field_length varchar field_length TINYTEXT TEXT_SYM opt_field_length MEDIUMTEXT LONGTEXT ENUM SET ( string_list ) opt_binary nchar field_length nvarchar field_length opt_bin_mod VARBINARY field_length DATE_SYM TIME_SYM TIMESTAMP DATETIME type_datetime_precision TINYBLOB BLOB_SYM opt_field_length spatial_type MEDIUMBLOB LONGBLOB LONG_SYM VARBINARY varchar opt_binary SERIAL_SYM JSON_SYM referenced by: field_def type_with_opt_collate spatial_type: GEOMETRY_SYM GEOMETRYCOLLECTION POINT_SYM MULTIPOINT LINESTRING MULTILINESTRING POLYGON MULTIPOLYGON referenced by: type char: CHAR_SYM referenced by: type varchar nchar: NCHAR_SYM NATIONAL_SYM CHAR_SYM referenced by: type varchar: char VARYING VARCHAR referenced by: type nvarchar: NATIONAL_SYM VARCHAR CHAR_SYM VARYING NVARCHAR_SYM NCHAR_SYM VARCHAR VARYING referenced by: type int_type: INT_SYM TINYINT SMALLINT MEDIUMINT BIGINT referenced by: type real_type: REAL DOUBLE_SYM PRECISION referenced by: type float_options: field_length precision referenced by: cast_type type precision: ( NUM , NUM ) referenced by: float_options opt_precision type_datetime_precision: ( NUM ) referenced by: cast_type type func_datetime_precision: ( NUM ) referenced by: function_call_nonkeyword now field_options: field_option referenced by: type field_option: SIGNED_SYM UNSIGNED ZEROFILL referenced by: field_options field_length: ( LONG_NUM ULONGLONG_NUM DECIMAL_NUM NUM ) referenced by: float_options opt_field_length type opt_field_length: field_length referenced by: cast_type type opt_precision: precision referenced by: type opt_attribute: attribute referenced by: field_def attribute: not NULL_SYM DEFAULT now_or_signed_literal ON UPDATE_SYM now AUTO_INC SERIAL_SYM DEFAULT VALUE_SYM opt_primary KEY_SYM UNIQUE_SYM KEY_SYM COMMENT_SYM TEXT_STRING_sys COLLATE_SYM collation_name COLUMN_FORMAT_SYM DEFAULT FIXED_SYM DYNAMIC_SYM STORAGE_SYM DEFAULT DISK_SYM MEMORY_SYM referenced by: opt_attribute type_with_opt_collate: type opt_collate referenced by: sf_tail sp_decl sp_fdparam sp_pdparam now: NOW_SYM func_datetime_precision referenced by: attribute function_call_nonkeyword now_or_signed_literal now_or_signed_literal: now signed_literal referenced by: attribute charset: CHAR_SYM SET CHARSET referenced by: alter_list_item default_charset opt_binary opt_load_data_charset option_value_no_option_type show_param charset_name: ident_or_text BINARY referenced by: charset_name_or_default function_call_keyword opt_binary simple_expr charset_name_or_default: charset_name DEFAULT referenced by: alter_list_item default_charset opt_load_data_charset option_value_no_option_type opt_load_data_charset: charset charset_name_or_default referenced by: into_destination load old_or_new_charset_name: ident_or_text BINARY referenced by: old_or_new_charset_name_or_default old_or_new_charset_name_or_default: old_or_new_charset_name DEFAULT referenced by: option_value_no_option_type collation_name: ident_or_text referenced by: attribute collation_name_or_default opt_collate_explicit opt_collate: COLLATE_SYM collation_name_or_default referenced by: alter_list_item option_value_no_option_type type_with_opt_collate opt_collate_explicit: COLLATE_SYM collation_name referenced by: field_def collation_name_or_default: collation_name DEFAULT referenced by: default_collation opt_collate opt_default: DEFAULT referenced by: default_charset default_collation ascii: ASCII_SYM BINARY BINARY ASCII_SYM referenced by: opt_binary unicode: UNICODE_SYM BINARY BINARY UNICODE_SYM referenced by: opt_binary opt_binary: ascii unicode BYTE_SYM charset charset_name opt_bin_mod BINARY charset charset_name referenced by: cast_type type opt_bin_mod: BINARY referenced by: opt_binary type ws_nweights: (