Import excel to mysql via phpMyAdmin

07/04/2012

Some considerations to make: 

- If you have an id column as primary key you should set the first row of that column to 'NULL' i.e. just to reserve the space for the index on mysql.

- Columns should match in number and in field type.

- Csv file does not need column headers.

- If the structure between your csv file and mysql  structure doesn't match,  you must respect the structure of mysql table, for that you must include columns (if needed) and type some value (depending of field type).