title: Trigger to Insert data in a table before updating a column MYSQL
body: <p>I want to create a trigger that inserts a timestamp to table <code>log</code> before I update column within a table. For example if I update table <code>hits</code> column <code>number</code> from 1 to 2. I want the time recorded before the column was updated, but this record of the time the update was done must only be when <code>hits.number</code> is updated. How can this be done?</p>