1

I've got a CSV file with 20 columns and I have a MySQL table with 18 columns.

The CSV file looks like:

firstColumnEmptyNoName, secondColumnEmptyNoName, column1, column2, ... column18

If delete the firstColumnEmptyNoName and secondColumnEmptyNoName in CSV file the LOAD DATA is worked, Affected rows: 16726.

With the firstColumnEmptyNoName and secondColumnEmptyNoName in CSV file the LOAD DATA is not worked, Affected rows: 0

How to skip columns firstColumnEmptyNoName and secondColumnEmptyNoName in CSV file when importing into MySQL table using LOAD DATA INFILE?

Improve this question
3
Related questions
68
How to skip columns in CSV file when importing into MySQL table using LOAD DATA INFILE?
199
MySQL load NULL values from CSV data
2
Blank row in table after LOAD DATA INFILE
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.