DELIMITER $$ CREATE PROCEDURE HOUSECHARID() BEGIN DECLARE a INT Default 200000 ; #declare stating house_id here (also use for loop) DECLARE b INT Default 200000; #declare stating char_id here simple_loop: LOOP SET a=a+1; INSERT INTO `char`(char_id,account_id,name) VALUES(b+a,0,concat("House",a)); IF a>200 THEN #limit LEAVE simple_loop; END IF; END LOOP simple_loop; END $$