We are noticing that the update statement which was run by the a php code is not happening. The records still reflect default value.
However we do find the update statement logged in bin-log files whihc implies that the update statement was executed successfully in database.
The database engine is INNODB.
What are the scenarios where the entire column value or specific column for few rows gets reset to default value. if any thing triggers this ,where can we trace the cause of the same.
mysql error logs dont show any crash activities.
please help in resolving this mystery!!!