UPDATE user_base_info ui
SET avatar = (
SELECT
imgurl
FROM
album a
WHERE
a.userId = ui.userId
AND a.iscoverImg = 1
)
mysql update set where用法
最新推荐文章于 2024-07-29 03:49:57 发布
UPDATE user_base_info ui
SET avatar = (
SELECT
imgurl
FROM
album a
WHERE
a.userId = ui.userId
AND a.iscoverImg = 1
)