mysql update多表_Mysql 的update支持多表更新吗?

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)

2008年6月18日 17:58

1787

0

0

0