MySQL Forums
Forum List  »  Newbie

Loading a Data File
Posted by: Lewis Champion
Date: July 25, 2023 03:19AM

Hi all,

I was just hoping someone could help me with uploading a .csv file to a table. The table already has 26 entries, and I want to bulk add an additional 170 or so. This is the code I have used, but isn't working:

LOAD DATA LOCAL INFILE ‘Macintosh HD/Users/lewis/Desktop/load file’
INTO TABLE table_name
FIELDS TERMINATED BY ‘,’;

Can anyone provide any advice or a solution?

Thanks in advance for any responses!

Options: ReplyQuote


Subject
Written By
Posted
Loading a Data File
July 25, 2023 03:19AM


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.