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.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 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. > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
