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