需求:
需要在MS.tbMSImageMapNew 表中将tagMask=1的值中随机选择1200个,将其值置为2,
SQL语句:
UPDATE MS.tbMSImageMapNew
SET TagMask = 2
WHERE ID IN (
SELECT ID
FROM MS.tbMSImageMapNew
WHERE tagMask = 1
ORDER BY RANDOM()
LIMIT 1200
);
需求:
需要在MS.tbMSImageMapNew 表中将tagMask=1的值中随机选择1200个,将其值置为2,
SQL语句:
UPDATE MS.tbMSImageMapNew
SET TagMask = 2
WHERE ID IN (
SELECT ID
FROM MS.tbMSImageMapNew
WHERE tagMask = 1
ORDER BY RANDOM()
LIMIT 1200
);