).
like:
mysql UPDATE tbl_xyz set listprice='9.45' where prod_id='3069' and
prod_code='a0071';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
How can I list rows with no recent updates ( or the once where the above
updates were not done) or say
, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
How can I list rows with no recent updates ( or the once where the above
updates were not done) or say with no updates in last 2 hours?
Thank you.
that in your future query where @updated_time +/- some fuzzy amount of
seconds.
-Original Message-
From: MadTh [mailto:madan.feedb...@gmail.com]
Sent: Monday, June 14, 2010 2:02 PM
To: mysql@lists.mysql.com
Subject: list rows with no recent updates
Hi,
I ran a update command on around
';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
How can I list rows with no recent updates ( or the once where the above
updates were not done) or say with no updates in last 2 hours?
Thank you.
--
Jim Lyons
Web developer / Database administrator
http
Hi,
Thank you all for your prompt response. Unfortunately timestamp file isn;t
there, so I will find some other way to do it.
Seems timestamp is a valuable field ( unless you want to save resource on
generating timestamps on a very busy table).
Thanks
(timestamp)
*http://en.wikipedia.org/wiki/Long_and_short_scales
-Original Message-
From: MadTh [mailto:madan.feedb...@gmail.com]
Sent: Monday, June 14, 2010 2:23 PM
To: mysql@lists.mysql.com
Subject: Re: list rows with no recent updates
Hi,
Thank you all for your prompt response