Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: mysql
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress 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:

Export defaults

Customize default export options.

Quick
Custom
SQL

Customize default options.

Structure
Data
CodeGen

Customize default options.

CSV

Customize default options.

CSV
CSV for MS Excel
LaTeX

Customize default options.

Structure
Data
Microsoft Office

Customize default options.

Microsoft Word 2000
OpenDocument

Customize default options.

OpenDocument Spreadsheet
OpenDocument Text
Structure
Data
Texy! text

Customize default options

Data

Export templates:

New template:

Existing templates:

Export method:

Format:

Tables:

TablesStructureData
Select all
columns_priv
column_stats
db
event
func
general_log
gtid_slave_pos
help_category
help_keyword
help_relation
help_topic
host
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
user


Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name

Output:

MiB

Format-specific options:

Scroll down to fill in the options for the selected format and ignore the options for other formats.

PDF

Dump table

CSV

CodeGen

LaTeX

Dump table

Object creation options

Data dump options

PHP array

This format has no options

SQL

Object creation options

  • Add statements:

Data creation options

  • Instead of INSERT statements, use:

  • Syntax to use when inserting data:

YAML

This format has no options

Microsoft Word 2000

Dump table

Data dump options

JSON

XML

Object creation options (all are recommended)

Data dump options

MediaWiki Table

Dump table

OpenDocument Text

Dump table

Object creation options

Data dump options

CSV for MS Excel

OpenDocument Spreadsheet

Texy! text

Dump table

Data dump options