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:

Export defaults

SQL

Struktura
Komentari
Izrada/Ažuriranje/Provjera datuma
Relationships
Media type
Izvoz uključi u transakciju
Onemogući provjere stranih znakova
Export views as tables
Export related metadata from phpMyAdmin configuration storage
Način rada SQL kompatibilnosti
Dump table
Dodaj DROP DATABASE
Dodaj CREATE DATABASE / USE
Dodaj DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER
Dodaj CREATE TABLE
Add IF NOT EXISTS (less efficient as indexes will be generated during table creation)
Dodaj vrijednost AUTO_INCREMENT
Dodaj CREATE VIEW
Export/sql_view_current_user
OR REPLACE view
Dodaj CREATE PROCEDURE / FUNCTION / EVENT
Dodaj CREATE TRIGGER
Enclose table and column names with backquotes
Podaci
Upotrijebi odgođena umetanja
Upotrijebi ignoriranje umetaka
Export type
Syntax to use when inserting data
Najveća duljina izrađenog upita
Use hexadecimal for BINARY & BLOB
Export time in UTC

CodeGen

Oblikovanje

CSV

CSV
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
Uključi naslov tablice
Dump table
Naslov tablice
Nastavljeni naslov tablice
Ključ oznake
Relationships
Komentari
Media type
Podaci
Put columns names in the first row
Naslov tablice
Nastavljeni naslov tablice
Ključ oznake
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! tekst

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.