From Excel to Mysql Multivalue fields
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!
Subject
Views
Written By
Posted
From Excel to Mysql Multivalue fields
5398
March 04, 2011 09:35AM
2067
March 09, 2011 03:49AM
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.