Server
localhost
Databases
Processes
Export
View dump (schema) of databases
Export
demohih_demotesting
Select All
/
Unselect All
SQL
LaTeX
CSV for Ms Excel data
CSV data
SQL options (
Documentation
)
Database export options
Add DROP DATABASE
Structure
Add 'drop table'
Add AUTO_INCREMENT value
Enclose table and field names with backquotes
Add into comments
Creation/Update/Check dates
Data
Complete inserts
Extended inserts
Use delayed inserts
Export type:
INSERT
UPDATE
REPLACE
LaTeX options
Include table caption
Structure
Table caption
Continued table caption
Label key
Data
Column names
Table caption
Continued table caption
Label key
Replace NULL by
CSV options
Fields terminated by
Fields enclosed by
Fields escaped by
Lines terminated by
Replace NULL by
Put fields names at first row
Excel options
Replace NULL by
Put fields names at first row
Excel edition:
Windows
Macintosh
This format has no options
Save as file
File name template :
(
remember template
)*
Compression
None
"zipped"
"gzipped"
*
Use __DB__ for database name, __TABLE__ for table name and
any strftime
options for time specification, extension will be automagically added. Any other text will be preserved.