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
Timestamp columns - How to NOT update!
Moderator: General Moderators
-
d3ad1ysp0rk
- Forum Donator
- Posts: 1661
- Joined: Mon Oct 20, 2003 8:31 pm
- Location: Maine, USA