BEGIN
DECLARE var INT;
set var = 114134;
WHILE var <1000000 DO
INSERT into events_all_time VALUES(var,'text',var);
set var = var+1;
END WHILE;
END
但是速度很慢,需要好几个小时
BEGIN
DECLARE var INT;
set var = 114134;
WHILE var <1000000 DO
INSERT into events_all_time VALUES(var,'text',var);
set var = var+1;
END WHILE;
END
但是速度很慢,需要好几个小时