Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Daevid Vincent (daeviddaevid.com)
Date: Mon Jun 14 2010 - 16:12:53 CDT
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
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
> -----Original Message-----
> From: MadTh [mailto:madan.feedbackgmail.com]
> Sent: Monday, June 14, 2010 2:02 PM
> To: mysqllists.mysql.com
> Subject: list rows with no recent updates
> 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).
> mysql> UPDATE tbl_xyz set listprice='9.45' where prod_id='3069' and
> 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