10.1.1.218 / 127.0.0.1 | phpMyAdmin 5.0.2

Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift + Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Your preferences will be saved for current session only. Storing them permanently requires phpMyAdmin configuration storage.

Import defaults
SQL
CSV
OpenDocument

Import defaults

Customize default common import options.

Format of imported fileDefault format; be aware that this list depends on location (database, table) and only SQL is always available.
Character set of the file
Partial import: allow interruptAllow 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.
Partial import: skip queriesNumber of queries to skip from start.
Enable drag and drop import Uncheck the checkbox to disable drag and drop import

SQL

Customize default options.

SQL compatibility mode
Do not use AUTO_INCREMENT for zero values
Read as multibytes

CSV

Customize default options.

CSV
Add ON DUPLICATE KEY UPDATEUpdate data when duplicate keys found on import
Do not abort on INSERT error
Columns terminated with
Columns enclosed with
Columns escaped with
Lines terminated with
CSV using LOAD DATA
Add ON DUPLICATE KEY UPDATEUpdate data when duplicate keys found on import
Do not abort on INSERT error
Columns terminated with
Columns enclosed with
Columns escaped with
Use LOCAL keyword

OpenDocument

Customize default options.

OpenDocument Spreadsheet
Column names in first row
Do not import empty rows
Import percentages as proper decimals (12.00% to .12)
Import currencies ($5.00 to 5.00)