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 :

Export Exporting tables from "mysql" database

Export defaults
Customize default export options.
Export defaults
Restore default value
Quick
Restore default value
Restore default value
Custom
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
SQL
Customize default options.
SQL
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Structure
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Data
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
CodeGen
Customize default options.
CodeGen
Restore default value
CSV
Customize default options.
CSV
CSV
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
CSV for MS Excel
Restore default value
Restore default value
Restore default value
Restore default value
LaTeX
Customize default options.
LaTeX
Restore default value
Restore default value
Structure
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Data
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Microsoft Office
Customize default options.
Microsoft Office
Microsoft Word 2000
Restore default value
Restore default value
Restore default value
OpenDocument
Customize default options.
OpenDocument
OpenDocument Spreadsheet
Restore default value
Restore default value
OpenDocument Text
Restore default value
Structure
Restore default value
Restore default value
Restore default value
Data
Restore default value
Restore default value
Texy! text
Customize default options
Texy! text
Restore default value
Data
Restore default value
Restore default value
Export method:
Format:
Tables:
Tables Structure Data
Select all
columns_priv
column_stats
db
event
func
general_log
global_priv
gtid_slave_pos
help_category
help_keyword
help_relation
help_topic
index_stats
innodb_index_stats
innodb_table_stats
plugin
proc
procs_priv
proxies_priv
roles_mapping
servers
slow_log
tables_priv
table_stats
time_zone
time_zone_leap_second
time_zone_name
time_zone_transition
time_zone_transition_type
transaction_registry
user
Output:
  • The size is measured in MiB.
Format-specific options:

CodeGen

CSV

CSV for MS Excel

JSON

LaTeX

Dump table
Object creation options
Data dump options

MediaWiki Table

Dump table

Microsoft Word 2000

Dump table
Data dump options

OpenDocument Spreadsheet

OpenDocument Text

Dump table
Object creation options
Data dump options

PDF

Dump table

PHP array

This format has no options

SQL

Object creation options
  • Add statements:
Data creation options
  • Syntax to use when inserting data:

Texy! text

Dump table
Data dump options

XML

Object creation options (all are recommended)
Data dump options

YAML

This format has no options