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` = '张三'
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` = '张三'