用php和mysql数据库，数据库有多个表，怎么实现当用php更新一个表时，另外几个表能够自动更新数据。

发布网友 发布时间：2022-04-08 22:06

我来回答

共4个回答

懂视网 时间：2022-04-09 02:27

1: 通过where关联更新

 update student s, city c set s.province_name = c.province_name, s.city_name = c.name where s.city_code = c.code; 

2：子查询更新

update student s set city_name = (select name from city where code = s.city_code); 

子查询更新优化：

UPDATE t_advs_order SET 
attribute1=(SELECT o.order_state FROM tk_zyt_scenery_order o WHERE o.order_id=`on`), 
attribute2=(SELECT o.order_state FROM tk_zyt_scenery_order o WHERE o.order_id=`on`) 
WHERE EXISTS (SELECT o.order_state FROM tk_zyt_scenery_order o WHERE o.order_id=`on`); 

转为：

UPDATE t_advs_order a 
INNER JOIN tk_zyt_scenery_order s ON s.order_id=a.`on` 
SET 
a.attribute1=s.order_id, 
a.attribute2=s.order_id; 

php分享（三十六）mysql中关联表更新

标签：

热心网友 时间：2022-04-08 23:35

热心网友 时间：2022-04-09 00:53

热心网友 时间：2022-04-09 02:28