Hey

I am exporting some data from a web page, the data is changing and what I would like to do is check if the new data I am adding has changed and if it has copy the old row to another table and add the new data.

Is this somthing that MySql can do? I was thinking of using replace and using a tigger. Any help would be great.

Thanks

Chris.

sure, but not by itself

you need application logic

whether you put that logic into a trigger is up to you

Hi,

As r937 updated, you can accomplish your requirement but for that you have to apply the logic with select, match, update and insert queries.