←
(Recent tables) ...
There are no recent tables
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
0
information_schema
cm9vdA==.bXlzcWw=
cm9vdA==.bXlzcWw=
0
mysql
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
0
performance_schema
cm9vdA==.emVudGFvZXA=
cm9vdA==.emVudGFvZXA=
0
zentaoep
Javascript must be enabled past this point
Server: localhost:3306
»
Database: mysql
More
Structure
SQL
Search
Query
Export
Import
Operations
Privileges
Routines
Events
Triggers
Column:
`columns_priv`.*
`columns_priv`.`Host`
`columns_priv`.`Db`
`columns_priv`.`User`
`columns_priv`.`Table_name`
`columns_priv`.`Column_name`
`columns_priv`.`Timestamp`
`columns_priv`.`Column_priv`
`db`.*
`db`.`Host`
`db`.`Db`
`db`.`User`
`db`.`Select_priv`
`db`.`Insert_priv`
`db`.`Update_priv`
`db`.`Delete_priv`
`db`.`Create_priv`
`db`.`Drop_priv`
`db`.`Grant_priv`
`db`.`References_priv`
`db`.`Index_priv`
`db`.`Alter_priv`
`db`.`Create_tmp_table_priv`
`db`.`Lock_tables_priv`
`db`.`Create_view_priv`
`db`.`Show_view_priv`
`db`.`Create_routine_priv`
`db`.`Alter_routine_priv`
`db`.`Execute_priv`
`db`.`Event_priv`
`db`.`Trigger_priv`
`event`.*
`event`.`db`
`event`.`name`
`event`.`body`
`event`.`definer`
`event`.`execute_at`
`event`.`interval_value`
`event`.`interval_field`
`event`.`created`
`event`.`modified`
`event`.`last_executed`
`event`.`starts`
`event`.`ends`
`event`.`status`
`event`.`on_completion`
`event`.`sql_mode`
`event`.`comment`
`event`.`originator`
`event`.`time_zone`
`event`.`character_set_client`
`event`.`collation_connection`
`event`.`db_collation`
`event`.`body_utf8`
`func`.*
`func`.`name`
`func`.`ret`
`func`.`dl`
`func`.`type`
`general_log`.*
`general_log`.`event_time`
`general_log`.`user_host`
`general_log`.`thread_id`
`general_log`.`server_id`
`general_log`.`command_type`
`general_log`.`argument`
`help_category`.*
`help_category`.`help_category_id`
`help_category`.`name`
`help_category`.`parent_category_id`
`help_category`.`url`
`help_keyword`.*
`help_keyword`.`help_keyword_id`
`help_keyword`.`name`
`help_relation`.*
`help_relation`.`help_topic_id`
`help_relation`.`help_keyword_id`
`help_topic`.*
`help_topic`.`help_topic_id`
`help_topic`.`name`
`help_topic`.`help_category_id`
`help_topic`.`description`
`help_topic`.`example`
`help_topic`.`url`
`host`.*
`host`.`Host`
`host`.`Db`
`host`.`Select_priv`
`host`.`Insert_priv`
`host`.`Update_priv`
`host`.`Delete_priv`
`host`.`Create_priv`
`host`.`Drop_priv`
`host`.`Grant_priv`
`host`.`References_priv`
`host`.`Index_priv`
`host`.`Alter_priv`
`host`.`Create_tmp_table_priv`
`host`.`Lock_tables_priv`
`host`.`Create_view_priv`
`host`.`Show_view_priv`
`host`.`Create_routine_priv`
`host`.`Alter_routine_priv`
`host`.`Execute_priv`
`host`.`Trigger_priv`
`ndb_binlog_index`.*
`ndb_binlog_index`.`Position`
`ndb_binlog_index`.`File`
`ndb_binlog_index`.`epoch`
`ndb_binlog_index`.`inserts`
`ndb_binlog_index`.`updates`
`ndb_binlog_index`.`deletes`
`ndb_binlog_index`.`schemaops`
`plugin`.*
`plugin`.`name`
`plugin`.`dl`
`proc`.*
`proc`.`db`
`proc`.`name`
`proc`.`type`
`proc`.`specific_name`
`proc`.`language`
`proc`.`sql_data_access`
`proc`.`is_deterministic`
`proc`.`security_type`
`proc`.`param_list`
`proc`.`returns`
`proc`.`body`
`proc`.`definer`
`proc`.`created`
`proc`.`modified`
`proc`.`sql_mode`
`proc`.`comment`
`proc`.`character_set_client`
`proc`.`collation_connection`
`proc`.`db_collation`
`proc`.`body_utf8`
`procs_priv`.*
`procs_priv`.`Host`
`procs_priv`.`Db`
`procs_priv`.`User`
`procs_priv`.`Routine_name`
`procs_priv`.`Routine_type`
`procs_priv`.`Grantor`
`procs_priv`.`Proc_priv`
`procs_priv`.`Timestamp`
`proxies_priv`.*
`proxies_priv`.`Host`
`proxies_priv`.`User`
`proxies_priv`.`Proxied_host`
`proxies_priv`.`Proxied_user`
`proxies_priv`.`With_grant`
`proxies_priv`.`Grantor`
`proxies_priv`.`Timestamp`
`servers`.*
`servers`.`Server_name`
`servers`.`Host`
`servers`.`Db`
`servers`.`Username`
`servers`.`Password`
`servers`.`Port`
`servers`.`Socket`
`servers`.`Wrapper`
`servers`.`Owner`
`slow_log`.*
`slow_log`.`start_time`
`slow_log`.`user_host`
`slow_log`.`query_time`
`slow_log`.`lock_time`
`slow_log`.`rows_sent`
`slow_log`.`rows_examined`
`slow_log`.`db`
`slow_log`.`last_insert_id`
`slow_log`.`insert_id`
`slow_log`.`server_id`
`slow_log`.`sql_text`
`tables_priv`.*
`tables_priv`.`Host`
`tables_priv`.`Db`
`tables_priv`.`User`
`tables_priv`.`Table_name`
`tables_priv`.`Grantor`
`tables_priv`.`Timestamp`
`tables_priv`.`Table_priv`
`tables_priv`.`Column_priv`
`time_zone`.*
`time_zone`.`Time_zone_id`
`time_zone`.`Use_leap_seconds`
`time_zone_leap_second`.*
`time_zone_leap_second`.`Transition_time`
`time_zone_leap_second`.`Correction`
`time_zone_name`.*
`time_zone_name`.`Name`
`time_zone_name`.`Time_zone_id`
`time_zone_transition`.*
`time_zone_transition`.`Time_zone_id`
`time_zone_transition`.`Transition_time`
`time_zone_transition`.`Transition_type_id`
`time_zone_transition_type`.*
`time_zone_transition_type`.`Time_zone_id`
`time_zone_transition_type`.`Transition_type_id`
`time_zone_transition_type`.`Offset`
`time_zone_transition_type`.`Is_DST`
`time_zone_transition_type`.`Abbreviation`
`user`.*
`user`.`Host`
`user`.`User`
`user`.`Password`
`user`.`Select_priv`
`user`.`Insert_priv`
`user`.`Update_priv`
`user`.`Delete_priv`
`user`.`Create_priv`
`user`.`Drop_priv`
`user`.`Reload_priv`
`user`.`Shutdown_priv`
`user`.`Process_priv`
`user`.`File_priv`
`user`.`Grant_priv`
`user`.`References_priv`
`user`.`Index_priv`
`user`.`Alter_priv`
`user`.`Show_db_priv`
`user`.`Super_priv`
`user`.`Create_tmp_table_priv`
`user`.`Lock_tables_priv`
`user`.`Execute_priv`
`user`.`Repl_slave_priv`
`user`.`Repl_client_priv`
`user`.`Create_view_priv`
`user`.`Show_view_priv`
`user`.`Create_routine_priv`
`user`.`Alter_routine_priv`
`user`.`Create_user_priv`
`user`.`Event_priv`
`user`.`Trigger_priv`
`user`.`Create_tablespace_priv`
`user`.`ssl_type`
`user`.`ssl_cipher`
`user`.`x509_issuer`
`user`.`x509_subject`
`user`.`max_questions`
`user`.`max_updates`
`user`.`max_connections`
`user`.`max_user_connections`
`user`.`plugin`
`user`.`authentication_string`
`columns_priv`.*
`columns_priv`.`Host`
`columns_priv`.`Db`
`columns_priv`.`User`
`columns_priv`.`Table_name`
`columns_priv`.`Column_name`
`columns_priv`.`Timestamp`
`columns_priv`.`Column_priv`
`db`.*
`db`.`Host`
`db`.`Db`
`db`.`User`
`db`.`Select_priv`
`db`.`Insert_priv`
`db`.`Update_priv`
`db`.`Delete_priv`
`db`.`Create_priv`
`db`.`Drop_priv`
`db`.`Grant_priv`
`db`.`References_priv`
`db`.`Index_priv`
`db`.`Alter_priv`
`db`.`Create_tmp_table_priv`
`db`.`Lock_tables_priv`
`db`.`Create_view_priv`
`db`.`Show_view_priv`
`db`.`Create_routine_priv`
`db`.`Alter_routine_priv`
`db`.`Execute_priv`
`db`.`Event_priv`
`db`.`Trigger_priv`
`event`.*
`event`.`db`
`event`.`name`
`event`.`body`
`event`.`definer`
`event`.`execute_at`
`event`.`interval_value`
`event`.`interval_field`
`event`.`created`
`event`.`modified`
`event`.`last_executed`
`event`.`starts`
`event`.`ends`
`event`.`status`
`event`.`on_completion`
`event`.`sql_mode`
`event`.`comment`
`event`.`originator`
`event`.`time_zone`
`event`.`character_set_client`
`event`.`collation_connection`
`event`.`db_collation`
`event`.`body_utf8`
`func`.*
`func`.`name`
`func`.`ret`
`func`.`dl`
`func`.`type`
`general_log`.*
`general_log`.`event_time`
`general_log`.`user_host`
`general_log`.`thread_id`
`general_log`.`server_id`
`general_log`.`command_type`
`general_log`.`argument`
`help_category`.*
`help_category`.`help_category_id`
`help_category`.`name`
`help_category`.`parent_category_id`
`help_category`.`url`
`help_keyword`.*
`help_keyword`.`help_keyword_id`
`help_keyword`.`name`
`help_relation`.*
`help_relation`.`help_topic_id`
`help_relation`.`help_keyword_id`
`help_topic`.*
`help_topic`.`help_topic_id`
`help_topic`.`name`
`help_topic`.`help_category_id`
`help_topic`.`description`
`help_topic`.`example`
`help_topic`.`url`
`host`.*
`host`.`Host`
`host`.`Db`
`host`.`Select_priv`
`host`.`Insert_priv`
`host`.`Update_priv`
`host`.`Delete_priv`
`host`.`Create_priv`
`host`.`Drop_priv`
`host`.`Grant_priv`
`host`.`References_priv`
`host`.`Index_priv`
`host`.`Alter_priv`
`host`.`Create_tmp_table_priv`
`host`.`Lock_tables_priv`
`host`.`Create_view_priv`
`host`.`Show_view_priv`
`host`.`Create_routine_priv`
`host`.`Alter_routine_priv`
`host`.`Execute_priv`
`host`.`Trigger_priv`
`ndb_binlog_index`.*
`ndb_binlog_index`.`Position`
`ndb_binlog_index`.`File`
`ndb_binlog_index`.`epoch`
`ndb_binlog_index`.`inserts`
`ndb_binlog_index`.`updates`
`ndb_binlog_index`.`deletes`
`ndb_binlog_index`.`schemaops`
`plugin`.*
`plugin`.`name`
`plugin`.`dl`
`proc`.*
`proc`.`db`
`proc`.`name`
`proc`.`type`
`proc`.`specific_name`
`proc`.`language`
`proc`.`sql_data_access`
`proc`.`is_deterministic`
`proc`.`security_type`
`proc`.`param_list`
`proc`.`returns`
`proc`.`body`
`proc`.`definer`
`proc`.`created`
`proc`.`modified`
`proc`.`sql_mode`
`proc`.`comment`
`proc`.`character_set_client`
`proc`.`collation_connection`
`proc`.`db_collation`
`proc`.`body_utf8`
`procs_priv`.*
`procs_priv`.`Host`
`procs_priv`.`Db`
`procs_priv`.`User`
`procs_priv`.`Routine_name`
`procs_priv`.`Routine_type`
`procs_priv`.`Grantor`
`procs_priv`.`Proc_priv`
`procs_priv`.`Timestamp`
`proxies_priv`.*
`proxies_priv`.`Host`
`proxies_priv`.`User`
`proxies_priv`.`Proxied_host`
`proxies_priv`.`Proxied_user`
`proxies_priv`.`With_grant`
`proxies_priv`.`Grantor`
`proxies_priv`.`Timestamp`
`servers`.*
`servers`.`Server_name`
`servers`.`Host`
`servers`.`Db`
`servers`.`Username`
`servers`.`Password`
`servers`.`Port`
`servers`.`Socket`
`servers`.`Wrapper`
`servers`.`Owner`
`slow_log`.*
`slow_log`.`start_time`
`slow_log`.`user_host`
`slow_log`.`query_time`
`slow_log`.`lock_time`
`slow_log`.`rows_sent`
`slow_log`.`rows_examined`
`slow_log`.`db`
`slow_log`.`last_insert_id`
`slow_log`.`insert_id`
`slow_log`.`server_id`
`slow_log`.`sql_text`
`tables_priv`.*
`tables_priv`.`Host`
`tables_priv`.`Db`
`tables_priv`.`User`
`tables_priv`.`Table_name`
`tables_priv`.`Grantor`
`tables_priv`.`Timestamp`
`tables_priv`.`Table_priv`
`tables_priv`.`Column_priv`
`time_zone`.*
`time_zone`.`Time_zone_id`
`time_zone`.`Use_leap_seconds`
`time_zone_leap_second`.*
`time_zone_leap_second`.`Transition_time`
`time_zone_leap_second`.`Correction`
`time_zone_name`.*
`time_zone_name`.`Name`
`time_zone_name`.`Time_zone_id`
`time_zone_transition`.*
`time_zone_transition`.`Time_zone_id`
`time_zone_transition`.`Transition_time`
`time_zone_transition`.`Transition_type_id`
`time_zone_transition_type`.*
`time_zone_transition_type`.`Time_zone_id`
`time_zone_transition_type`.`Transition_type_id`
`time_zone_transition_type`.`Offset`
`time_zone_transition_type`.`Is_DST`
`time_zone_transition_type`.`Abbreviation`
`user`.*
`user`.`Host`
`user`.`User`
`user`.`Password`
`user`.`Select_priv`
`user`.`Insert_priv`
`user`.`Update_priv`
`user`.`Delete_priv`
`user`.`Create_priv`
`user`.`Drop_priv`
`user`.`Reload_priv`
`user`.`Shutdown_priv`
`user`.`Process_priv`
`user`.`File_priv`
`user`.`Grant_priv`
`user`.`References_priv`
`user`.`Index_priv`
`user`.`Alter_priv`
`user`.`Show_db_priv`
`user`.`Super_priv`
`user`.`Create_tmp_table_priv`
`user`.`Lock_tables_priv`
`user`.`Execute_priv`
`user`.`Repl_slave_priv`
`user`.`Repl_client_priv`
`user`.`Create_view_priv`
`user`.`Show_view_priv`
`user`.`Create_routine_priv`
`user`.`Alter_routine_priv`
`user`.`Create_user_priv`
`user`.`Event_priv`
`user`.`Trigger_priv`
`user`.`Create_tablespace_priv`
`user`.`ssl_type`
`user`.`ssl_cipher`
`user`.`x509_issuer`
`user`.`x509_subject`
`user`.`max_questions`
`user`.`max_updates`
`user`.`max_connections`
`user`.`max_user_connections`
`user`.`plugin`
`user`.`authentication_string`
`columns_priv`.*
`columns_priv`.`Host`
`columns_priv`.`Db`
`columns_priv`.`User`
`columns_priv`.`Table_name`
`columns_priv`.`Column_name`
`columns_priv`.`Timestamp`
`columns_priv`.`Column_priv`
`db`.*
`db`.`Host`
`db`.`Db`
`db`.`User`
`db`.`Select_priv`
`db`.`Insert_priv`
`db`.`Update_priv`
`db`.`Delete_priv`
`db`.`Create_priv`
`db`.`Drop_priv`
`db`.`Grant_priv`
`db`.`References_priv`
`db`.`Index_priv`
`db`.`Alter_priv`
`db`.`Create_tmp_table_priv`
`db`.`Lock_tables_priv`
`db`.`Create_view_priv`
`db`.`Show_view_priv`
`db`.`Create_routine_priv`
`db`.`Alter_routine_priv`
`db`.`Execute_priv`
`db`.`Event_priv`
`db`.`Trigger_priv`
`event`.*
`event`.`db`
`event`.`name`
`event`.`body`
`event`.`definer`
`event`.`execute_at`
`event`.`interval_value`
`event`.`interval_field`
`event`.`created`
`event`.`modified`
`event`.`last_executed`
`event`.`starts`
`event`.`ends`
`event`.`status`
`event`.`on_completion`
`event`.`sql_mode`
`event`.`comment`
`event`.`originator`
`event`.`time_zone`
`event`.`character_set_client`
`event`.`collation_connection`
`event`.`db_collation`
`event`.`body_utf8`
`func`.*
`func`.`name`
`func`.`ret`
`func`.`dl`
`func`.`type`
`general_log`.*
`general_log`.`event_time`
`general_log`.`user_host`
`general_log`.`thread_id`
`general_log`.`server_id`
`general_log`.`command_type`
`general_log`.`argument`
`help_category`.*
`help_category`.`help_category_id`
`help_category`.`name`
`help_category`.`parent_category_id`
`help_category`.`url`
`help_keyword`.*
`help_keyword`.`help_keyword_id`
`help_keyword`.`name`
`help_relation`.*
`help_relation`.`help_topic_id`
`help_relation`.`help_keyword_id`
`help_topic`.*
`help_topic`.`help_topic_id`
`help_topic`.`name`
`help_topic`.`help_category_id`
`help_topic`.`description`
`help_topic`.`example`
`help_topic`.`url`
`host`.*
`host`.`Host`
`host`.`Db`
`host`.`Select_priv`
`host`.`Insert_priv`
`host`.`Update_priv`
`host`.`Delete_priv`
`host`.`Create_priv`
`host`.`Drop_priv`
`host`.`Grant_priv`
`host`.`References_priv`
`host`.`Index_priv`
`host`.`Alter_priv`
`host`.`Create_tmp_table_priv`
`host`.`Lock_tables_priv`
`host`.`Create_view_priv`
`host`.`Show_view_priv`
`host`.`Create_routine_priv`
`host`.`Alter_routine_priv`
`host`.`Execute_priv`
`host`.`Trigger_priv`
`ndb_binlog_index`.*
`ndb_binlog_index`.`Position`
`ndb_binlog_index`.`File`
`ndb_binlog_index`.`epoch`
`ndb_binlog_index`.`inserts`
`ndb_binlog_index`.`updates`
`ndb_binlog_index`.`deletes`
`ndb_binlog_index`.`schemaops`
`plugin`.*
`plugin`.`name`
`plugin`.`dl`
`proc`.*
`proc`.`db`
`proc`.`name`
`proc`.`type`
`proc`.`specific_name`
`proc`.`language`
`proc`.`sql_data_access`
`proc`.`is_deterministic`
`proc`.`security_type`
`proc`.`param_list`
`proc`.`returns`
`proc`.`body`
`proc`.`definer`
`proc`.`created`
`proc`.`modified`
`proc`.`sql_mode`
`proc`.`comment`
`proc`.`character_set_client`
`proc`.`collation_connection`
`proc`.`db_collation`
`proc`.`body_utf8`
`procs_priv`.*
`procs_priv`.`Host`
`procs_priv`.`Db`
`procs_priv`.`User`
`procs_priv`.`Routine_name`
`procs_priv`.`Routine_type`
`procs_priv`.`Grantor`
`procs_priv`.`Proc_priv`
`procs_priv`.`Timestamp`
`proxies_priv`.*
`proxies_priv`.`Host`
`proxies_priv`.`User`
`proxies_priv`.`Proxied_host`
`proxies_priv`.`Proxied_user`
`proxies_priv`.`With_grant`
`proxies_priv`.`Grantor`
`proxies_priv`.`Timestamp`
`servers`.*
`servers`.`Server_name`
`servers`.`Host`
`servers`.`Db`
`servers`.`Username`
`servers`.`Password`
`servers`.`Port`
`servers`.`Socket`
`servers`.`Wrapper`
`servers`.`Owner`
`slow_log`.*
`slow_log`.`start_time`
`slow_log`.`user_host`
`slow_log`.`query_time`
`slow_log`.`lock_time`
`slow_log`.`rows_sent`
`slow_log`.`rows_examined`
`slow_log`.`db`
`slow_log`.`last_insert_id`
`slow_log`.`insert_id`
`slow_log`.`server_id`
`slow_log`.`sql_text`
`tables_priv`.*
`tables_priv`.`Host`
`tables_priv`.`Db`
`tables_priv`.`User`
`tables_priv`.`Table_name`
`tables_priv`.`Grantor`
`tables_priv`.`Timestamp`
`tables_priv`.`Table_priv`
`tables_priv`.`Column_priv`
`time_zone`.*
`time_zone`.`Time_zone_id`
`time_zone`.`Use_leap_seconds`
`time_zone_leap_second`.*
`time_zone_leap_second`.`Transition_time`
`time_zone_leap_second`.`Correction`
`time_zone_name`.*
`time_zone_name`.`Name`
`time_zone_name`.`Time_zone_id`
`time_zone_transition`.*
`time_zone_transition`.`Time_zone_id`
`time_zone_transition`.`Transition_time`
`time_zone_transition`.`Transition_type_id`
`time_zone_transition_type`.*
`time_zone_transition_type`.`Time_zone_id`
`time_zone_transition_type`.`Transition_type_id`
`time_zone_transition_type`.`Offset`
`time_zone_transition_type`.`Is_DST`
`time_zone_transition_type`.`Abbreviation`
`user`.*
`user`.`Host`
`user`.`User`
`user`.`Password`
`user`.`Select_priv`
`user`.`Insert_priv`
`user`.`Update_priv`
`user`.`Delete_priv`
`user`.`Create_priv`
`user`.`Drop_priv`
`user`.`Reload_priv`
`user`.`Shutdown_priv`
`user`.`Process_priv`
`user`.`File_priv`
`user`.`Grant_priv`
`user`.`References_priv`
`user`.`Index_priv`
`user`.`Alter_priv`
`user`.`Show_db_priv`
`user`.`Super_priv`
`user`.`Create_tmp_table_priv`
`user`.`Lock_tables_priv`
`user`.`Execute_priv`
`user`.`Repl_slave_priv`
`user`.`Repl_client_priv`
`user`.`Create_view_priv`
`user`.`Show_view_priv`
`user`.`Create_routine_priv`
`user`.`Alter_routine_priv`
`user`.`Create_user_priv`
`user`.`Event_priv`
`user`.`Trigger_priv`
`user`.`Create_tablespace_priv`
`user`.`ssl_type`
`user`.`ssl_cipher`
`user`.`x509_issuer`
`user`.`x509_subject`
`user`.`max_questions`
`user`.`max_updates`
`user`.`max_connections`
`user`.`max_user_connections`
`user`.`plugin`
`user`.`authentication_string`
Sort:
Ascending
Descending
Ascending
Descending
Ascending
Descending
Show:
Criteria:
Ins:
And:
Del:
Or:
Modify:
Or:
And:
Ins
Del
Or:
And:
Ins
Del
Or:
And:
Ins
Del
Add/Delete criteria rows:
-3
-2
-1
0
1
2
3
Add/Delete columns:
-3
-2
-1
0
1
2
3
Use Tables
columns_priv
db
event
func
general_log
help_category
help_keyword
help_relation
help_topic
host
ndb_binlog_index
plugin
proc
procs_priv
proxies_priv
servers
slow_log
tables_priv
time_zone
time_zone_leap_second
time_zone_name
time_zone_transition
time_zone_transition_type
user
SQL query on database
mysql
: