MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: loading data containing commas
Posted by: Peter Brawley
Date: June 13, 2015 03:41PM

Have the spreadsheet double-quote the data, and invoke Load Data Infile with ENCLOSED BY '"' FIELDS TERMINATED BY ","

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


Subject
Written By
Posted
loading data containing commas
Frank Seabright
June 13, 2015 02:46PM
Re: loading data containing commas
Peter Brawley
June 13, 2015 03:41PM
Re: loading data containing commas
Frank Seabright
June 14, 2015 11:18AM


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.