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:

Import Importing into the database "mysql"

Import defaults
Customise default common import options.
Import defaults
Default format; be aware that this list depends on location (database, table) and only SQL is always available. Restore default value
Restore default value
Allow interrupt of import in case script detects it is close to time limit. This might be a good way to import large files, however it can break transactions. Restore default value
Number of queries to skip from start. Restore default value
Documentation Uncheck the checkbox to disable drag and drop import Restore default value
SQL
Customise default options.
SQL
Restore default value
Restore default value
Restore default value
CSV
Customise default options.
CSV
CSV
Update data when duplicate keys found on import Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
CSV using LOAD DATA
Update data when duplicate keys found on import Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
OpenDocument
Customise default options.
OpenDocument
Open-Document Spreadsheet
Restore default value
Restore default value
Restore default value
Restore default value
ajax clock
File to import:

File may be compressed (gzip, bzip2, zip) or uncompressed.
A compressed file's name must end in .[format].[compression]. Example: .sql.zip

You may also drag and drop a file on any page.

Partial import:
This might be a good way to import large files, however it can break transactions.
Other options
Format
Format-specific options:

CSV

ESRI Shape File

This format has no options

MediaWiki Table

This format has no options

OpenDocument Spreadsheet

SQL

XML

This format has no options