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,

Options: ReplyQuote

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

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.