mysql 注意点汇总

方式一：

UPDATE A a, B bSET a.name = b.my_nameWHERE a.id = b.id

方式二：

UPDATE   supplierInfo s,  (SELECT     a.*,b.*   FROM    hbkysuptest a     LEFT JOIN purchaserthirdsupplier b       ON a.supplierId = b.thirdsupplierNo) t SET  s.supplierCategory = t.categoryName WHERE s.supplierNo = t.supplierNo AND t.supplierNo !='' AND t.supplierNo IS NOT NULLAND (s.supplierCategory IS NULL OR s.supplierCategory = '')AND t.categoryName IS NOT NULL AND t.categoryName !=''AND s.supplierType = 2 -- 合格供应商AND s.isBacklist!=1    -- 非禁用AND s.isstart!=1       -- 非停用