Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
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

Re: timstamp

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 -

Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC  27560
Phone: 877-258-8987/919-463-0999

Ike wrote:
Quoted text here. Click to load it

Site Timeline