Sql_cmd.h
Enum Enum_sql_command {
Sqlcom_select, Sqlcom_create_table, Sqlcom_create_index, Sqlcom_alter_table,
Sqlcom_update, Sqlcom_insert, Sqlcom_insert_select,
Sqlcom_delete, Sqlcom_truncate, sqlcom_drop_table, Sqlcom_drop_index,
Sqlcom_show_databases, Sqlcom_show_tables, Sqlcom_show_fields,
Sqlcom_show_keys, Sqlcom_show_variables, Sqlcom_show_status,
Sqlcom_show_engine_logs, Sqlcom_show_engine_status, Sqlcom_show_engine_mutex,
Sqlcom_show_processlist, Sqlcom_show_master_stat, Sqlcom_show_slave_stat,
Sqlcom_show_grants, Sqlcom_show_create, Sqlcom_show_charsets,
Sqlcom_show_collations, sqlcom_show_create_db, Sqlcom_show_table_status,
Sqlcom_show_triggers,
Sqlcom_load,sqlcom_set_option,sqlcom_lock_tables,sqlcom_unlock_tables,
Sqlcom_grant,
sqlcom_change_db, sqlcom_create_db, sqlcom_drop_db, sqlcom_alter_db,
Sqlcom_repair, Sqlcom_replace, Sqlcom_replace_select,
Sqlcom_create_function, Sqlcom_drop_function,
Sqlcom_revoke,sqlcom_optimize, Sqlcom_check,
Sqlcom_assign_to_keycache, Sqlcom_preload_keys,
Sqlcom_flush, Sqlcom_kill, Sqlcom_analyze,
Sqlcom_rollback, Sqlcom_rollback_to_savepoint,
Sqlcom_commit, Sqlcom_savepoint, Sqlcom_release_savepoint,
Sqlcom_slave_start, Sqlcom_slave_stop,
Sqlcom_begin, Sqlcom_change_master,
Sqlcom_rename_table,
Sqlcom_reset, Sqlcom_purge, Sqlcom_purge_before, Sqlcom_show_binlogs,
Sqlcom_show_open_tables,
Sqlcom_ha_open, Sqlcom_ha_close, Sqlcom_ha_read,
Sqlcom_show_slave_hosts, Sqlcom_delete_multi, Sqlcom_update_multi,
Sqlcom_show_binlog_events, Sqlcom_do,
Sqlcom_show_warns, Sqlcom_empty_query, Sqlcom_show_errors,
Sqlcom_show_storage_engines, Sqlcom_show_privileges,
Sqlcom_help, Sqlcom_create_user, Sqlcom_drop_user, Sqlcom_rename_user,
Sqlcom_revoke_all, Sqlcom_checksum,
Sqlcom_create_procedure, Sqlcom_create_spfunction, Sqlcom_call,
Sqlcom_drop_procedure, Sqlcom_alter_procedure,sqlcom_alter_function,
Sqlcom_show_create_proc, Sqlcom_show_create_func,
Sqlcom_show_status_proc, Sqlcom_show_status_func,
Sqlcom_prepare, Sqlcom_execute, Sqlcom_deallocate_prepare,
Sqlcom_create_view, Sqlcom_drop_view,
Sqlcom_create_trigger, Sqlcom_drop_trigger,
Sqlcom_xa_start, Sqlcom_xa_end, Sqlcom_xa_prepare,
Sqlcom_xa_commit, Sqlcom_xa_rollback, Sqlcom_xa_recover,
Sqlcom_show_proc_code, Sqlcom_show_func_code,
Sqlcom_alter_tablespace,
Sqlcom_install_plugin, Sqlcom_uninstall_plugin,
Sqlcom_binlog_base64_event,
Sqlcom_show_plugins,
Sqlcom_create_server, Sqlcom_drop_server, Sqlcom_alter_server,
Sqlcom_create_event, Sqlcom_alter_event, Sqlcom_drop_event,
Sqlcom_show_create_event, Sqlcom_show_events,
Sqlcom_show_create_trigger,
Sqlcom_alter_db_upgrade,
Sqlcom_show_profile, Sqlcom_show_profiles,
Sqlcom_signal, Sqlcom_resignal,
Sqlcom_show_relaylog_events,
Sqlcom_get_diagnostics,
Sqlcom_alter_user,
/*
When a command was added here, being sure it ' s also added in mysqld.cc
In "struct Show_var_st status_vars[]= {" ...
*/
/* This should is the last!!! */
Sqlcom_end
};
Command parsing: sql_parse.cc
eg
Casesqlcom_show_processlist:if(!THD -Security_ctx -Priv_user[0] &&check_global_access (thd,process_acl)) Break; Mysqld_list_processes (THD, (THD -Security_ctx -Master_access&Process_acl? NULLS:THD -Security_ctx -priv_user), Lex -verbose); Break;
MYSQL System Command Source location