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 :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark 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
id int(10) unsigned
userID int(11)
app_name varchar(100)
from_name varchar(100)
from_email varchar(100)
reply_to varchar(100)
currency varchar(100)
delivery_fee varchar(100)
cost_per_recipient varchar(100)
smtp_host varchar(100)
smtp_port varchar(100)
smtp_ssl varchar(100)
smtp_username varchar(100)
smtp_password varchar(100)
bounce_setup int(11) 0
complaint_setup int(11) 0
app_key varchar(100)
allocated_quota int(11) -1
current_quota int(11) 0
day_of_reset int(11) 1
month_of_next_reset varchar(3)
year_of_next_reset varchar(4)
no_expiry int(11) 0
test_email varchar(100)
brand_logo_filename varchar(100)
allowed_attachments varchar(100) jpeg,jpg,gif,png,pdf,zip
reports_only int(11) 0
campaigns_only int(11) 0
templates_only int(11) 0
lists_only int(11) 0
notify_campaign_sent int(11) 1
campaign_report_rows int(11) 10
query_string varchar(500)
gdpr_only int(11) 0
gdpr_options int(11) 1
gdpr_only_ar int(11) 0
recaptcha_sitekey varchar(50)
recaptcha_secretkey varchar(50)
custom_domain varchar(100)
custom_domain_protocol varchar(5)
custom_domain_enabled int(11) 0
test_email_prefix varchar(100)
templates_lists_sorting varchar(4) date
opens_tracking int(11) 1
links_tracking int(11) 1
is_sendybay_account_paused tinyint(1) 0
account_paused_reason varchar(1000)
sb_db_migration_version varchar(64) 0
hide_lists int(11) 1
opt_in int(11) 0


Column Type Function Null Value
id int(10) unsigned
userID int(11)
app_name varchar(100)
from_name varchar(100)
from_email varchar(100)
reply_to varchar(100)
currency varchar(100)
delivery_fee varchar(100)
cost_per_recipient varchar(100)
smtp_host varchar(100)
smtp_port varchar(100)
smtp_ssl varchar(100)
smtp_username varchar(100)
smtp_password varchar(100)
bounce_setup int(11) 0
complaint_setup int(11) 0
app_key varchar(100)
allocated_quota int(11) -1
current_quota int(11) 0
day_of_reset int(11) 1
month_of_next_reset varchar(3)
year_of_next_reset varchar(4)
no_expiry int(11) 0
test_email varchar(100)
brand_logo_filename varchar(100)
allowed_attachments varchar(100) jpeg,jpg,gif,png,pdf,zip
reports_only int(11) 0
campaigns_only int(11) 0
templates_only int(11) 0
lists_only int(11) 0
notify_campaign_sent int(11) 1
campaign_report_rows int(11) 10
query_string varchar(500)
gdpr_only int(11) 0
gdpr_options int(11) 1
gdpr_only_ar int(11) 0
recaptcha_sitekey varchar(50)
recaptcha_secretkey varchar(50)
custom_domain varchar(100)
custom_domain_protocol varchar(5)
custom_domain_enabled int(11) 0
test_email_prefix varchar(100)
templates_lists_sorting varchar(4) date
opens_tracking int(11) 1
links_tracking int(11) 1
is_sendybay_account_paused tinyint(1) 0
account_paused_reason varchar(1000)
sb_db_migration_version varchar(64) 0
hide_lists int(11) 1
opt_in int(11) 0

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

Continue insertion with rows