148.216.95.41 / mysql wampserver

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

Export defaults

Customize default export options

SQL

Customize default options

Database export options
Comments
Creation/Update/Check dates
Relations
MIME type
Enclose export in a transaction
Disable foreign key checks
Export views as tables
SQL compatibility mode
Add DROP DATABASE
Dump table
Structure
Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT
Add CREATE PROCEDURE / FUNCTION / EVENT
`CREATE TABLE` options:
Add IF NOT EXISTS
Add AUTO_INCREMENT value
Enclose table and column names with backquotes
Data
Use delayed inserts
Use ignore inserts
Export type
Syntax to use when inserting data
Maximal length of created query
Use hexadecimal for BLOB
Export time in UTC

CodeGen

Customize default options

Format

CSV

Customize default options

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 for MS Excel
Replace NULL with
Remove CRLF characters within columns
Put columns names in the first row
Excel edition

LaTeX

Customize default options

Structure
Include table caption
Dump table
Table caption
Continued table caption
Label key
Relations
Comments
MIME type
Data
Put columns names in the first row
Table caption
Continued table caption
Label key
Replace NULL with

Microsoft Office

Customize default options

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

OpenDocument

Customize default options

OpenDocument Spreadsheet
Put columns names in the first row
Replace NULL with
OpenDocument Text
Dump table
Structure
Relations
Comments
MIME type
Data
Put columns names in the first row
Replace NULL with

Texy! text

Customize default options

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