An SQL update statement

You need to select the latest merchant update timestamp at intervals:

Update DP_Shop set DP_Shop.LastDate = now () where DP_Shop.ShopId in (select ShopId from DP_Shop order by LastDate limit 5 );

ERROR 1235 (42000): This version of MySQL doesn't yet support 'limit & IN/ALL/ANY/SOME subquery'

Additional layer:

Update DP_Shop set DP_Shop.LastDate = now () where DP_Shop.ShopId in (select t. ShopId from (select ShopId from DP_Shop order by LastDate limit 5) as t );

Can work, but not efficient, consider how to optimize.

The temporary table is used:

Start transaction;

Create temporary table tmp1986 (select ShopId from DP_Shop order by LastDate limit 1000 );

Update DP_Shop inner join tmp1986 on DP_Shop.ShopId = tmp1986.ShopId set LastDate = now ();

Drop table tmp1986;

Commit;