|
| |
|
|
julies
Posts: 1
Joined: 5/2/2002
From: Leeds Yorkshire United Kingdom
Status: offline
 |
Updating timestamp on database records - 5/2/2002 12:09:32
I am using UPDATE for various records which works but am having trouble with UPDATING the Timstamp column of my database. Can you help?
UPDATE tablename
SET timestamp=now()
WHERE id='::id::';
|
|
|
|
daveh42
Posts: 83
From: Maine USA
Status: offline
|
RE: Updating timestamp on database records - 5/2/2002 12:26:18
"Timestamp" may be a reserved word. The field that holds the timestamp in the database should be named something else.
Hope this helps,
Dave
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
