Results 1 to 2 of 2

Thread: MySql Replace

  1. #1
    Join Date
    Mar 2010
    Posts
    1

    Unanswered: MySql Replace

    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.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by kippi View Post
    Is this somthing that MySql can do?
    sure, but not by itself

    you need application logic

    whether you put that logic into a trigger is up to you
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •