MySQL多表更新应该如何是实现呢？对于很多刚接触MySQL数据库的新人来说，都会有这样的疑问，下面就为您介绍MySQL多表更新的方法，供您参考。
MySQL多表更新：
update contact c, contactdroit cd set c.user_name = '$username', c.nom = '$lastname', c.prenom = '$firstname', c.passcode = '$password', cd.droit_id = '$droitid' where c.contact_id = '$id' and c.contact_id = cd.contact_id;
示例：
mysql> create table one(id int(10), name varchar(20)); Query OK, 0 rows affected (0.03 sec) mysql> create table two(id int(10), name varchar(20)); Query OK, 0 rows affected (0.05 sec) mysql> insert one value(1, '1'); Query OK, 1 row affected (0.00 sec) mysql> insert two value(22, '22'); Query OK, 1 row affected (1.02 sec) mysql> update one o, two t set o.name='oo', t.name='tt'; Query OK, 2 rows affected (0.00 sec) Rows matched: 2 Changed: 2 Warnings: 0 mysql> select * from one; +------+------+ | id | name | +------+------+ | 1 | oo | +------+------+ 1 row in set (0.00 sec) mysql> select * from two; +------+------+ | id | name | +------+------+ | 22 | tt | +------+------+ 1 row in set (0.00 sec)