Really I don't understand this error in update query MySQL:
LEFT JOIN _yourTable C ON C.myNumber = R.yourNumber
SET R.yourOff = 1
WHERE (C.myLastDate <> '' OR C.myLastDate IS NOT NULL)
Incorrect date value: '' for column 'myLastDate' at row 1
I don't have null value of field 'myLastDate' in the _myTable.
I hope your help.