Solte os arquivos aqui

SQL upload ( 0 ) x-

Servidor: localhost:3306 »Banco de dados: mysql
Configurações da páginaClique na barra para rolar até o topo da página
Pressione Ctrl+Enter para executar consulta Pressione Enter para executar consulta
ascendente
descendente
Ordem:
Depurar SQL
Contagem
Ordem de execução
Tempo gasto
Ordenar por:
Agrupar consultas
Desagrupar consultas
Recolher Expandir Mostrar rastro Ocultar rastro Contagem Tempo gasto
Favoritos
Atualizar
Adicionar
Sem marcador(es)
Adicionar marcador
Opções
Definir padrão





Recolher Expandir Repetir consulta Editar Demonstrar SQL Perfil Marcadores Falha na consulta Banco de dados : Tempo de execução da consulta :
Sem título *
v Mostrar/ocultar lista de tabelas Ver em tela cheia Adicione tabelas de outra base de dados Nova página Páginas abertas Selecionar página Salvar página como Apagar páginas Criar tabela Criar relacionamento Marque a coluna para exibir Recarregar Ajuda Links angulares / Links diretos Ajustar à grade v Tudo pequeno/grande Mudar para pequeno/grande Alternar linhas de relação Exportar estrutura > Mover Menu > Fixar texto
v v
Número de tabelas: 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
Criar relacionamento
FOREIGN KEY
on delete
on update
Apagar relacionamento