Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: warehouse
Page-related settingsClick 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 defaults

Customize default common import options.

Default format; be aware that this list depends on location (database, table) and only SQL is always available.
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.
Number of queries to skip from start.
SQL

Customize default options.

CSV

Customize default options.

CSV
Update data when duplicate keys found on import
CSV using LOAD DATA
Update data when duplicate keys found on import
OpenDocument

Customize default options.

OpenDocument Spreadsheet
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

(Max: 20MiB)

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

Partial import:

Other options:

Format:

Format-specific options:

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

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

mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.