Strange one this, I have a database set up with these fields:
EmailConfirmID EmailToConfirm ConfirmCode DateRequested DandTConfirmed
When I run this bit of sql:
UPDATE Emails2Confirm SET DandTConfirmed = NOW() WHERE EmailToConfirm = '[email protected]' AND ConfirmCode = 'whatever';
It changes BOTH DateRequested and DandTConfirmed to the current time. No clue why, all advice appreciated!
The definition of the
DateRequested column presumably has the
ON UPDATE CURRENT_TIMESTAMP, so any time you modify any other column, it will be updated to the current time.
Answered By – Barmar
Answer Checked By – Mary Flores (BugsFixing Volunteer)