SQLTeam.com | Weblogs | Forums

Abou sql

I have a question.
I'm taking SQL certification training
When reading a CSV file with MySQL,
is it possible to read a CSV file (item) only in the "name" field while incrementing the "id" field with (int auto_increment) ?
I have 1000 lines of CSV file data. Is there a way to give an ID to it?

CSV files
OS is LINUX, DB is MySQL.
Thank you for your reply.