update join和delete join

UPDATE ASET A.A2 = B.B2FROM BINNER JOIN AON A.A1 = B.B1WHERE B.B2 = "XXX" 上面的语句在SQL SERVER跑没任何问题，到了MY SQL却跑不起来了MY SQL update A,B set A.A2 = B.B2 where A.A1 = B.B1 and B.B2 = "XXX"delete l.* from liquonline_cms.cmsw_publish_2_android l left join liquonline_cms.cmsw_publish_2 r on l.IndexID=r.IndexID where r.IndexID is null

转载于:https://www.cnblogs.com/killallspree/p/3497131.html