470,613 Members | 2,448 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,613 developers. It's quick & easy.

timstamp

Ike
I havea timestamp field in a table which shows the timestamp of the last
update or insert to a given row. Is there a way to temporarily turn that
off, such that I can update a row withOUT affecting timestamp? Thanks, Ike
Jun 4 '06 #1
1 1513
Not that I know of, but here are a couple work arounds:

Just update the timestamp manually and set it to the current timestamp.

Aside from that you can use 'set timestamp' to set the time used for
the timestamp (this is how it's done when you are using replication).

We also offer a wide range of MySQL and PostgreSQL training -
http://www.otg-nc.com

--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
Phone: 877-258-8987/919-463-0999
Ike wrote:
I havea timestamp field in a table which shows the timestamp of the last
update or insert to a given row. Is there a way to temporarily turn that
off, such that I can update a row withOUT affecting timestamp? Thanks, Ike


Jun 5 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Lars Plessmann | last post: by
3 posts views Thread by Ina Schmitz | last post: by
4 posts views Thread by P. George | last post: by
1 post views Thread by Nadav | last post: by
3 posts views Thread by Michael Voss | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.