List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:June 14 2010 9:12pm
Subject:RE: list rows with no recent updates
View as plain text  
The only way I could think of is to have a column that's an auto updated
timestamp and then just query using that time.

`updated_on` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP

So for your mass update, I'd SET @updated_time = NOW(); and then you could
use that in your future query where @updated_time +/- some fuzzy amount of
seconds.

> -----Original Message-----
> From: MadTh [mailto:madan.feedback@stripped] 
> Sent: Monday, June 14, 2010 2:02 PM
> To: mysql@stripped
> Subject: list rows with no recent updates
> 
> Hi,
> 
> 
> I ran a update command on around 2700 rows inside a mysql 
> database table
> which has around 3000 table rows to change the ( say)  price 
> of each item (
> with unique ID. unique product code).
> 
> 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 with no updates in last 2 hours?
> 
> 
> 
> 
> 
> Thank you.
> 

Thread
list rows with no recent updatesMadTh14 Jun
  • RE: list rows with no recent updatesDaevid Vincent14 Jun
  • Re: list rows with no recent updatesJim Lyons14 Jun
  • Re: list rows with no recent updatesMadTh14 Jun
    • RE: list rows with no recent updatesDaevid Vincent15 Jun
  • Re: list rows with no recent updatesAdam Alkins16 Jun