Copying from one table to another

[Guest_imported]

Hello, Pardon my lack of knowledge on MySQL. I'm quite the newbie.

I have two tables set up that I'm dealing with right now. one is the main information table, and one is a table that I set up from a filemaker export. The tables have some similar information, most notably the zip code which I want to use as a key.

Basically I want to find a record in the export table, and then take the info from one row and insert it into the row in the other table that correspond to the same zip code.

Is this possible?

 

[Tim1]

Hiya,

It certainly is possible, I think (from my limited knowledge of MySQL) that the command you need is replace.

I am afraid that I am not familiar enough with MySQL to give you the exact syntax, but perhaps if you search FAQ's for REPLACE, you may strike lucky.

Tim