MySQL Forums
Forum List  »  Newbie

loading data containing commas
Posted by: Frank Seabright
Date: June 13, 2015 02:46PM

I need to load address data from a single columnn spreadsheet to a table in mysql database. Using .csv file it is confused by ',' within address field. I have tried using extra fields within the database but that does not work as the number of commas and full stops vary from record to record. Any ideas please

Options: ReplyQuote


Subject
Written By
Posted
loading data containing commas
June 13, 2015 02:46PM


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.