How to get IDs of the last updated rows in MySQL?

Asked Jul 01 '15 at 08:43

Active Jul 01 '15 at 09:22

Viewed 115 times

I need to get the IDs of last update.

I have tried this.How to get ID of the last updated row in MySQL?

My code is

SET @uids := NULL;
UPDATE core_parcel 
    SET core_parcel.promotion_sms = '0'
WHERE core_parcel.senderid = '23'  AND core_parcel.promotion_sms = '1'
    AND ( SELECT @uids := CONCAT_WS(', ', @uids, core_parcel.REFID) )
LIMIT 10;
SELECT @uids;

But gives all id not just 10 ids. And it does not update at all.

AND ( SELECT @uids := CONCAT_WS(', ', @uids, core_parcel.REFID) )

Leaving out it updates.

edited May 23 '17 at 11:51

Community

asked Jul 01 '15 at 08:43

Mazhar

Do you have an `updated_at` row in your table? – JordyvD Jul 01 '15 at 09:18
no updates are happened. – Mazhar Jul 01 '15 at 09:23
Then what are you gonna select? – JordyvD Jul 01 '15 at 09:29
I don't have any updated_at column. So, time stamp or something like this will not work. I want to select ids of updated column using query. – Mazhar Jul 01 '15 at 10:37
Well, you can't determine the last updated columns if there's nothing keeping track of it – JordyvD Jul 01 '15 at 10:52

How to get IDs of the last updated rows in MySQL?

0 Answers0