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
name varchar(100)
email varchar(100)
token varchar(50)
language varchar(10)
status varchar(1) S
id int(11)
profile mediumtext
created timestamp current_timestamp()
updated int(11) 0
last_activity int(11) 0
followup_step tinyint(4) 0
followup_time bigint(20) 0
followup tinyint(4) 0
surname varchar(100)
sex char(1) n
feed_time bigint(20) 0
feed tinyint(4) 0
referrer varchar(50)
ip varchar(50)
wp_user_id int(11) 0
http_referer varchar(255)
geo tinyint(4) 0
country varchar(4)
region varchar(100)
city varchar(100)
bounce_type varchar(50)
bounce_time int(11) 0
unsub_email_id int(11) 0
unsub_time int(11) 0
list_1 tinyint(4) 0
list_2 tinyint(4) 0
list_3 tinyint(4) 0
list_4 tinyint(4) 0
list_5 tinyint(4) 0
list_6 tinyint(4) 0
list_7 tinyint(4) 0
list_8 tinyint(4) 0
list_9 tinyint(4) 0
list_10 tinyint(4) 0
list_11 tinyint(4) 0
list_12 tinyint(4) 0
list_13 tinyint(4) 0
list_14 tinyint(4) 0
list_15 tinyint(4) 0
list_16 tinyint(4) 0
list_17 tinyint(4) 0
list_18 tinyint(4) 0
list_19 tinyint(4) 0
list_20 tinyint(4) 0
list_21 tinyint(4) 0
list_22 tinyint(4) 0
list_23 tinyint(4) 0
list_24 tinyint(4) 0
list_25 tinyint(4) 0
list_26 tinyint(4) 0
list_27 tinyint(4) 0
list_28 tinyint(4) 0
list_29 tinyint(4) 0
list_30 tinyint(4) 0
list_31 tinyint(4) 0
list_32 tinyint(4) 0
list_33 tinyint(4) 0
list_34 tinyint(4) 0
list_35 tinyint(4) 0
list_36 tinyint(4) 0
list_37 tinyint(4) 0
list_38 tinyint(4) 0
list_39 tinyint(4) 0
list_40 tinyint(4) 0
profile_1 varchar(255)
profile_2 varchar(255)
profile_3 varchar(255)
profile_4 varchar(255)
profile_5 varchar(255)
profile_6 varchar(255)
profile_7 varchar(255)
profile_8 varchar(255)
profile_9 varchar(255)
profile_10 varchar(255)
profile_11 varchar(255)
profile_12 varchar(255)
profile_13 varchar(255)
profile_14 varchar(255)
profile_15 varchar(255)
profile_16 varchar(255)
profile_17 varchar(255)
profile_18 varchar(255)
profile_19 varchar(255)
profile_20 varchar(255)
test tinyint(4) 0
source varchar(50)


Column Type Function Null Value
name varchar(100)
email varchar(100)
token varchar(50)
language varchar(10)
status varchar(1) S
id int(11)
profile mediumtext
created timestamp current_timestamp()
updated int(11) 0
last_activity int(11) 0
followup_step tinyint(4) 0
followup_time bigint(20) 0
followup tinyint(4) 0
surname varchar(100)
sex char(1) n
feed_time bigint(20) 0
feed tinyint(4) 0
referrer varchar(50)
ip varchar(50)
wp_user_id int(11) 0
http_referer varchar(255)
geo tinyint(4) 0
country varchar(4)
region varchar(100)
city varchar(100)
bounce_type varchar(50)
bounce_time int(11) 0
unsub_email_id int(11) 0
unsub_time int(11) 0
list_1 tinyint(4) 0
list_2 tinyint(4) 0
list_3 tinyint(4) 0
list_4 tinyint(4) 0
list_5 tinyint(4) 0
list_6 tinyint(4) 0
list_7 tinyint(4) 0
list_8 tinyint(4) 0
list_9 tinyint(4) 0
list_10 tinyint(4) 0
list_11 tinyint(4) 0
list_12 tinyint(4) 0
list_13 tinyint(4) 0
list_14 tinyint(4) 0
list_15 tinyint(4) 0
list_16 tinyint(4) 0
list_17 tinyint(4) 0
list_18 tinyint(4) 0
list_19 tinyint(4) 0
list_20 tinyint(4) 0
list_21 tinyint(4) 0
list_22 tinyint(4) 0
list_23 tinyint(4) 0
list_24 tinyint(4) 0
list_25 tinyint(4) 0
list_26 tinyint(4) 0
list_27 tinyint(4) 0
list_28 tinyint(4) 0
list_29 tinyint(4) 0
list_30 tinyint(4) 0
list_31 tinyint(4) 0
list_32 tinyint(4) 0
list_33 tinyint(4) 0
list_34 tinyint(4) 0
list_35 tinyint(4) 0
list_36 tinyint(4) 0
list_37 tinyint(4) 0
list_38 tinyint(4) 0
list_39 tinyint(4) 0
list_40 tinyint(4) 0
profile_1 varchar(255)
profile_2 varchar(255)
profile_3 varchar(255)
profile_4 varchar(255)
profile_5 varchar(255)
profile_6 varchar(255)
profile_7 varchar(255)
profile_8 varchar(255)
profile_9 varchar(255)
profile_10 varchar(255)
profile_11 varchar(255)
profile_12 varchar(255)
profile_13 varchar(255)
profile_14 varchar(255)
profile_15 varchar(255)
profile_16 varchar(255)
profile_17 varchar(255)
profile_18 varchar(255)
profile_19 varchar(255)
profile_20 varchar(255)
test tinyint(4) 0
source varchar(50)

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

Continue insertion with rows