).
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
Where/how can I access the most recently updated code for MySQL Max 4.x.
Thanks,
Anthony
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
In the last episode (May 30), Anthony W. Marino said:
Where/how can I access the most recently updated code for MySQL Max
4.x.
http://www.mysql.com/doc/I/n/Installing_source_tree.html
--
Dan Nelson
[EMAIL PROTECTED]
Thanks alot!!!
Anthony
In the last episode (May 30), Anthony W. Marino said:
Where/how can I access the most recently updated code for MySQL Max
4.x.
http://www.mysql.com/doc/I/n/Installing_source_tree.html
-
Before