Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Options
Set default
Collapse Expand Requery Edit Explain Profiling Query failed Database: Queried time:
Edit mode
Customize edit mode.
Edit mode
Documentation Disallow BLOB and BINARY columns from editing. Restore default value
Documentation Display the function fields in edit/insert mode. Restore default value
Documentation Defines whether or not type fields should be initially displayed in edit/insert mode. Restore default value
Documentation How many rows can be inserted at one time. Restore default value
Documentation Sort order for items in a foreign-key dropdown box; content is the referenced data, id is the key value. Restore default value
Documentation A dropdown will be used if fewer items are present. Restore default value
Text fields
Customize text input fields.
Text fields
Documentation Defines which type of editing controls should be used for CHAR and VARCHAR columns; input - allows limiting of input length, textarea - allows newlines in columns. Restore default value
Documentation Defines the minimum size for input fields generated for CHAR and VARCHAR columns. Restore default value
Documentation Defines the maximum size for input fields generated for CHAR and VARCHAR columns. Restore default value
Documentation Number of columns for CHAR/VARCHAR textareas. Restore default value
Documentation Number of rows for CHAR/VARCHAR textareas. Restore default value
Documentation Textarea size (columns) in edit mode, this value will be emphasized for SQL query textareas (*2). Restore default value
Documentation Textarea size (rows) in edit mode, this value will be emphasized for SQL query textareas (*2). Restore default value
Documentation Double size of textarea for LONGTEXT columns. Restore default value
Column Type Function Null Value
Host char(255)
User char(32)
Select_priv enum -- N
Insert_priv enum -- N
Update_priv enum -- N
Delete_priv enum -- N
Create_priv enum -- N
Drop_priv enum -- N
Reload_priv enum -- N
Shutdown_priv enum -- N
Process_priv enum -- N
File_priv enum -- N
Grant_priv enum -- N
References_priv enum -- N
Index_priv enum -- N
Alter_priv enum -- N
Show_db_priv enum -- N
Super_priv enum -- N
Create_tmp_table_priv enum -- N
Lock_tables_priv enum -- N
Execute_priv enum -- N
Repl_slave_priv enum -- N
Repl_client_priv enum -- N
Create_view_priv enum -- N
Show_view_priv enum -- N
Create_routine_priv enum -- N
Alter_routine_priv enum -- N
Create_user_priv enum -- N
Event_priv enum -- N
Trigger_priv enum -- N
Create_tablespace_priv enum -- N
ssl_type enum --
ssl_cipher blob Binary - do not edit (0 B)
(Max: 64KiB)
x509_issuer blob Binary - do not edit (0 B)
(Max: 64KiB)
x509_subject blob Binary - do not edit (0 B)
(Max: 64KiB)
max_questions int(11) unsigned 0
max_updates int(11) unsigned 0
max_connections int(11) unsigned 0
max_user_connections int(11) unsigned 0
plugin char(64) caching_sha2_password
authentication_string text
password_expired enum -- N
password_last_changed timestamp
password_lifetime smallint(5) unsigned
account_locked enum -- N
Create_role_priv enum -- N
Drop_role_priv enum -- N
Password_reuse_history smallint(5) unsigned
Password_reuse_time smallint(5) unsigned
Password_require_current enum --
User_attributes json


Column Type Function Null Value
Host char(255)
User char(32)
Select_priv enum -- N
Insert_priv enum -- N
Update_priv enum -- N
Delete_priv enum -- N
Create_priv enum -- N
Drop_priv enum -- N
Reload_priv enum -- N
Shutdown_priv enum -- N
Process_priv enum -- N
File_priv enum -- N
Grant_priv enum -- N
References_priv enum -- N
Index_priv enum -- N
Alter_priv enum -- N
Show_db_priv enum -- N
Super_priv enum -- N
Create_tmp_table_priv enum -- N
Lock_tables_priv enum -- N
Execute_priv enum -- N
Repl_slave_priv enum -- N
Repl_client_priv enum -- N
Create_view_priv enum -- N
Show_view_priv enum -- N
Create_routine_priv enum -- N
Alter_routine_priv enum -- N
Create_user_priv enum -- N
Event_priv enum -- N
Trigger_priv enum -- N
Create_tablespace_priv enum -- N
ssl_type enum --
ssl_cipher blob Binary - do not edit (0 B)
(Max: 64KiB)
x509_issuer blob Binary - do not edit (0 B)
(Max: 64KiB)
x509_subject blob Binary - do not edit (0 B)
(Max: 64KiB)
max_questions int(11) unsigned 0
max_updates int(11) unsigned 0
max_connections int(11) unsigned 0
max_user_connections int(11) unsigned 0
plugin char(64) caching_sha2_password
authentication_string text
password_expired enum -- N
password_last_changed timestamp
password_lifetime smallint(5) unsigned
account_locked enum -- N
Create_role_priv enum -- N
Drop_role_priv enum -- N
Password_reuse_history smallint(5) unsigned
Password_reuse_time smallint(5) unsigned
Password_require_current enum --
User_attributes json

and then
Use TAB key to move from value to value, or CTRL+arrows to move anywhere.

Continue insertion with rows