Thả tập tin vào đây

SQL upload ( 0 ) x -

Cài đặt liên quan đến trang Bấm vào thanh để cuộn lên đỉnh trang
Nhấn Ctrl+Enter để thực thi truy vấn Nhấn Enter để thực thi truy vấn
tăng dần
giảm dần
Thứ tự:
Gỡ rối SQL
Số lượng
Thứ tự thực thi
Thời gian cần
Xếp theo:
Nhóm truy vấn
Bỏ nhóm các truy vấn
Co lại Mở rộng Hiện theo dõi Ẩn theo dõi Số lượng : Thời gian cần :
Đánh dấu
Làm tươi lại
Thêm
Không có đánh dấu nào
Thêm đánh dấu
Tùy chọn
Đặt lại thành mặc định





Co lại Mở rộng Truy vấn lại Sửa Giải thích Hồ sơ Đánh dấu Truy vấn bị lỗi Cơ sở dữ liệu : Thời gian truy vấn :
Chưa đặt tên *
v Hiện/Ẩn danh sách bảng Hiển thị toàn màn hình Thêm bảng từ cơ sở dữ liệu khác Trang mới Mở trang Ghi lại trang Ghi trang bằng tên mới Xóa trang Tạo bảng Create relationship Chọn cột bạn muốn hiển thị Tải lại Trợ giúp Các liên kết góc / Liên kết trực tiếp Dính lưới v Nhỏ/To tất cả Bật/tắt lớn/nhỏ Toggle relationship lines Xuất lược đồ > Di chuyển trình đơn > Đóng đinh chữ
v v
Số lượng bảng: 0
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 : varchar(2048)
* Db : char(64)
* Username : char(80)
* Password : char(64)
* Port : int(4)
* Socket : char(64)
* Wrapper : char(64)
* Owner : varchar(512)
v mysql slow_log
* start_time : timestamp(6)
* user_host : mediumtext
* query_time : time(6)
* lock_time : time(6)
* rows_sent : bigint(20) unsigned
* rows_examined : bigint(20) unsigned
* 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
Delete relationship