MySQL Forums
Forum List  »  Newbie

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

On further investigation, I've found more errors.
Your table has no PRIMARY KEY specified.
Some rows are missing data for some fields.
The copy I took of your data had no tabs '\t' when I copy\paste into my text editor.
When I fixed that (which may not be your fault!) the data does load, but with errors for missing fields.
You'll need to fix your column count, and your PRIMARY INDEX.

Good luck,
Barry.

Options: ReplyQuote


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


Sorry, you can't reply to this topic. It has been closed.

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.