56,687
社区成员
发帖
与我相关
我的任务
分享
第一种:
UPDATE house_rent a, (SELECT id FROM house_rent where agentId = atId and deleted=FALSE LIMIT 5) b
set a.recommend=TRUE
where a.id=b.id
UPDATE house_rent A Inner Join
(SELECT id FROM house_rent where agentId = atId and deleted=FALSE LIMIT 5)T On A.ID=T.ID
SET A.recommend=TRUE
UPDATE house_rent A Inner Join
(SELECT id FROM house_rent where agentId = atId and deleted=FALSE LIMIT 5)T On A.ID=T.ID
SET A.recommend=TRUE