要求在 满足tbl1中的related字段>99时更新tbl0的reprint字段累加1
用以下语句实现了该功能,
UPDATE tbl0 SET reprint = reprint + 1 WHERE id IN (SELECT id FROM tbl1 WHERE related > 99); 但还有没有别的方法呢?
用以下语句实现了该功能,
UPDATE tbl0 SET reprint = reprint + 1 WHERE id IN (SELECT id FROM tbl1 WHERE related > 99); 但还有没有别的方法呢?
set reprint = reprint + 1
where tbl0.id = tbl1.id
and tbl1.related>99
on a.id=b.id
SET a.reprint = a.reprint + 1 WHERE b.related > 99;
set tbl0.reprint = tbl0.reprint + 1