phpMyAdmin setup

• Overview
• Features
• SQL queries
• Navigation frame
• Main frame
• Import
• Export

Customize import defaults

Format of imported file	csvdocsqlldisql
Character set of the file	iso-8859-1iso-8859-2iso-8859-3iso-8859-4iso-8859-5iso-8859-6iso-8859-7iso-8859-8iso-8859-9iso-8859-10iso-8859-11iso-8859-12iso-8859-13iso-8859-14iso-8859-15windows-1250windows-1251windows-1252windows-1256windows-1257koi8-rbig5gb2312utf-16utf-8utf-7x-user-definedeuc-jpks_c_5601-1987tis-620SHIFT_JIS
Partial import: allow interrupt
Partial import: skip queries

SQL compatibility mode	NONEANSIDB2MAXDBMYSQL323MYSQL40MSSQLORACLETRADITIONAL
Do not use AUTO_INCREMENT for zero values

CSV
Replace table data with file
Do not abort on INSERT error
Columns terminated by
Columns enclosed by
Columns escaped by
Lines terminated by
CSV using LOAD DATA
Replace table data with file
Do not abort on INSERT error
Columns terminated by
Columns enclosed by
Columns escaped by
Use LOCAL keyword	autoyesno

Open Document 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)