UPDATE pi_info LEFT JOIN USER ON user.`UserName` = pi_info.`pi_user_name`
SET pi_info.`pi_user_id` = user.`UserID`
mysql关联表更新
最新推荐文章于 2024-07-15 19:44:21 发布
UPDATE pi_info LEFT JOIN USER ON user.`UserName` = pi_info.`pi_user_name`
SET pi_info.`pi_user_id` = user.`UserID`