Syntax diagrams for MySQL
Created August 16, 2017, from sql_yacc.yy,
using Grammar Conversion and Railroad Diagram Generator.
query:
no referencesopt_end_of_input:
referenced by:
query
verb_clause:
referenced by:
query
statement:
referenced by:
sp_proc_stmt_statement
verb_clause
deallocate:
referenced by:
statement
deallocate_or_drop:
referenced by:
deallocate
prepare:
referenced by:
statement
prepare_src:
referenced by:
prepare
execute:
referenced by:
statement
execute_using:
referenced by:
execute
execute_var_ident:
referenced by:
execute_using
help:
referenced by:
statement
change:
referenced by:
statement
filter_def:
referenced by:
change
opt_filter_db_list:
referenced by:
filter_def
filter_db_ident:
referenced by:
opt_filter_db_list
opt_filter_db_pair_list
opt_filter_db_pair_list:
referenced by:
filter_def
opt_filter_table_list:
referenced by:
filter_def
filter_table_ident:
referenced by:
opt_filter_table_list
opt_filter_string_list:
referenced by:
filter_def
filter_string:
referenced by:
opt_filter_string_list
master_def:
referenced by:
change
ignore_server_id:
referenced by:
master_def
master_file_def:
referenced by:
master_def
slave_until
opt_channel:
referenced by:
change
flush_option
reset_option
show_param
slave
start_slave_opts
create:
referenced by:
statement
server_options_list:
referenced by:
alter
create
server_option:
referenced by:
server_options_list
event_tail:
referenced by:
definer_tail
no_definer_tail
ev_schedule_time:
referenced by:
ev_alter_on_schedule_completion
event_tail
opt_ev_status:
referenced by:
alter
event_tail
ev_starts:
referenced by:
ev_schedule_time
ev_ends:
referenced by:
ev_schedule_time
opt_ev_on_completion:
referenced by:
event_tail
ev_on_completion:
referenced by:
ev_alter_on_schedule_completion
opt_ev_on_completion
opt_ev_comment:
referenced by:
alter
event_tail
ev_sql_stmt:
referenced by:
event_tail
opt_ev_sql_stmt
ev_sql_stmt_inner:
referenced by:
ev_sql_stmt
clear_privileges:
referenced by:
alter_user_command
create
drop
grant
rename
revoke
show_param
clear_password_expire_options:
referenced by:
clear_privileges
password_expire
sp_name:
referenced by:
alter
call
drop
event_tail
opt_ev_rename_to
sf_tail
show_param
sp_tail
trigger_tail
sp_a_chistics:
referenced by:
alter
sp_c_chistics:
referenced by:
sf_tail
sp_tail
sp_chistic:
referenced by:
sp_a_chistics
sp_c_chistic
sp_c_chistic:
referenced by:
sp_c_chistics
sp_suid:
referenced by:
sp_chistic
call:
referenced by:
statement
opt_sp_cparam_list:
referenced by:
call
opt_sp_cparams:
referenced by:
opt_sp_cparam_list
sp_fdparam_list:
referenced by:
sf_tail
sp_init_param:
referenced by:
sp_fdparam
sp_pdparam
sp_fdparam:
referenced by:
sp_fdparam_list
sp_pdparam_list:
referenced by:
sp_tail
sp_pdparam:
referenced by:
sp_pdparam_list
sp_opt_inout:
referenced by:
sp_pdparam
sp_proc_stmts1:
referenced by:
else_clause_opt
searched_when_clause
simple_when_clause
sp_elseifs
sp_if
sp_unlabeled_control
sp_decl:
referenced by:
sp_block_content
sp_handler_type:
referenced by:
sp_decl
sp_hcond_element:
referenced by:
sp_decl
sp_cond:
referenced by:
sp_decl
sp_hcond
sqlstate:
referenced by:
signal_value
sp_cond
opt_value:
referenced by:
sqlstate
sp_hcond:
referenced by:
sp_hcond_element
signal_stmt:
referenced by:
statement
signal_value:
referenced by:
opt_signal_value
signal_stmt
opt_signal_value:
referenced by:
resignal_stmt
opt_set_signal_information:
referenced by:
resignal_stmt
signal_stmt
signal_allowed_expr:
referenced by:
condition_number
opt_set_signal_information
signal_condition_information_item_name:
referenced by:
opt_set_signal_information
resignal_stmt:
referenced by:
statement
get_diagnostics:
referenced by:
statement
which_area:
referenced by:
get_diagnostics
diagnostics_information:
referenced by:
get_diagnostics
statement_information_item:
referenced by:
diagnostics_information
simple_target_specification:
referenced by:
condition_information_item
statement_information_item
statement_information_item_name:
referenced by:
statement_information_item
condition_number:
referenced by:
diagnostics_information
condition_information_item:
referenced by:
diagnostics_information
condition_information_item_name:
referenced by:
condition_information_item
sp_opt_default:
referenced by:
sp_decl
sp_proc_stmt:
referenced by:
sf_tail
sp_block_content
sp_decl
sp_proc_stmts1
sp_tail
trigger_tail
sp_proc_stmt_if:
referenced by:
ev_sql_stmt_inner
sp_proc_stmt
sp_proc_stmt_statement:
referenced by:
ev_sql_stmt_inner
sp_proc_stmt
sp_proc_stmt_return:
referenced by:
ev_sql_stmt_inner
sp_proc_stmt
sp_proc_stmt_unlabeled:
referenced by:
ev_sql_stmt_inner
sp_proc_stmt
sp_proc_stmt_leave:
referenced by:
ev_sql_stmt_inner
sp_proc_stmt
sp_proc_stmt_iterate:
referenced by:
ev_sql_stmt_inner
sp_proc_stmt
sp_proc_stmt_open:
referenced by:
ev_sql_stmt_inner
sp_proc_stmt
sp_proc_stmt_fetch:
referenced by:
ev_sql_stmt_inner
sp_proc_stmt
sp_proc_stmt_close:
referenced by:
ev_sql_stmt_inner
sp_proc_stmt
sp_opt_fetch_noise:
referenced by:
sp_proc_stmt_fetch
sp_if:
referenced by:
sp_elseifs
sp_proc_stmt_if
sp_elseifs:
referenced by:
sp_if
case_stmt_specification:
referenced by:
ev_sql_stmt_inner
sp_proc_stmt
simple_case_stmt:
referenced by:
case_stmt_specification
searched_case_stmt:
referenced by:
case_stmt_specification
simple_when_clause:
referenced by:
simple_case_stmt
searched_when_clause:
referenced by:
searched_case_stmt
else_clause_opt:
referenced by:
searched_case_stmt
simple_case_stmt
sp_labeled_control:
referenced by:
ev_sql_stmt_inner
sp_proc_stmt
sp_opt_label:
referenced by:
sp_labeled_block
sp_labeled_control
sp_labeled_block:
referenced by:
ev_sql_stmt_inner
sp_proc_stmt
sp_unlabeled_block:
referenced by:
ev_sql_stmt_inner
sp_proc_stmt
sp_block_content:
referenced by:
sp_labeled_block
sp_unlabeled_block
sp_unlabeled_control:
referenced by:
sp_labeled_control
sp_proc_stmt_unlabeled
trg_action_time:
referenced by:
trigger_tail
trg_event:
referenced by:
trigger_tail
change_tablespace_access:
referenced by:
alter
change_tablespace_info:
referenced by:
alter
tablespace_info:
referenced by:
create
opt_logfile_group_name:
referenced by:
tablespace_info
alter_tablespace_info:
referenced by:
alter
logfile_group_info:
referenced by:
create
alter_logfile_group_info:
referenced by:
alter
add_log_file:
referenced by:
alter_logfile_group_info
logfile_group_info
change_ts_option_list:
referenced by:
change_tablespace_info
change_ts_option:
referenced by:
change_ts_option_list
tablespace_option_list:
referenced by:
tablespace_info
tablespace_option:
referenced by:
tablespace_option_list
alter_tablespace_option_list:
referenced by:
alter_tablespace_info
alter_tablespace_option:
referenced by:
alter_tablespace_option_list
logfile_group_option_list:
referenced by:
logfile_group_info
logfile_group_option:
referenced by:
logfile_group_option_list
alter_logfile_group_option_list:
referenced by:
alter_logfile_group_info
alter_logfile_group_option:
referenced by:
alter_logfile_group_option_list
ts_datafile:
referenced by:
alter_tablespace_info
change_tablespace_info
tablespace_info
lg_undofile:
referenced by:
add_log_file
lg_redofile:
referenced by:
add_log_file
tablespace_name:
referenced by:
alter_tablespace_info
change_tablespace_access
change_tablespace_info
drop
tablespace_info
logfile_group_name:
referenced by:
alter_logfile_group_info
drop
logfile_group_info
ts_access_mode:
referenced by:
change_tablespace_access
opt_ts_initial_size:
referenced by:
alter_logfile_group_option
alter_tablespace_option
change_ts_option
logfile_group_option
tablespace_option
opt_ts_autoextend_size:
referenced by:
alter_tablespace_option
change_ts_option
tablespace_option
opt_ts_max_size:
referenced by:
alter_tablespace_option
change_ts_option
tablespace_option
opt_ts_extent_size:
referenced by:
tablespace_option
opt_ts_undo_buffer_size:
referenced by:
logfile_group_option
opt_ts_redo_buffer_size:
referenced by:
logfile_group_option
opt_ts_nodegroup:
referenced by:
logfile_group_option
tablespace_option
opt_ts_comment:
referenced by:
logfile_group_option
tablespace_option
opt_ts_engine:
referenced by:
alter_logfile_group_option
alter_tablespace_option
drop_ts_option
logfile_group_option
tablespace_option
opt_ts_file_block_size:
referenced by:
tablespace_option
ts_wait:
referenced by:
alter_logfile_group_option
alter_tablespace_option
drop_ts_option
logfile_group_option
tablespace_option
size_number:
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:
referenced by:
create
create2a:
referenced by:
create2
create3:
referenced by:
create2
create2a
opt_create_partitioning:
referenced by:
create2
create2a
opt_partitioning:
referenced by:
opt_create_partitioning
partitioning:
referenced by:
alter_commands
opt_partitioning
partition_entry:
referenced by:
statement
partition:
referenced by:
partition_entry
partitioning
part_type_def:
referenced by:
partition
opt_linear:
referenced by:
opt_sub_part
part_type_def
opt_key_algo:
referenced by:
opt_sub_part
part_type_def
part_field_list:
referenced by:
part_column_list
part_type_def
part_field_item:
referenced by:
part_field_list
part_column_list:
referenced by:
part_type_def
part_func:
referenced by:
part_type_def
sub_part_func:
referenced by:
opt_sub_part
opt_num_parts:
referenced by:
partition
opt_sub_part:
referenced by:
partition
sub_part_field_item:
referenced by:
opt_sub_part
part_func_expr:
referenced by:
part_func
sub_part_func
opt_num_subparts:
referenced by:
opt_sub_part
part_defs:
referenced by:
partition
part_def_list:
referenced by:
add_part_extra
part_defs
reorg_parts_rule
part_definition:
referenced by:
part_def_list
part_name:
referenced by:
part_definition
opt_part_values:
referenced by:
part_definition
part_func_max:
referenced by:
opt_part_values
part_values_in:
referenced by:
opt_part_values
part_value_item:
referenced by:
part_func_max
part_values_in
part_value_expr_item:
referenced by:
part_value_item
opt_sub_partition:
referenced by:
part_definition
sub_part_definition:
referenced by:
opt_sub_partition
sub_name:
referenced by:
sub_part_definition
opt_part_options:
referenced by:
part_definition
sub_part_definition
opt_part_option:
referenced by:
opt_part_options
create_select:
referenced by:
create2a
create3
insert_query_expression
opt_as:
referenced by:
create3
opt_create_database_options:
referenced by:
create
create_database_options:
referenced by:
alter
opt_create_database_options
create_database_option:
referenced by:
create_database_options
opt_table_options:
referenced by:
create
table_option:
referenced by:
opt_table_options
opt_if_not_exists:
referenced by:
create
event_tail
show_param
opt_create_table_options:
referenced by:
create2
create2a
create_table_option:
referenced by:
alter_list_item
opt_create_table_options
default_charset:
referenced by:
create_database_option
create_table_option
default_collation:
referenced by:
create_database_option
create_table_option
storage_engines:
referenced by:
create_table_option
opt_part_option
opt_ts_engine
known_storage_engines:
referenced by:
show_param
row_types:
referenced by:
create_table_option
merge_insert_types:
referenced by:
create_table_option
udf_type:
referenced by:
udf_tail
create_field_list:
referenced by:
alter_list_item
create2a
field_list_item:
referenced by:
create_field_list
column_def:
referenced by:
alter_list_item
field_list_item
key_def:
referenced by:
alter_list_item
field_list_item
opt_check_constraint:
referenced by:
column_def
check_constraint:
referenced by:
key_def
opt_check_constraint
opt_constraint:
referenced by:
key_def
constraint:
referenced by:
opt_constraint
field_spec:
referenced by:
alter_list_item
column_def
field_def:
referenced by:
alter_list_item
field_spec
opt_generated_always:
referenced by:
field_def
opt_gcol_attribute_list:
referenced by:
field_def
gcol_attribute:
referenced by:
opt_gcol_attribute_list
opt_stored_attribute:
referenced by:
field_def
parse_gcol_expr:
referenced by:
statement
generated_column_func:
referenced by:
field_def
parse_gcol_expr
type:
referenced by:
field_def
type_with_opt_collate
spatial_type:
referenced by:
type
char:
referenced by:
type
varchar
nchar:
referenced by:
type
varchar:
referenced by:
type
nvarchar:
referenced by:
type
int_type:
referenced by:
type
real_type:
referenced by:
type
float_options:
referenced by:
cast_type
type
precision:
referenced by:
float_options
opt_precision
type_datetime_precision:
referenced by:
cast_type
type
func_datetime_precision:
referenced by:
function_call_nonkeyword
now
field_options:
referenced by:
type
field_option:
referenced by:
field_options
field_length:
referenced by:
float_options
opt_field_length
type
opt_field_length:
referenced by:
cast_type
type
opt_precision:
referenced by:
type
opt_attribute:
referenced by:
field_def
attribute:
referenced by:
opt_attribute
type_with_opt_collate:
referenced by:
sf_tail
sp_decl
sp_fdparam
sp_pdparam
now:
referenced by:
attribute
function_call_nonkeyword
now_or_signed_literal
now_or_signed_literal:
referenced by:
attribute
charset:
referenced by:
alter_list_item
default_charset
opt_binary
opt_load_data_charset
option_value_no_option_type
show_param
charset_name:
referenced by:
charset_name_or_default
function_call_keyword
opt_binary
simple_expr
charset_name_or_default:
referenced by:
alter_list_item
default_charset
opt_load_data_charset
option_value_no_option_type
opt_load_data_charset:
referenced by:
into_destination
load
old_or_new_charset_name:
referenced by:
old_or_new_charset_name_or_default
old_or_new_charset_name_or_default:
referenced by:
option_value_no_option_type
collation_name:
referenced by:
attribute
collation_name_or_default
opt_collate_explicit
opt_collate:
referenced by:
alter_list_item
option_value_no_option_type
type_with_opt_collate
opt_collate_explicit:
referenced by:
field_def
collation_name_or_default:
referenced by:
default_collation
opt_collate
opt_default:
referenced by:
default_charset
default_collation
ascii:
referenced by:
opt_binary
unicode:
referenced by:
opt_binary
opt_binary:
referenced by:
cast_type
type
opt_bin_mod:
referenced by:
opt_binary
type
ws_nweights:
referenced by:
function_call_conflict
ws_level_flag_desc:
referenced by:
ws_level_flags
ws_level_flag_reverse:
referenced by:
ws_level_flags
ws_level_flags:
referenced by:
ws_level_list_item
ws_level_number:
referenced by:
ws_level_list_item
ws_level_range
ws_level_list_item:
referenced by:
ws_level_list_or_range
ws_level_range:
referenced by:
ws_level_list_or_range
ws_level_list_or_range:
referenced by:
opt_ws_levels
opt_ws_levels:
referenced by:
function_call_conflict
opt_primary:
referenced by:
attribute
gcol_attribute
references:
referenced by:
column_def
key_def
opt_ref_list:
referenced by:
references
opt_match_clause:
referenced by:
references
opt_on_update_delete:
referenced by:
references
delete_option:
referenced by:
opt_on_update_delete
normal_key_type:
referenced by:
key_def
constraint_key_type:
referenced by:
key_def
key_or_index:
referenced by:
alter_list_item
cache_key_list_or_empty
index_hint_definition
normal_key_type
opt_key_or_index
opt_key_or_index:
referenced by:
constraint_key_type
key_def
keys_or_index:
referenced by:
show_param
opt_unique:
referenced by:
create
fulltext:
referenced by:
create
key_def
spatial:
referenced by:
create
key_def
init_key_options:
referenced by:
create
key_alg
key_def
key_alg:
referenced by:
create
key_def
normal_key_options:
referenced by:
create
key_def
fulltext_key_options:
referenced by:
create
key_def
spatial_key_options:
referenced by:
create
key_def
key_using_alg:
referenced by:
key_alg
normal_key_opt
all_key_opt:
referenced by:
fulltext_key_opt
normal_key_opt
spatial_key_opt
normal_key_opt:
referenced by:
normal_key_options
spatial_key_opt:
referenced by:
spatial_key_options
fulltext_key_opt:
referenced by:
fulltext_key_options
btree_or_rtree:
referenced by:
key_using_alg
key_list:
referenced by:
create
key_def
key_part:
referenced by:
key_list
opt_ident:
referenced by:
constraint
key_def
opt_component:
referenced by:
variable_aux
string_list:
referenced by:
type
alter:
referenced by:
statement
alter_user_command:
referenced by:
alter
opt_account_lock_password_expire_options:
referenced by:
alter
create
opt_account_lock_password_expire_option:
referenced by:
opt_account_lock_password_expire_options
password_expire:
referenced by:
opt_account_lock_password_expire_option
connect_options:
referenced by:
alter
create
connect_option:
referenced by:
connect_options
user_func:
referenced by:
alter
ev_alter_on_schedule_completion:
referenced by:
alter
opt_ev_rename_to:
referenced by:
alter
opt_ev_sql_stmt:
referenced by:
alter
ident_or_empty:
referenced by:
alter
alter_commands:
referenced by:
alter
alter_command_list:
referenced by:
alter_commands
standalone_alter_commands:
referenced by:
alter_commands
opt_validation:
referenced by:
standalone_alter_commands
alter_opt_validation:
referenced by:
alter_commands_modifier
opt_validation
remove_partitioning:
referenced by:
alter_commands
all_or_alt_part_name_list:
referenced by:
adm_partition
standalone_alter_commands
add_partition_rule:
referenced by:
standalone_alter_commands
add_part_extra:
referenced by:
add_partition_rule
reorg_partition_rule:
referenced by:
standalone_alter_commands
reorg_parts_rule:
referenced by:
reorg_partition_rule
alt_part_name_list:
referenced by:
all_or_alt_part_name_list
reorg_parts_rule
standalone_alter_commands
alt_part_name_item:
referenced by:
alt_part_name_list
standalone_alter_commands
alter_list:
referenced by:
alter_command_list
alter_commands_modifier_list:
referenced by:
alter_command_list
alter_commands
add_column:
referenced by:
alter_list_item
alter_list_item:
referenced by:
alter_list
alter_commands_modifier:
referenced by:
alter_commands_modifier_list
alter_list
opt_index_lock_algorithm:
referenced by:
create
drop
alter_algorithm_option:
referenced by:
alter_commands_modifier
opt_index_lock_algorithm
alter_lock_option:
referenced by:
alter_commands_modifier
opt_index_lock_algorithm
opt_column:
referenced by:
add_column
alter_list_item
opt_ignore:
referenced by:
insert_stmt
update_stmt
opt_restrict:
referenced by:
alter_list_item
drop
opt_place:
referenced by:
alter_list_item
opt_to:
referenced by:
alter_list_item
group_replication:
referenced by:
statement
slave:
referenced by:
statement
slave_start:
referenced by:
slave
start_slave_opts:
referenced by:
slave
start:
referenced by:
statement
opt_start_transaction_option_list:
referenced by:
start
start_transaction_option:
referenced by:
opt_start_transaction_option_list
slave_connection_opts:
referenced by:
start_slave_opts
slave_user_name_opt:
referenced by:
slave_connection_opts
slave_user_pass_opt:
referenced by:
slave_connection_opts
slave_plugin_auth_opt:
referenced by:
slave_connection_opts
slave_plugin_dir_opt:
referenced by:
slave_connection_opts
opt_slave_thread_option_list:
referenced by:
slave
slave_start
slave_thread_option:
referenced by:
opt_slave_thread_option_list
slave_until:
referenced by:
start_slave_opts
checksum:
referenced by:
statement
opt_checksum_type:
referenced by:
checksum
repair:
referenced by:
statement
opt_mi_repair_type:
referenced by:
repair
standalone_alter_commands
mi_repair_type:
referenced by:
opt_mi_repair_type
analyze:
referenced by:
statement
binlog_base64_event:
referenced by:
statement
check:
referenced by:
statement
opt_mi_check_type:
referenced by:
check
standalone_alter_commands
mi_check_type:
referenced by:
opt_mi_check_type
optimize:
referenced by:
statement
opt_no_write_to_binlog:
referenced by:
add_partition_rule
analyze
flush
optimize
reorg_partition_rule
repair
standalone_alter_commands
rename:
referenced by:
statement
table_to_table:
referenced by:
rename
keycache:
referenced by:
statement
keycache_list_or_parts:
referenced by:
keycache
assign_to_keycache:
referenced by:
keycache_list_or_parts
assign_to_keycache_parts:
referenced by:
keycache_list_or_parts
key_cache_name:
referenced by:
keycache
preload:
referenced by:
statement
preload_list_or_parts:
referenced by:
preload
preload_keys:
referenced by:
preload_list_or_parts
preload_keys_parts:
referenced by:
preload_list_or_parts
adm_partition:
referenced by:
assign_to_keycache_parts
preload_keys_parts
cache_keys_spec:
referenced by:
assign_to_keycache
assign_to_keycache_parts
preload_keys
preload_keys_parts
cache_key_list_or_empty:
referenced by:
cache_keys_spec
opt_ignore_leaves:
referenced by:
preload_keys
preload_keys_parts
select:
referenced by:
explainable_command
sp_decl
statement
select_init:
referenced by:
select
union_list
select_paren:
referenced by:
select_init
select_paren
select_paren_derived:
referenced by:
query_specification
select_paren_derived
select_part2:
referenced by:
create_view_select
select_init
select_paren
select_options_and_item_list:
referenced by:
select_part2
table_expression:
referenced by:
create_select
query_specification
select_paren_derived
table_factor
from_clause:
referenced by:
opt_from_clause
select_part2
opt_from_clause:
referenced by:
table_expression
table_reference_list:
referenced by:
from_clause
select_options:
referenced by:
create_select
select_options_and_item_list
table_factor
select_option:
referenced by:
select_options
opt_select_lock_type:
referenced by:
select_part2
table_expression
select_item_list:
referenced by:
create_select
do_stmt
select_options_and_item_list
select_part2_derived
table_factor
select_item:
referenced by:
select_item_list
select_alias:
referenced by:
select_item
udf_expr
optional_braces:
referenced by:
function_call_keyword
function_call_nonkeyword
user
expr:
referenced by:
bit_expr
check_constraint
ev_ends
ev_schedule_time
ev_starts
expr
expr_list
expr_or_default
function_call_conflict
function_call_keyword
function_call_nonkeyword
generated_column_func
geometry_function
in_sum_expr
join_table
kill
opt_else
opt_expr
opt_having_clause
opt_sp_cparams
opt_where_clause
opt_wild_or_where
opt_wild_or_where_for_show
option_value_no_option_type
order_expr
predicate
purge_option
searched_when_clause
select_item
set_expr_or_default
simple_case_stmt
simple_expr
simple_when_clause
sp_if
sp_opt_default
sp_proc_stmt_return
sp_unlabeled_control
udf_expr
variable_aux
bool_pri:
referenced by:
expr
predicate:
referenced by:
bool_pri
bit_expr:
referenced by:
bit_expr
function_call_nonkeyword
part_func_expr
part_value_expr_item
predicate
simple_expr
or:
referenced by:
expr
and:
referenced by:
expr
not:
referenced by:
attribute
bool_pri
expr
gcol_attribute
opt_if_not_exists
predicate
sp_c_chistic
sp_hcond
not2:
referenced by:
simple_expr
comp_op:
referenced by:
bool_pri
all_or_any:
referenced by:
bool_pri
simple_expr:
referenced by:
bit_expr
opt_escape
predicate
simple_expr
function_call_keyword:
referenced by:
simple_expr
function_call_nonkeyword:
referenced by:
simple_expr
function_call_conflict:
referenced by:
simple_expr
geometry_function:
referenced by:
function_call_conflict
function_call_generic:
referenced by:
simple_expr
fulltext_options:
referenced by:
simple_expr
opt_natural_language_mode:
referenced by:
fulltext_options
opt_query_expansion:
referenced by:
fulltext_options
opt_udf_expr_list:
referenced by:
function_call_generic
udf_expr:
referenced by:
opt_udf_expr_list
sum_expr:
referenced by:
simple_expr
variable:
referenced by:
signal_allowed_expr
simple_expr
variable_aux:
referenced by:
variable
opt_distinct:
referenced by:
sum_expr
opt_gconcat_separator:
referenced by:
sum_expr
opt_gorder_clause:
referenced by:
sum_expr
in_sum_expr:
referenced by:
sum_expr
cast_type:
referenced by:
simple_expr
opt_expr_list:
referenced by:
function_call_generic
geometry_function
expr_list:
referenced by:
function_call_conflict
function_call_keyword
geometry_function
opt_expr_list
predicate
simple_expr
sum_expr
ident_list_arg:
referenced by:
simple_expr
ident_list:
referenced by:
ident_list_arg
opt_expr:
referenced by:
simple_expr
opt_else:
referenced by:
simple_expr
table_ref:
referenced by:
esc_table_ref
join_table
join_table_list:
referenced by:
delete_stmt
table_reference_list
update_stmt
esc_table_ref:
referenced by:
derived_table_list
derived_table_list:
referenced by:
join_table_list
select_derived
join_table:
referenced by:
table_ref
normal_join:
referenced by:
join_table
opt_use_partition:
referenced by:
delete_stmt
insert_stmt
load
replace_stmt
table_factor
use_partition:
referenced by:
opt_use_partition
table_factor:
referenced by:
join_table
table_ref
select_part2_derived:
referenced by:
query_specification
select_paren_derived
select_derived:
referenced by:
table_factor
opt_outer:
referenced by:
join_table
index_hint_clause:
referenced by:
index_hint_definition
index_hint_type:
referenced by:
index_hint_definition
index_hint_definition:
referenced by:
opt_index_hints_list
opt_index_hints_list:
referenced by:
opt_key_definition
opt_key_definition:
referenced by:
table_factor
opt_key_usage_list:
referenced by:
cache_key_list_or_empty
index_hint_definition
key_usage_element:
referenced by:
key_usage_list
key_usage_list:
referenced by:
index_hint_definition
opt_key_usage_list
using_list:
referenced by:
join_table
use_partition
interval:
referenced by:
bit_expr
ev_schedule_time
function_call_nonkeyword
simple_expr
interval_time_stamp:
referenced by:
function_call_nonkeyword
interval
date_time_type:
referenced by:
function_call_nonkeyword
table_alias:
referenced by:
opt_table_alias
opt_table_alias:
referenced by:
handler
table_factor
table_lock
opt_all:
referenced by:
in_sum_expr
sum_expr
opt_where_clause:
referenced by:
delete_stmt
handler
select_part2
show_param
table_expression
update_stmt
opt_having_clause:
referenced by:
select_part2
table_expression
opt_escape:
referenced by:
predicate
opt_group_clause:
referenced by:
select_part2
table_expression
olap_opt:
referenced by:
opt_group_clause
alter_order_clause:
referenced by:
alter_list_item
alter_order_item:
referenced by:
alter_order_clause
opt_order_clause:
referenced by:
delete_stmt
select_part2
table_expression
update_stmt
order_clause:
referenced by:
opt_order_clause
order_or_limit
order_dir:
referenced by:
alter_order_item
key_list
order_expr
opt_limit_clause:
referenced by:
handler
order_or_limit
select_part2
show_param
table_expression
limit_clause:
referenced by:
opt_limit_clause
order_or_limit
limit_options:
referenced by:
limit_clause
limit_option:
referenced by:
limit_options
opt_simple_limit
opt_simple_limit:
referenced by:
delete_stmt
update_stmt
ulong_num:
referenced by:
all_key_opt
connect_option
create_table_option
function_call_conflict
grant_option
ignore_server_id
master_def
master_file_def
server_option
sp_cond
xid
real_ulong_num:
referenced by:
add_part_extra
explainable_command
opt_account_lock_password_expire_option
opt_key_algo
opt_num_parts
opt_num_subparts
opt_part_option
opt_ts_nodegroup
standalone_alter_commands
ws_level_number
ws_nweights
ulonglong_num:
referenced by:
binlog_from
create_table_option
master_file_def
real_ulonglong_num:
referenced by:
opt_part_option
size_number
dec_num_error:
referenced by:
real_ulong_num
real_ulonglong_num
dec_num:
referenced by:
dec_num_error
opt_procedure_analyse_clause:
referenced by:
select_part2
table_expression
opt_procedure_analyse_params:
referenced by:
opt_procedure_analyse_clause
procedure_analyse_param:
referenced by:
opt_procedure_analyse_params
select_var_ident:
referenced by:
into_destination
opt_into:
referenced by:
select_part2
into:
referenced by:
opt_into
select_part2
into_destination:
referenced by:
into
do_stmt:
referenced by:
statement
empty_select_options:
referenced by:
do_stmt
drop:
referenced by:
statement
table_list:
referenced by:
analyze
check
checksum
drop
opt_table_list
optimize
repair
table_name:
referenced by:
table_list
truncate
table_alias_ref_list:
referenced by:
delete_stmt
if_exists:
referenced by:
alter_user_command
drop
opt_temporary:
referenced by:
drop
drop_ts_option:
referenced by:
drop
insert_stmt:
referenced by:
explainable_command
statement
replace_stmt:
referenced by:
explainable_command
statement
insert_lock_option:
referenced by:
insert_stmt
replace_lock_option:
referenced by:
replace_stmt
opt_INTO:
referenced by:
insert_stmt
replace_stmt
insert_from_constructor:
referenced by:
insert_stmt
replace_stmt
insert_from_subquery:
referenced by:
insert_stmt
replace_stmt
fields:
referenced by:
insert_from_constructor
insert_from_subquery
insert_values:
referenced by:
insert_from_constructor
insert_query_expression:
referenced by:
insert_from_subquery
value_or_values:
referenced by:
insert_values
equal:
referenced by:
load_data_set_elem
opt_equal
option_value_following_option_type
option_value_no_option_type
start_option_value_list
update_elem
opt_equal:
referenced by:
all_key_opt
alter_algorithm_option
alter_lock_option
create_table_option
default_charset
default_collation
opt_part_option
opt_ts_autoextend_size
opt_ts_comment
opt_ts_engine
opt_ts_extent_size
opt_ts_file_block_size
opt_ts_initial_size
opt_ts_max_size
opt_ts_nodegroup
opt_ts_redo_buffer_size
opt_ts_undo_buffer_size
row_value:
referenced by:
insert_values
opt_values:
referenced by:
row_value
values:
referenced by:
handler_rkey_function
opt_values
expr_or_default:
referenced by:
load_data_set_elem
update_elem
values
opt_insert_update_list:
referenced by:
insert_stmt
update_stmt:
referenced by:
explainable_command
statement
update_list:
referenced by:
insert_stmt
opt_insert_update_list
replace_stmt
update_stmt
update_elem:
referenced by:
update_list
opt_low_priority:
referenced by:
replace_lock_option
update_stmt
delete_stmt:
referenced by:
explainable_command
statement
opt_wild:
referenced by:
table_ident_opt_wild
opt_delete_options:
referenced by:
delete_stmt
opt_delete_option:
referenced by:
opt_delete_options
truncate:
referenced by:
statement
opt_table_sym:
referenced by:
truncate
opt_profile_defs:
referenced by:
show_param
profile_def:
referenced by:
opt_profile_defs
opt_profile_args:
referenced by:
show_param
show:
referenced by:
statement
show_param:
referenced by:
show
show_engine_param:
referenced by:
show_param
master_or_binary:
referenced by:
purge_options
show_param
opt_storage:
referenced by:
opt_part_option
opt_ts_engine
show_param
opt_db:
referenced by:
show_param
opt_full:
referenced by:
show_param
from_or_in:
referenced by:
opt_db
show_param
binlog_in:
referenced by:
show_param
binlog_from:
referenced by:
show_param
opt_wild_or_where:
referenced by:
show_param
opt_wild_or_where_for_show:
referenced by:
show_param
describe:
referenced by:
statement
explainable_command:
referenced by:
describe
describe_command:
referenced by:
describe
opt_extended_describe:
referenced by:
describe
opt_describe_column:
referenced by:
describe
flush:
referenced by:
statement
flush_options:
referenced by:
flush
opt_flush_lock:
referenced by:
flush_options
flush_option:
referenced by:
flush_options
opt_table_list:
referenced by:
create_table_option
flush_options
reset:
referenced by:
statement
reset_option:
referenced by:
reset
slave_reset_options:
referenced by:
reset_option
purge:
referenced by:
statement
purge_options:
referenced by:
purge
purge_option:
referenced by:
purge_options
kill:
referenced by:
statement
kill_option:
referenced by:
kill
use:
referenced by:
statement
load:
referenced by:
statement
data_or_xml:
referenced by:
load
opt_local:
referenced by:
load
load_data_lock:
referenced by:
load
opt_duplicate:
referenced by:
create3
load
opt_field_term:
referenced by:
into_destination
load
field_term:
referenced by:
opt_field_term
opt_line_term:
referenced by:
into_destination
load
line_term:
referenced by:
opt_line_term
opt_xml_rows_identified_by:
referenced by:
load
opt_ignore_lines:
referenced by:
load
lines_or_rows:
referenced by:
opt_ignore_lines
opt_field_or_var_spec:
referenced by:
load
field_or_var:
referenced by:
opt_field_or_var_spec
opt_load_data_set_spec:
referenced by:
load
load_data_set_elem:
referenced by:
opt_load_data_set_spec
text_string:
referenced by:
field_term
line_term
opt_describe_column
opt_gconcat_separator
opt_xml_rows_identified_by
string_list
xid
param_marker:
referenced by:
limit_option
simple_expr
signed_literal:
referenced by:
alter_list_item
now_or_signed_literal
literal:
referenced by:
signal_allowed_expr
signed_literal
simple_expr
NUM_literal:
referenced by:
literal
master_def
signed_literal
temporal_literal:
referenced by:
literal
insert_ident:
referenced by:
fields
table_wild:
referenced by:
insert_ident
select_item
order_expr:
referenced by:
opt_gorder_clause
opt_group_clause
order_clause
simple_ident:
referenced by:
ident_list
signal_allowed_expr
simple_expr
simple_ident_nospvar:
referenced by:
alter_order_item
field_or_var
insert_ident
load_data_set_elem
simple_expr
update_elem
simple_ident_q:
referenced by:
simple_ident
simple_ident_nospvar
field_ident:
referenced by:
alter_list_item
field_spec
opt_ident
table_ident:
referenced by:
alter
alter_list_item
assign_to_keycache
assign_to_keycache_parts
create
create2
delete_stmt
describe
drop
grant_ident
handler
insert_stmt
load
preload_keys
preload_keys_parts
references
replace_stmt
show_param
standalone_alter_commands
table_factor
table_lock
table_name
table_to_table
trigger_tail
view_tail
table_ident_opt_wild:
referenced by:
table_alias_ref_list
table_ident_nodb:
referenced by:
handler
IDENT_sys:
referenced by:
fulltext_key_opt
function_call_generic
ident
label_ident
size_number
TEXT_STRING_sys_nonewline:
referenced by:
filter_wild_db_table_string
master_def
master_file_def
opt_channel
filter_wild_db_table_string:
referenced by:
filter_string
TEXT_STRING_sys:
referenced by:
TEXT_STRING_sys_nonewline
all_key_opt
attribute
binlog_base64_event
binlog_in
create_table_option
gcol_attribute
grant_user
ident_or_text
install
lg_redofile
lg_undofile
opt_ev_comment
opt_part_option
opt_ts_comment
opt_wild_or_where
opt_wild_or_where_for_show
prepare_src
purge_option
select_alias
server_option
slave_plugin_auth_opt
slave_plugin_dir_opt
slave_until
slave_user_name_opt
slave_user_pass_opt
sp_chistic
ts_datafile
udf_tail
TEXT_STRING_literal:
referenced by:
literal
simple_expr
sqlstate
text_string
TEXT_STRING_filesystem:
referenced by:
into_destination
load
ident:
referenced by:
alt_part_name_item
alter
alter_algorithm_option
alter_lock_option
column_list_id
create
create_table_option
deallocate
drop
esc_table_ref
execute
field_ident
filter_db_ident
filter_table_ident
function_call_generic
grant_ident
handler_read_or_scan
ident_or_empty
ident_or_text
install
internal_variable_name
key_cache_name
key_part
key_usage_element
limit_option
logfile_group_name
opt_component
opt_db
opt_describe_column
opt_logfile_group_name
opt_part_option
opt_place
opt_ref_list
opt_table_alias
part_field_item
part_name
prepare
release
rollback
savepoint
select_alias
show_param
signal_value
simple_expr
simple_ident
simple_ident_nospvar
simple_ident_q
simple_target_specification
sp_decl
sp_fdparam
sp_hcond
sp_name
sp_pdparam
sp_proc_stmt_close
sp_proc_stmt_fetch
sp_proc_stmt_open
sub_part_field_item
table_ident
table_ident_nodb
table_ident_opt_wild
table_wild
tablespace_name
udf_tail
uninstall
use
using_list
view_list_opt
label_ident:
referenced by:
sp_labeled_block
sp_labeled_control
sp_opt_label
sp_proc_stmt_iterate
sp_proc_stmt_leave
ident_or_text:
referenced by:
alter
alter_instance_action
charset_name
collation_name
create
drop
execute_var_ident
field_or_var
grant_user
help
known_storage_engines
old_or_new_charset_name
opt_extended_describe
option_value_no_option_type
prepare_src
select_var_ident
simple_expr
simple_target_specification
storage_engines
sub_name
trigger_follows_precedes_clause
user
variable_aux
user:
referenced by:
definer
grant_command
grant_user
rename
revoke_command
show_param
start_option_value_list
user_list
keyword:
referenced by:
ident
keyword_sp:
referenced by:
keyword
label_ident
set:
referenced by:
statement
start_option_value_list:
referenced by:
set
start_option_value_list_following_option_type:
referenced by:
start_option_value_list
option_value_list_continued:
referenced by:
start_option_value_list
start_option_value_list_following_option_type
option_value:
referenced by:
option_value_list_continued
option_type:
referenced by:
option_value
start_option_value_list
opt_var_type:
referenced by:
show_param
opt_var_ident_type:
referenced by:
option_value_no_option_type
variable_aux
option_value_following_option_type:
referenced by:
option_value
start_option_value_list_following_option_type
option_value_no_option_type:
referenced by:
option_value
start_option_value_list
internal_variable_name:
referenced by:
option_value_following_option_type
option_value_no_option_type
transaction_characteristics:
referenced by:
start_option_value_list
start_option_value_list_following_option_type
transaction_access_mode:
referenced by:
opt_transaction_access_mode
transaction_characteristics
opt_transaction_access_mode:
referenced by:
transaction_characteristics
isolation_level:
referenced by:
opt_isolation_level
transaction_characteristics
opt_isolation_level:
referenced by:
transaction_characteristics
transaction_access_mode_types:
referenced by:
transaction_access_mode
isolation_types:
referenced by:
isolation_level
password:
referenced by:
start_option_value_list
set_expr_or_default:
referenced by:
option_value_following_option_type
option_value_no_option_type
lock:
referenced by:
statement
table_or_tables:
referenced by:
analyze
check
checksum
drop
flush_options
lock
optimize
rename
repair
unlock
table_lock:
referenced by:
lock
lock_option:
referenced by:
table_lock
unlock:
referenced by:
statement
shutdown_stmt:
referenced by:
statement
alter_instance_stmt:
referenced by:
alter
alter_instance_action:
referenced by:
alter_instance_stmt
handler:
referenced by:
statement
handler_read_or_scan:
referenced by:
handler
handler_scan_function:
referenced by:
handler_read_or_scan
handler_rkey_function:
referenced by:
handler_read_or_scan
handler_rkey_mode:
referenced by:
handler_rkey_function
revoke:
referenced by:
statement
revoke_command:
referenced by:
revoke
grant:
referenced by:
statement
grant_command:
referenced by:
grant
opt_table:
referenced by:
grant_command
revoke_command
grant_privileges:
referenced by:
grant_command
revoke_command
opt_privileges:
referenced by:
grant_privileges
revoke_command
object_privilege:
referenced by:
grant_privileges
opt_and:
referenced by:
require_clause
require_list_element:
referenced by:
require_clause
grant_ident:
referenced by:
grant_command
revoke_command
user_list:
referenced by:
drop
revoke_command
grant_list:
referenced by:
alter
create
grant_command
grant_user:
referenced by:
grant_list
opt_column_list:
referenced by:
object_privilege
column_list_id:
referenced by:
opt_column_list
require_clause:
referenced by:
alter
create
grant_command
grant_options:
referenced by:
grant_command
opt_grant_option:
referenced by:
grant_command
grant_option:
referenced by:
grant_options
begin:
referenced by:
verb_clause
opt_work:
referenced by:
begin
commit
rollback
opt_chain:
referenced by:
commit
rollback
opt_release:
referenced by:
commit
rollback
opt_savepoint:
referenced by:
rollback
commit:
referenced by:
statement
rollback:
referenced by:
statement
savepoint:
referenced by:
statement
release:
referenced by:
statement
opt_union_clause:
referenced by:
create3
insert_query_expression
select_init
view_select_aux
union_list:
referenced by:
opt_union_clause
union_opt
union_opt:
referenced by:
create2a
create3
insert_query_expression
select_init
view_select_aux
opt_union_order_or_limit:
referenced by:
query_specification
table_factor
union_order_or_limit:
referenced by:
opt_union_order_or_limit
union_opt
order_or_limit:
referenced by:
union_order_or_limit
union_option:
referenced by:
subselect
table_factor
union_list
query_specification:
referenced by:
subselect
table_factor
subselect:
referenced by:
bool_pri
predicate
simple_expr
opt_query_spec_options:
referenced by:
select_part2_derived
query_spec_option:
referenced by:
opt_query_spec_options
select_option
view_or_trigger_or_sp_or_event:
referenced by:
create
definer_tail:
referenced by:
view_or_trigger_or_sp_or_event
no_definer_tail:
referenced by:
view_or_trigger_or_sp_or_event
definer_opt:
referenced by:
alter
view_or_trigger_or_sp_or_event
no_definer:
referenced by:
definer_opt
view_or_trigger_or_sp_or_event
definer:
referenced by:
definer_opt
view_or_trigger_or_sp_or_event
view_replace_or_algorithm:
referenced by:
view_or_trigger_or_sp_or_event
view_replace:
referenced by:
view_replace_or_algorithm
view_algorithm:
referenced by:
alter
view_replace_or_algorithm
view_suid:
referenced by:
view_tail
view_tail:
referenced by:
alter
definer_tail
no_definer_tail
view_or_trigger_or_sp_or_event
view_list_opt:
referenced by:
view_tail
view_select:
referenced by:
view_tail
view_select_aux:
referenced by:
view_select
create_view_select_paren:
referenced by:
create_view_select_paren
view_select_aux
create_view_select:
referenced by:
create_view_select_paren
view_select_aux
view_check_option:
referenced by:
view_select
trigger_action_order:
referenced by:
trigger_follows_precedes_clause
trigger_follows_precedes_clause:
referenced by:
trigger_tail
trigger_tail:
referenced by:
definer_tail
no_definer_tail
udf_tail:
referenced by:
no_definer_tail
sf_tail:
referenced by:
definer_tail
no_definer_tail
sp_tail:
referenced by:
definer_tail
no_definer_tail
xa:
referenced by:
statement
opt_convert_xid:
referenced by:
xa
xid:
referenced by:
xa
begin_or_start:
referenced by:
xa
opt_join_or_resume:
referenced by:
xa
opt_one_phase:
referenced by:
xa
opt_suspend:
referenced by:
xa
install:
referenced by:
statement
uninstall:
referenced by:
statement
... generated by Railroad Diagram Generator