gt;
> 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 up
it. Plus it's stored internally as an integer (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 ro
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
27; 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 wit
se 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,
&g
_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 with no updates in last 2 hours?
Thank you.
