demo.phpmyadmin.net / phpMyAdmin demo - MariaDB

Drop files here

SQL upload ( 0 ) x -

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken:

No bookmarks

Label: Target database: Share this bookmark

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 Uređivanje Explain Izrada profila Bookmark Query failed Baza podataka: Queried time:

Import defaults

Oblikovanje uvezene datoteke Default 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 interrupt 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.
Partial import: skip queries Number of queries to skip from start.
Enable drag and drop import Uncheck the checkbox to disable drag and drop import

SQL

Način rada SQL kompatibilnosti
Do not use AUTO_INCREMENT for zero values
Read as multibytes

CSV

CSV
Add ON DUPLICATE KEY UPDATE Update 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 upotrebom LOAD DATA
Add ON DUPLICATE KEY UPDATE Update data when duplicate keys found on import
Do not abort on INSERT error
Columns terminated with
Columns enclosed with
Columns escaped with
Upotrijebi lokalnu ključnu riječ

OpenDocument

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)

phpMyAdmin Demo Server: Currently running Git revision RELEASE_5_2_1-4907-g5b04607256 from the master branch.