Timestamp columns - How to NOT update!
Posted: Fri Feb 11, 2005 10:07 am
Hi All,
I have a timestamp column in my database which is initially populated when adding a record through the web page.
However, once this is populated I do not want it to change unless I specifically specify that it should. Yesterday I was doing some work through phpMyAdmin and I happened to do some updates on this table and found today that it had updated the timestamp column.
How can I avoid this, change it.
The web page basically records work carried out on a server, so creating an audit log. Obvioulsy the data and time are essential to this. There will be no updates on the table in the long-term, but until we have settled it in I don't want the timestamp changing.
Any Ideas?
Thanks
I have a timestamp column in my database which is initially populated when adding a record through the web page.
However, once this is populated I do not want it to change unless I specifically specify that it should. Yesterday I was doing some work through phpMyAdmin and I happened to do some updates on this table and found today that it had updated the timestamp column.
How can I avoid this, change it.
The web page basically records work carried out on a server, so creating an audit log. Obvioulsy the data and time are essential to this. There will be no updates on the table in the long-term, but until we have settled it in I don't want the timestamp changing.
Any Ideas?
Thanks