MySQL Forums
Forum List  »  Newbie

Importing Updated Data
Posted by: Nicholas Rennie
Date: April 04, 2005 04:41AM

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

Options: ReplyQuote


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.