I want to import an Excel CSV file into my database with phpMyAdmin.
It turns out, that my table has to store 4 different fields.
id , codigo , nombres , apellidos where:
id: Is the ID of the table as a primary and auto-incremental key.
code: It is a code in varchar.
names: ...
Last name: ...
The issue is that, when I want to import it, I need the "id" field. I can not put it in the excel column, because the database should generate the acutoincremental id. The CSV file is separating the columns by semicolons ; . I would like to know if I can save my Excel CSV file, but with a blank column. That is, have the following format:
;001;juan;perez
where:
the first ; corresponds to the first column.
Thank you very much for the help!