使用别名可以让语句更清晰,尤其是当主次表是同一张表时,不使用别名不行
update tablename as m1, tablename as m2 set m1.XXX=XXX where m1.XXX=m2.XXX