The entry number is gradually increasing each time the query fails as per "Error in query: Duplicate entry '25065' for key 1" then "Error in query: Duplicate entry '25337' for key 1", then "Error in query: Duplicate entry '25759' for key 1" ... , but other than that, the error...
immediately has an error like this, seemingly for random tables that have been written to (not one in particular): Could not execute Write_rows event on table XXX; Duplicate entry 'YYY' for key 'ZZZ', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's ...
I've read about using INSERT...SELECT, INSERT...ON DUPLICATE KEYS and quite frankly am a little confused. My end goal is to update these records to pick up the new 'image_name' and update mode and then these are not already present, insert the values. Is it possible to modify my ...