MySQL Forums
Forum List  »  Other Migration

From Excel to Mysql Multivalue fields
Posted by: Jose Dobles
Date: March 04, 2011 09:35AM

Hello. I'm trying to export a table from Excel to Mysql. I've been using this command to do the migration with the mysql commmand line (I MUST use this method):

LOAD DATA LOCAL INFILE ‘C:\\temp\\yourfile.csv’ INTO TABLE database.table FIELDS TERMINATED BY ‘;’ ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\r\n’ (field1, field2);

But I have no idea how to import a multivalue field. This field has numbers with a comma between them (1,5,6), and I need each number to be a value by itself. How can I modify the command above to recognize each number as a valid entry for the multivalue field in the mysql table? Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
From Excel to Mysql Multivalue fields
5398
March 04, 2011 09:35AM


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.