Dosyaları buraya bırakın

SQL gönderme ( 0 ) x -

Sayfa ile ilgili ayarlar Sayfanın en üstüne kaydırmak için çubuğa tklayın
Sorguyu çalıştırmak için Ctrl+Enter tuşlarına basın Sorguyu çalıştırmak için Enter tuşuna basın
küçükten büyüğe
büyükten küçüğe
Sıra:
SQL Hata Ayıklama
Sayı
Çalıştırma sırası
Aldığı süre
Sıralama:
Sorguları grupla
Sorguların grubunu kaldır
Daralt Genişlet İzi göster İzi gizle Sayı: Aldığı süre:
Seçenekler
Varsayılan değerlere geri yükle
Daralt Genişlet Yeniden sorgula Düzenle Açıkla Profil çıkarma Sorgu başarısız oldu Database: Sorgu süresi:
Başlıksız *
v Tablolar listesini göster/gizle Tam ekran görünümü Diğer veritabanlarında tabloları ekle Yeni sayfa Sayfayı aç Sayfayı kaydet Sayfayı farklı kaydet Sayfaları sil Tablo oluştur İlişki oluştur Göstermek için sütun seçin Yeniden yükle Yardım Yönlendirmeli bağlantılar / Doğrudan bağlantılar Kılavuza uydur v Tümünü Küçült/Büyült Küçüğü/büyüğü değiştir İlişki satırlarını değiştir Şemayı dışa aktar > Menüyü taşı > Metni sabitle
v v
Tablo sayısı: 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(10) unsigned
* component_group_id : int(10) 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(11)
* cost_name : varchar(64)
* cost_value : float
* last_update : timestamp
* comment : varchar(1024)
* default_value : float
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 : 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(20)
* interval_end : bigint(20)
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 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 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 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(4)
* 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(10) unsigned
* Master_log_name : text
* Master_log_pos : bigint(20) unsigned
* Host : char(255)
* User_name : text
* User_password : text
* Port : int(10) unsigned
* Connect_retry : int(10) 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(20) unsigned
* Ssl_crl : text
* Ssl_crlpath : text
* Enabled_auto_position : tinyint(1)
* Channel_name : char(64)
* Tls_version : text
* Public_key_path : text
* Get_public_key : tinyint(1)
* Network_namespace : text
* Master_compression_algorithm : char(64)
* Master_zstd_compression_level : int(10) unsigned
v mysql slave_relay_log_info
* Number_of_lines : int(10) unsigned
* Relay_log_name : text
* Relay_log_pos : bigint(20) unsigned
* Master_log_name : text
* Master_log_pos : bigint(20) unsigned
* Sql_delay : int(11)
* Number_of_workers : int(10) unsigned
* Id : int(10) unsigned
* Channel_name : char(64)
* Privilege_checks_username : char(32)
* Privilege_checks_hostname : char(255)
v mysql slave_worker_info
* Id : int(10) unsigned
* Relay_log_name : text
* Relay_log_pos : bigint(20) unsigned
* Master_log_name : text
* Master_log_pos : bigint(20) unsigned
* Checkpoint_relay_log_name : text
* Checkpoint_relay_log_pos : bigint(20) unsigned
* Checkpoint_master_log_name : text
* Checkpoint_master_log_pos : bigint(20) unsigned
* Checkpoint_seqno : int(10) unsigned
* Checkpoint_group_size : int(10) unsigned
* Checkpoint_group_bitmap : blob
* Channel_name : 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 : mediumblob
* thread_id : bigint(21) 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(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 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(11) unsigned
* max_updates : int(11) unsigned
* max_connections : int(11) unsigned
* max_user_connections : int(11) unsigned
* plugin : char(64)
* authentication_string : text
* password_expired : enum('N','Y')
* password_last_changed : timestamp
* password_lifetime : smallint(5) unsigned
* account_locked : enum('N','Y')
* Create_role_priv : enum('N','Y')
* Drop_role_priv : enum('N','Y')
* Password_reuse_history : smallint(5) unsigned
* Password_reuse_time : smallint(5) unsigned
* Password_require_current : enum('N','Y')
* User_attributes : json
İlişki oluştur
FOREIGN KEY
on delete
on update
İlişkiyi sil