If I have a table defined with 4 fields, the first being the primary key, auto-increment and I have a .csv file the has 3 of the 4 fields listed in the table, what is the syntax for importing this data into the table? Below is the code I'm trying to use, but gives an error. The format of the table is id, lastname, firstname, phone, but the .csv doesn't have the first column. What is the correct syntax for the INTO TABLE line below? DO I need something like, employees(,lastname,firstname,phone)?
Please Login or Register  to view this content.