SQL 同表多条更新条件

 

/*UPDATE  b(school)  select b.school from b where b.id =1*/

-- UPDATE  b SET school =(select a.`name` from a where a.id=1) where b.id = 5
-- UPDATE a,b SET b.school = a.`name`,b.age=a.sex where a.id =1 and b.id =5 不同表数据
UPDATE b b1,b b2 SET b1.school = b2.school where b1.id =1 and b2.id =5 --同表数据，某行插入某行