MySQL Forums
Forum List  »  Newbie

"update" table
Posted by: Jared Hislop
Date: September 02, 2011 01:22PM

I have a csv file that is updated daily through an automated process and adds the new data to the end of the document. I need to find a way to "update" the MySQL table without having to truncate the table then LOAD DATA LOCAL INFILE every time. Is there an "update" command that can pull the newly added data from the spreadsheet and "insert" it into the existing table?
Any help would be great
Thanks
Jared

Options: ReplyQuote


Subject
Written By
Posted
"update" table
September 02, 2011 01:22PM
September 02, 2011 03:38PM


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.