定义变量i让他=1并<=80在sql语句中把 where id=100+i
UPDATE archives a JOIN archives b ON a.ID=b.id+100SET a.title=b.title, a.nw=b.nw, a.gw=b.gw WHERE a.ID>100 AND a.id<=180;这样可以