demo.phpmyadmin.net / phpMyAdmin demo - MySQL

Drop files here

SQL upload ( 0 ) x -

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 Promeni Explain Profiling Query failed Baza podataka: Queried time:

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

Export defaults

SQL

Struktura
Komentari
Creation/Update/Check dates
Relationships
Media type
Enclose export in a transaction
Disable foreign key checks
Export views as tables
Export related metadata from phpMyAdmin configuration storage
SQL compatibility mode
Dump table
Add DROP DATABASE
Add CREATE DATABASE / USE
Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER
Add CREATE TABLE
Add IF NOT EXISTS (less efficient as indexes will be generated during table creation)
Dodaj AUTO_INCREMENT vrijednost
Add CREATE VIEW
Export/sql_view_current_user
OR REPLACE view
Add CREATE PROCEDURE / FUNCTION / EVENT
Add CREATE TRIGGER
Enclose table and column names with backquotes
Podaci
Use delayed inserts
Use ignore inserts
Export type
Syntax to use when inserting data
Maximal length of created query
Use hexadecimal for BINARY & BLOB
Export time in UTC

CodeGen

Format

CSV format

CSV format
Columns terminated with
Columns enclosed with
Columns escaped with
Lines terminated with
Replace NULL with
Remove CRLF characters within columns
Put columns names in the first row
CSV za MS Excel
Replace NULL with
Remove CRLF characters within columns
Put columns names in the first row
Excel edition

LaTeX

Struktura
Include table caption
Dump table
Table caption
Continued table caption
Label key
Relationships
Komentari
Media type
Podaci
Put columns names in the first row
Table caption
Continued table caption
Label key
Replace NULL with

Microsoft Office

Microsoft Word 2000
Dump table
Replace NULL with
Put columns names in the first row

OpenDocument

OpenDocument Spreadsheet
Put columns names in the first row
Replace NULL with
OpenDocument Text
Dump table
Struktura
Relationships
Komentari
Media type
Podaci
Put columns names in the first row
Replace NULL with

Texy! text

Podaci
Dump table
Replace NULL with
Put columns names in the first row

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