使用别名可以让语句更清晰,尤其是当主次表是同一张表时,不使用别名不行
update tablename as m1, tablename as m2 set m1.XXX=XXX where m1.XXX=m2.XXX
使用别名可以让语句更清晰,尤其是当主次表是同一张表时,不使用别名不行
update tablename as m1, tablename as m2 set m1.XXX=XXX where m1.XXX=m2.XXX
转载于:https://www.cnblogs.com/altya/archive/2011/04/28/2031966.html