Aruncă fișiere aici

SQL upload ( 0 ) x -

Setări legate de pagini Dă clic pe bară pentru a derula în partea de sus a paginii
Apasă Ctrl+Enter pentru a executa interogarea Apasă Enter pentru a executa interogarea
crescător
descrescător
Ordine:
Depanare SQL
Număr
Ordine de execuție
Timp luat
Ordonează după:
Grupează interogările
Degrupează interogările
Restrânge Extinde Arată urmărirea Ascunde urmărirea Număr : Timp luat :
Semne de carte
Reîmprospătează
Adaugă
Niciun semn de carte
Adaugă semn de carte
Opțiuni
Setează la implicit





Restrânge Extinde Reinterogare Editează Explică Creez profilul Semn de carte Interogare eșuată Bază de date : Timp de interogare :
Fără titlu *
v Arată/ascunde lista de tabele Vezi în ecran complet Adaugă tabele din alte baze de date Pagină nouă Deschide pagina Salvează pagina Salvează pagina ca Șterge paginile Creează tabel Creează relație Alege coloana pentru afișare Reîncarcă Ajutor Legături unghiulare / Legături directe Snap to grid v Tot mic/mare Comută pe mic/mare Comută liniile de relație Exportă schema > Mută meniul > Prinde textul
v v
Număr de tabele: 0
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
Creează relație
FOREIGN KEY
on delete
on update
Șterge relația