MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: LOAD DATA LOCAL INFILE - Help
Posted by: Peter Brawley
Date: April 19, 2016 08:07AM

> I have a blank column in my excel file for that id field,

Lose it. Then, supposing your MySQL table has columns id,a,b,c,d,e, write the Load command as Load Data Infile ... (a,b,c,d,e) ...

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
LOAD DATA LOCAL INFILE - Help
Tim Whitaker
April 18, 2016 07:37PM
Re: LOAD DATA LOCAL INFILE - Help
Peter Brawley
April 19, 2016 08:07AM


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.