Add UPDATE into exsisting INSERT script

Didn’t realise this was available :smile:

Just looking at some information online…

One question, will ON DUPLICATE KEY UPDATE update the rows even if no data has changed?

I mean I will have a big collection of older rows over time and don’t want to update every row in the db_table if no data has changed.

Thanks, Barry