Importing Updated Data
Hi all,
Hope you can help me out here. I've set up a MySQL database and everything is working fine however I've received some updated data (CSV) and need to import it into my database.
The problem is I've added extra fields into the table and whenever I update the data, it goes through ok, but deletes the data from existing that aren't included in the new updated CSV file i'm importing.
Just so I make sense, an example.....
1. Old Data
Name Address Postcode
Nick 1 Street 123456
2. New Data
Name Postcode
Nick 098733
3. Updated Table
Name Address Postcode
Nick 098733
Now after importing the new data you loose the address information so you get a blank field although the postcode updates correctly. Does this make sense?
Now my question is how do I update my data without overwriting the old data????
Any answers would be greatly appreciated!
Thanks!
Nick
Subject
Written By
Posted
Importing Updated Data
April 04, 2005 04:41AM
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.