dionsubaktiar.site / 127.0.0.1 / mysql

`mysql`.`func`

There are no favorite tables.

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :

Untitled *

v		mysql columns_priv
Host : char(255)
Db : char(64)
User : char(32)
Table_name : char(64)
Column_name : char(64)
Timestamp : timestamp
Column_priv : set('Select','Insert','Update','References')

v		mysql component
component_id : int unsigned
component_group_id : int unsigned
component_urn : text

v		mysql db
Host : char(255)
Db : char(64)
User : char(32)
Select_priv : enum('N','Y')
Insert_priv : enum('N','Y')
Update_priv : enum('N','Y')
Delete_priv : enum('N','Y')
Create_priv : enum('N','Y')
Drop_priv : enum('N','Y')
Grant_priv : enum('N','Y')
References_priv : enum('N','Y')
Index_priv : enum('N','Y')
Alter_priv : enum('N','Y')
Create_tmp_table_priv : enum('N','Y')
Lock_tables_priv : enum('N','Y')
Create_view_priv : enum('N','Y')
Show_view_priv : enum('N','Y')
Create_routine_priv : enum('N','Y')
Alter_routine_priv : enum('N','Y')
Execute_priv : enum('N','Y')
Event_priv : enum('N','Y')
Trigger_priv : enum('N','Y')

v		mysql default_roles
HOST : char(255)
USER : char(32)
DEFAULT_ROLE_HOST : char(255)
DEFAULT_ROLE_USER : char(32)

v		mysql engine_cost
engine_name : varchar(64)
device_type : int
cost_name : varchar(64)
cost_value : float
last_update : timestamp
comment : varchar(1024)
default_value : float

v		mysql func
name : char(64)
ret : tinyint
dl : char(128)
type : enum('function','aggregate')

v		mysql general_log
event_time : timestamp(6)
user_host : mediumtext
thread_id : bigint unsigned
server_id : int unsigned
command_type : varchar(64)
argument : mediumblob

v		mysql global_grants
USER : char(32)
HOST : char(255)
PRIV : char(32)
WITH_GRANT_OPTION : enum('N','Y')

v		mysql gtid_executed
source_uuid : char(36)
interval_start : bigint
interval_end : bigint

v		mysql help_category
help_category_id : smallint unsigned
name : char(64)
parent_category_id : smallint unsigned
url : text

v		mysql help_keyword
help_keyword_id : int unsigned
name : char(64)

v		mysql help_relation
help_topic_id : int unsigned
help_keyword_id : int unsigned

v		mysql help_topic
help_topic_id : int unsigned
name : char(64)
help_category_id : smallint unsigned
description : text
example : text
url : text

v		mysql innodb_index_stats
database_name : varchar(64)
table_name : varchar(199)
index_name : varchar(64)
last_update : timestamp
stat_name : varchar(64)
stat_value : bigint unsigned
sample_size : bigint unsigned
stat_description : varchar(1024)

v		mysql innodb_table_stats
database_name : varchar(64)
table_name : varchar(199)
last_update : timestamp
n_rows : bigint unsigned
clustered_index_size : bigint unsigned
sum_of_other_index_sizes : bigint unsigned

v		mysql password_history
Host : char(255)
User : char(32)
Password_timestamp : timestamp(6)
Password : text

v		mysql plugin
name : varchar(64)
dl : varchar(128)

v		mysql procs_priv
Host : char(255)
Db : char(64)
User : char(32)
Routine_name : char(64)
Routine_type : enum('FUNCTION','PROCEDURE')
Grantor : varchar(288)
Proc_priv : set('Execute','Alter Routine','Grant')
Timestamp : timestamp

v		mysql proxies_priv
Host : char(255)
User : char(32)
Proxied_host : char(255)
Proxied_user : char(32)
With_grant : tinyint(1)
Grantor : varchar(288)
Timestamp : timestamp

v		mysql replication_asynchronous_connection_failover
Channel_name : char(64)
Host : char(255)
Port : int unsigned
Network_namespace : char(64)
Weight : tinyint unsigned
Managed_name : char(64)

v		mysql replication_asynchronous_connection_failover_managed
Channel_name : char(64)
Managed_name : char(64)
Managed_type : char(64)
Configuration : json

v		mysql replication_group_configuration_version
name : char(255)
version : bigint unsigned

v		mysql replication_group_member_actions
name : char(255)
event : char(64)
enabled : tinyint(1)
type : char(64)
priority : tinyint unsigned
error_handling : char(64)

v		mysql role_edges
FROM_HOST : char(255)
FROM_USER : char(32)
TO_HOST : char(255)
TO_USER : char(32)
WITH_ADMIN_OPTION : enum('N','Y')

v		mysql servers
Server_name : char(64)
Host : char(255)
Db : char(64)
Username : char(64)
Password : char(64)
Port : int
Socket : char(64)
Wrapper : char(64)
Owner : char(64)

v		mysql server_cost
cost_name : varchar(64)
cost_value : float
last_update : timestamp
comment : varchar(1024)
default_value : float

v		mysql slave_master_info
Number_of_lines : int unsigned
Master_log_name : text
Master_log_pos : bigint unsigned
Host : varchar(255)
User_name : text
User_password : text
Port : int unsigned
Connect_retry : int unsigned
Enabled_ssl : tinyint(1)
Ssl_ca : text
Ssl_capath : text
Ssl_cert : text
Ssl_cipher : text
Ssl_key : text
Ssl_verify_server_cert : tinyint(1)
Heartbeat : float
Bind : text
Ignored_server_ids : text
Uuid : text
Retry_count : bigint unsigned
Ssl_crl : text
Ssl_crlpath : text
Enabled_auto_position : tinyint(1)
Channel_name : varchar(64)
Tls_version : text
Public_key_path : text
Get_public_key : tinyint(1)
Network_namespace : text
Master_compression_algorithm : varchar(64)
Master_zstd_compression_level : int unsigned
Tls_ciphersuites : text
Source_connection_auto_failover : tinyint(1)
Gtid_only : tinyint(1)

v		mysql slave_relay_log_info
Number_of_lines : int unsigned
Relay_log_name : text
Relay_log_pos : bigint unsigned
Master_log_name : text
Master_log_pos : bigint unsigned
Sql_delay : int
Number_of_workers : int unsigned
Id : int unsigned
Channel_name : varchar(64)
Privilege_checks_username : varchar(32)
Privilege_checks_hostname : varchar(255)
Require_row_format : tinyint(1)
Require_table_primary_key_check : enum('STREAM','ON','OFF','GENERATE')
Assign_gtids_to_anonymous_transactions_type : enum('OFF','LOCAL','UUID')
Assign_gtids_to_anonymous_transactions_value : text

v		mysql slave_worker_info
Id : int unsigned
Relay_log_name : text
Relay_log_pos : bigint unsigned
Master_log_name : text
Master_log_pos : bigint unsigned
Checkpoint_relay_log_name : text
Checkpoint_relay_log_pos : bigint unsigned
Checkpoint_master_log_name : text
Checkpoint_master_log_pos : bigint unsigned
Checkpoint_seqno : int unsigned
Checkpoint_group_size : int unsigned
Checkpoint_group_bitmap : blob
Channel_name : varchar(64)

v		mysql slow_log
start_time : timestamp(6)
user_host : mediumtext
query_time : time(6)
lock_time : time(6)
rows_sent : int
rows_examined : int
db : varchar(512)
last_insert_id : int
insert_id : int
server_id : int unsigned
sql_text : mediumblob
thread_id : bigint unsigned

v		mysql tables_priv
Host : char(255)
Db : char(64)
User : char(32)
Table_name : char(64)
Grantor : varchar(288)
Timestamp : timestamp
Table_priv : set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger')
Column_priv : set('Select','Insert','Update','References')

v		mysql time_zone
Time_zone_id : int unsigned
Use_leap_seconds : enum('Y','N')

v		mysql time_zone_leap_second
Transition_time : bigint
Correction : int

v		mysql time_zone_name
Name : char(64)
Time_zone_id : int unsigned

v		mysql time_zone_transition
Time_zone_id : int unsigned
Transition_time : bigint
Transition_type_id : int unsigned

v		mysql time_zone_transition_type
Time_zone_id : int unsigned
Transition_type_id : int unsigned
Offset : int
Is_DST : tinyint unsigned
Abbreviation : char(8)

v		mysql user
Host : char(255)
User : char(32)
Select_priv : enum('N','Y')
Insert_priv : enum('N','Y')
Update_priv : enum('N','Y')
Delete_priv : enum('N','Y')
Create_priv : enum('N','Y')
Drop_priv : enum('N','Y')
Reload_priv : enum('N','Y')
Shutdown_priv : enum('N','Y')
Process_priv : enum('N','Y')
File_priv : enum('N','Y')
Grant_priv : enum('N','Y')
References_priv : enum('N','Y')
Index_priv : enum('N','Y')
Alter_priv : enum('N','Y')
Show_db_priv : enum('N','Y')
Super_priv : enum('N','Y')
Create_tmp_table_priv : enum('N','Y')
Lock_tables_priv : enum('N','Y')
Execute_priv : enum('N','Y')
Repl_slave_priv : enum('N','Y')
Repl_client_priv : enum('N','Y')
Create_view_priv : enum('N','Y')
Show_view_priv : enum('N','Y')
Create_routine_priv : enum('N','Y')
Alter_routine_priv : enum('N','Y')
Create_user_priv : enum('N','Y')
Event_priv : enum('N','Y')
Trigger_priv : enum('N','Y')
Create_tablespace_priv : enum('N','Y')
ssl_type : enum('','ANY','X509','SPECIFIED')
ssl_cipher : blob
x509_issuer : blob
x509_subject : blob
max_questions : int unsigned
max_updates : int unsigned
max_connections : int unsigned
max_user_connections : int unsigned
plugin : char(64)
authentication_string : text
password_expired : enum('N','Y')
password_last_changed : timestamp
password_lifetime : smallint unsigned
account_locked : enum('N','Y')
Create_role_priv : enum('N','Y')
Drop_role_priv : enum('N','Y')
Password_reuse_history : smallint unsigned
Password_reuse_time : smallint unsigned
Password_require_current : enum('N','Y')
User_attributes : json

Create relationship
FOREIGN KEY
on delete
on update