I have a table with 12 columns. The first column is auto_increment id and the second is person_name. Using phpmyadmin I am finding it impossible to import data from a csv file. Whether I leave a gap in the first column, put a number, or have no column at all, the data imports but the data that should go in the person_name field is missing, as though it has gone in the auto_increment id field (it hasn't!) but then every value is in the wrong column.
How do you import csv with phpmyadmin when the first column is auto_increment. Is it even possible?
Many thanks