Importing csv through phpmyadmin, how to autoincrement?

Databases
1

I am attempting to dump a lot of data from various .csv files. I set up each of the columns for my table, one of which is a unique id that is auto incremented for each record added.

When I attempt to import the data from the .csv, I get an error that my number of columns don’t match up.

How can I import data into this table and still use the auto increment feature in mySQL?

2

what you have to do is specify all columns by name except the auto_increment one

:slight_smile:

3

:blush:

Thank you!