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 "information_schema" 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
CHARACTER_SETS
CHECK_CONSTRAINTS
COLLATIONS
COLLATION_CHARACTER_SET_APPLICABILITY
COLUMNS
COLUMN_PRIVILEGES
COLUMN_STATISTICS
ENGINES
EVENTS
FILES
INNODB_BUFFER_PAGE
INNODB_BUFFER_PAGE_LRU
INNODB_BUFFER_POOL_STATS
INNODB_CACHED_INDEXES
INNODB_CMP
INNODB_CMPMEM
INNODB_CMPMEM_RESET
INNODB_CMP_PER_INDEX
INNODB_CMP_PER_INDEX_RESET
INNODB_CMP_RESET
INNODB_COLUMNS
INNODB_DATAFILES
INNODB_FIELDS
INNODB_FOREIGN
INNODB_FOREIGN_COLS
INNODB_FT_BEING_DELETED
INNODB_FT_CONFIG
INNODB_FT_DEFAULT_STOPWORD
INNODB_FT_DELETED
INNODB_FT_INDEX_CACHE
INNODB_FT_INDEX_TABLE
INNODB_INDEXES
INNODB_METRICS
INNODB_SESSION_TEMP_TABLESPACES
INNODB_TABLES
INNODB_TABLESPACES
INNODB_TABLESPACES_BRIEF
INNODB_TABLESTATS
INNODB_TEMP_TABLE_INFO
INNODB_TRX
INNODB_VIRTUAL
KEYWORDS
KEY_COLUMN_USAGE
OPTIMIZER_TRACE
PARAMETERS
PARTITIONS
PLUGINS
PROCESSLIST
PROFILING
REFERENTIAL_CONSTRAINTS
RESOURCE_GROUPS
ROUTINES
SCHEMATA
SCHEMA_PRIVILEGES
STATISTICS
ST_GEOMETRY_COLUMNS
ST_SPATIAL_REFERENCE_SYSTEMS
ST_UNITS_OF_MEASURE
TABLES
TABLESPACES
TABLE_CONSTRAINTS
TABLE_PRIVILEGES
TRIGGERS
USER_PRIVILEGES
VIEWS
VIEW_ROUTINE_USAGE
VIEW_TABLE_USAGE
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

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