I'm trying to use a scheduled task (once daily) to duplicate a table on a remote server. Basically I want to use a INSERT, ON DUPLICATE KEY UPDATE query to keep the remote table identical to the local. I found this thread which was somewhat helpful but it is the reverse and doesn't update on duplicate key. "Copy rows from a remote db table?".
There is a field called 'modified' which is an autodate field. It would be good to check if the 'modified' dates differ before the update occurs to be more efficient.
Any help in the right direction is appreciated!
There is a field called 'modified' which is an autodate field. It would be good to check if the 'modified' dates differ before the update occurs to be more efficient.
Any help in the right direction is appreciated!