Im using the below query to update a Date field in the "INVOICE" Table with the Date field in the "INVOICELIVE" Table
when I run it its telling me its been executed but yet no records are been updated, then If i run it again sometimes I get a timeout error 1205
Im trying to update almost 100,000 records would this maybe be causing the problem?
SELECT * FROM `test`.`invoice`
ON invoice.INVOICE_Number = invoiceLIVE.INVOICE_Number
AND invoice.COMPANY_Number = invoiceLIVE.COMPANY_Number
SET invoiceLIVE.INVOICE_DateAdded = invoice.INVOICE_DateAdded