rsthursina.rumah-sakit.online / 127.0.0.1 / mysql

Naviqasiya paneli
Navigation tree
Serverlər
Verilənlər Bazaları
Cədvəllər

Naviqasiya paneli

Naviqasiya panelinin mövzusun(tema) dəyiş.

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Əsas panel ilə əlaqələndir Link with main panel by highlighting the current database or table.
Display logo Naviqasiya panelində logonu göstər.
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.
İlk səviyyədəki maksimum maddə 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.
Son istifadə olunan cədvəllər Ən çox son istifadə olunan cədvəl sayıdır; deaktiv etmək üçün 0 edin.
Favorit cədvəllər Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Navigation tree

Customize the 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.

Serverlər

Serverlərin görüntülənmə seçimləri.

Display servers selection Naviqasiya panelinin yuxarısında server seçimini göstər.
Display servers as a list Show server listing as a list instead of a drop down.

Verilənlər Bazaları

Verilənlər Bazasını görüntülənməsi seçimləri.

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

Cədvəllər

Cədvəllərin görüntülənmə seçimləri.

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

Sorğunu icra etmək üçün Ctrl+Enter düymələrinə basın

Collapse Genişlət Show trace Hide trace Time taken

Əlfəcinlər yoxdur

Etiket: Hədəf verilənlər bazası: Bu əlfəcini paylaş

Sorğu mesajlarını həmişə genişlət
Başlanğıcda sorğu keçmişini göstər
Show current browsing query
Enterə basaraq sorğuları icra edin və Shift+Enter ilə yeni sətir əlavə edin. Bunu həmişəlik etmək üçün tənzimləmələrə baxın.
Qaranlıq temaya keç

Collapse Genişlət Sorğunu təkrarla Redaktə et İzah Et Profilləmə Əlfəcin Sorğu uğursuz oldu Verilənlər Bazası : Queried time :

Başlıqsız *

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

v		mysql column_stats
db_name : varchar(64)
table_name : varchar(64)
column_name : varchar(64)
min_value : varbinary(255)
max_value : varbinary(255)
nulls_ratio : decimal(12,4)
avg_length : decimal(12,4)
avg_frequency : decimal(12,4)
hist_size : tinyint(3) unsigned
hist_type : enum('SINGLE_PREC_HB','DOUBLE_PREC_HB')
histogram : varbinary(255)

v		mysql db
Host : char(60)
Db : char(64)
User : char(80)
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')
Delete_history_priv : enum('N','Y')

v		mysql event
db : char(64)
name : char(64)
body : longblob
definer : char(141)
execute_at : datetime
interval_value : int(11)
interval_field : enum('YEAR','QUARTER','MONTH','DAY','HOUR','MINUTE','WEEK','SECOND','MICROSECOND','YEAR_MONTH','DAY_HOUR','DAY_MINUTE','DAY_SECOND','HOUR_MINUTE','HOUR_SECOND','MINUTE_SECOND','DAY_MICROSECOND','HOUR_MICROSECOND','MINUTE_MICROSECOND','SECOND_MICROSECOND')
created : timestamp
modified : timestamp
last_executed : datetime
starts : datetime
ends : datetime
status : enum('ENABLED','DISABLED','SLAVESIDE_DISABLED')
on_completion : enum('DROP','PRESERVE')
sql_mode : set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT','TIME_ROUND_FRACTIONAL')
comment : char(64)
originator : int(10) unsigned
time_zone : char(64)
character_set_client : char(32)
collation_connection : char(32)
db_collation : char(32)
body_utf8 : longblob

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

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

v		mysql global_priv
Host : char(60)
User : char(80)
Priv : longtext

v		mysql gtid_slave_pos
domain_id : int(10) unsigned
sub_id : bigint(20) unsigned
server_id : int(10) unsigned
seq_no : bigint(20) unsigned

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

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

v		mysql help_relation
help_topic_id : int(10) unsigned
help_keyword_id : int(10) unsigned

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

v		mysql index_stats
db_name : varchar(64)
table_name : varchar(64)
index_name : varchar(64)
prefix_arity : int(11) unsigned
avg_frequency : decimal(12,4)

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(20) unsigned
sample_size : bigint(20) unsigned
stat_description : varchar(1024)

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

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

v		mysql proc
db : char(64)
name : char(64)
type : enum('FUNCTION','PROCEDURE','PACKAGE','PACKAGE BODY')
specific_name : char(64)
language : enum('SQL')
sql_data_access : enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA')
is_deterministic : enum('YES','NO')
security_type : enum('INVOKER','DEFINER')
param_list : blob
returns : longblob
body : longblob
definer : char(141)
created : timestamp
modified : timestamp
sql_mode : set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT','TIME_ROUND_FRACTIONAL')
comment : text
character_set_client : char(32)
collation_connection : char(32)
db_collation : char(32)
body_utf8 : longblob
aggregate : enum('NONE','GROUP')

v		mysql procs_priv
Host : char(60)
Db : char(64)
User : char(80)
Routine_name : char(64)
Routine_type : enum('FUNCTION','PROCEDURE','PACKAGE','PACKAGE BODY')
Grantor : char(141)
Proc_priv : set('Execute','Alter Routine','Grant')
Timestamp : timestamp

v		mysql proxies_priv
Host : char(60)
User : char(80)
Proxied_host : char(60)
Proxied_user : char(80)
With_grant : tinyint(1)
Grantor : char(141)
Timestamp : timestamp

v		mysql roles_mapping
Host : char(60)
User : char(80)
Role : char(80)
Admin_option : enum('N','Y')

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

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

v		mysql tables_priv
Host : char(60)
Db : char(64)
User : char(80)
Table_name : char(64)
Grantor : char(141)
Timestamp : timestamp
Table_priv : set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger','Delete versioning rows')
Column_priv : set('Select','Insert','Update','References')

v		mysql table_stats
db_name : varchar(64)
table_name : varchar(64)
cardinality : bigint(21) unsigned

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

v		mysql time_zone_leap_second
Transition_time : bigint(20)
Correction : int(11)

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

v		mysql time_zone_transition
Time_zone_id : int(10) unsigned
Transition_time : bigint(20)
Transition_type_id : int(10) unsigned

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

v		mysql transaction_registry
transaction_id : bigint(20) unsigned
commit_id : bigint(20) unsigned
begin_timestamp : timestamp(6)
commit_timestamp : timestamp(6)
isolation_level : enum('READ-UNCOMMITTED','READ-COMMITTED','REPEATABLE-READ','SERIALIZABLE')

v		mysql user
Host : char(60)
User : char(80)
Password : longtext
Select_priv : varchar(1)
Insert_priv : varchar(1)
Update_priv : varchar(1)
Delete_priv : varchar(1)
Create_priv : varchar(1)
Drop_priv : varchar(1)
Reload_priv : varchar(1)
Shutdown_priv : varchar(1)
Process_priv : varchar(1)
File_priv : varchar(1)
Grant_priv : varchar(1)
References_priv : varchar(1)
Index_priv : varchar(1)
Alter_priv : varchar(1)
Show_db_priv : varchar(1)
Super_priv : varchar(1)
Create_tmp_table_priv : varchar(1)
Lock_tables_priv : varchar(1)
Execute_priv : varchar(1)
Repl_slave_priv : varchar(1)
Repl_client_priv : varchar(1)
Create_view_priv : varchar(1)
Show_view_priv : varchar(1)
Create_routine_priv : varchar(1)
Alter_routine_priv : varchar(1)
Create_user_priv : varchar(1)
Event_priv : varchar(1)
Trigger_priv : varchar(1)
Create_tablespace_priv : varchar(1)
Delete_history_priv : varchar(1)
ssl_type : varchar(9)
ssl_cipher : longtext
x509_issuer : longtext
x509_subject : longtext
max_questions : bigint(20) unsigned
max_updates : bigint(20) unsigned
max_connections : bigint(20) unsigned
max_user_connections : bigint(21)
plugin : longtext
authentication_string : longtext
password_expired : varchar(1)
is_role : varchar(1)
default_role : longtext
max_statement_time : decimal(12,6)

Create relationship
FOREIGN KEY
on delete
on update