This is a discussion on Timestamp of data entry within the MySQL Database forums, part of the Database Forums category; How do I retrieve the timestamp of the data entry? Thanks. James...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
JH wrote:
> How do I retrieve the timestamp of the data entry? > > Thanks. > James > Use a timestamp column and set it every time the row is changed. -- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstucklex@attglobal.net ================== |
|
|||
|
Jerry Stuckle schrieb:
> JH wrote: >> How do I retrieve the timestamp of the data entry? > > Use a timestamp column and set it every time the row is changed. Actually, by default, mysql sets the first TIMESTAMP column to NOW() on every insert or update. (Don't rely on such behaviour when porting to a different database though.) Regards, Jo |