while i<=100 do
create table ai select * from xxx order by xxx desc limit count(xxx)/100*(i-1),count(xxx)/100
set table I add column int
alter table I set int = i
set i=i+1
end while;