正确的写法:
--最先让人想到的写法
UPDATE buyer SET is_seller=1 WHERE uid IN (SELECT uid FROM seller)
-- 网上的一种
UPDATE buyer a,seller b SET a.is_seller=1 WHERE a.uid=b.uid
UPDATE tb1 t1 ,tb2 t2 set t1,fn1=t2.fn2 where t1.id=t2.id
重新整理:http://blog.csdn.net/default7/article/details/77477627