Results 1 to 2 of 2

Thread: MySql Replace

  1. #1
    Join Date
    Mar 2010

    Unanswered: MySql Replace


    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.



  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    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 | @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