MySQL Forums
Forum List  »  Newbie

Re: Load Data Local Infile not Working
Posted by: Barry Galbraith
Date: October 03, 2022 06:41PM

Your table has 14 columns.
In your CSV file,
Row 1 has 13 column names, but is IGNOREd.
Row 2 has 13 columns of data and fails to load because of column count mis-match.
Row 3 has 14 columns of data, and would load if not for the previous failure.
Row 4 has 12 columns of data, and would fail to load.
Row 5 has 11 columns of data, and would fail to load.
And so on.

Data column count MUST be the same for all rows.
The column count of your file should match your table, but if fewer rows in the file, you can specify data for the "missing" columns in your load statement.

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
Re: Load Data Local Infile not Working
October 03, 2022 06:41PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.