//三表联改
UPDATE table t1
JOIN app_info t2 ON t1.app_info_id = t2.id
JOIN app_table_dev t3 ON t2.`name` = t3.`name`
SET t1.xxxid = t3.id
三表联改语句
最新推荐文章于 2024-09-29 21:50:07 发布
//三表联改
UPDATE table t1
JOIN app_info t2 ON t1.app_info_id = t2.id
JOIN app_table_dev t3 ON t2.`name` = t3.`name`
SET t1.xxxid = t3.id