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.
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
-
Bef
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]
--
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)
