UPDATE pi_info a
INNER JOIN USER b ON a.`pi_user_id` = b.`UserID`
SET a.`pi_user_name` = b.`LoginName`
【MYSQL】多表连接更新
最新推荐文章于 2023-12-01 18:16:13 发布
UPDATE pi_info a
INNER JOIN USER b ON a.`pi_user_id` = b.`UserID`
SET a.`pi_user_name` = b.`LoginName`