BEGIN #Routine body goes here... declare num int; set num = 0; while num < 114 DO insert into t_dic_city_location VALUES("1","2","3"); set num = num + 1; end WHILE; END