php - mysql怎么同时更新2个表-PHP中文网问答

文章专题 AI工具学习下载问答源码最近更新

PHP

会员中心讲师中心微信公众号

php - mysql怎么同时更新2个表

伊谢尔伦 2017-04-10 14:31:17

[PHP讨论组]

757

想同时更新2个表，2表uid相同，修改a表name和b表nice，怎么破

伊谢尔伦

小伙看你根骨奇佳，潜力无限，来学PHP伐。

全部回复(2)

阿神2017-04-10 14:33:17 2楼

mysql> select * from aa;
+------+
| id   |
+------+
|    2 |
+------+
1 row in set (0.00 sec)

mysql> select * from bb;
+------+
| id   |
+------+
|    2 |
+------+
1 row in set (0.00 sec)

mysql> update aa,bb set aa.id=3, bb.id=3 where aa.id=bb.id;
Query OK, 2 rows affected (0.02 sec)
Rows matched: 2  Changed: 2  Warnings: 0

mysql> select * from bb;
+------+
| id   |
+------+
|    3 |
+------+
1 row in set (0.00 sec)

mysql> select * from aa;
+------+
| id   |
+------+
|    3 |
+------+
1 row in set (0.00 sec)