方式一:
UPDATE TA
SET quota_usage1 = 0,
quota_usage2 = 0,
quota_usage3 = 0,
quota_usage4 = 0
where id in (select id from TB);方式二:
UPDATE TA a
SET quota_usage1 = 0,
quota_usage2 = 0,
quota_usage3 = 0,
quota_usage4 = 0
WHERE EXISTS (SELECT id
FROM TB b
WHERE b.id = a.id);其中TA表会有数十万数据或更多,TB表最多达到万级数据.
UPDATE TA
SET quota_usage1 = 0,
quota_usage2 = 0,
quota_usage3 = 0,
quota_usage4 = 0
where id in (select id from TB);方式二:
UPDATE TA a
SET quota_usage1 = 0,
quota_usage2 = 0,
quota_usage3 = 0,
quota_usage4 = 0
WHERE EXISTS (SELECT id
FROM TB b
WHERE b.id = a.id);其中TA表会有数十万数据或更多,TB表最多达到万级数据.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货