UPDATE author B SET
B.acountbooks=
(
SELECT COUNT(aid) FROM work_book A WHERE B.aid = A.aid
);
SQL中记录的循环
最新推荐文章于 2022-10-22 11:05:47 发布
UPDATE author B SET
B.acountbooks=
(
SELECT COUNT(aid) FROM work_book A WHERE B.aid = A.aid
);