UPDATE customer_info c,
customer_home_demand d,
customer_flow f
SET c.`name` = '法外狂徒张三',
d.house_type = 2,
f.flow_type = 2
WHERE
c.id = d.id
AND d.id = f.id
AND c.`name` = '张三'
mysql可以同时更新多表
最新推荐文章于 2022-11-25 15:55:55 发布
UPDATE customer_info c,
customer_home_demand d,
customer_flow f
SET c.`name` = '法外狂徒张三',
d.house_type = 2,
f.flow_type = 2
WHERE
c.id = d.id
AND d.id = f.id
AND c.`name` = '张三'