(mysql)update与此同时更新多个表

(mysql)update同时更新多个表

(1)

同时更新的多个表之间没关系的:

?

use mytest;CREATE TABLE tb(id int ,data varchar(20));insert tb values(1,'aaa');insert tb values(2,'bbb');insert tb values(3,'ccc');use test;CREATE TABLE tb(id int ,data varchar(20));insert tb values(1,'aaa');insert tb values(2,'bbb');insert tb values(3,'ccc');UPDATE mytest.tb,test.tb    SET mytest.tb.data='liangCK',        test.tb.data='liangCK'WHERE mytest.tb.id=test.tb.id    AND mytest.tb.id=2; 

http://blog.163.com/wangkangming2008@126/blog/static/7827792820098941210766/