phpMyAdmin setup

Overview
Features
SQL queries
Navigation frame
Main frame
Import
Export

Customize import defaults

Format of imported file
Character set of the file
Partial import: allow interrupt
Partial import: skip queries

SQL compatibility mode
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

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)