Hello, I have a query that select records from a table, and updates them. It works based on a date, however whenever it updates the record, it resets the date field (timestamp(8)) to todays date. Does anyone know why? Cheers Brian
This self-updating is a feature of MySQL's timestamp datatype.
Change it to datetime or date to stop it from self-updating.
