CREATE PROCEDURE prepareData_t_06 ()
BEGIN
DECLARE i INT DEFAULT 1;
WHILE i < 500000 DO
insert into t_06 values (i,concat('AA',i),i);
SET i = i + 1;
END WHILE;
END;
//
delimiter ;
CALL prepareData_t_06();
select count(*) from t_06;
show index from t_06;
show table status like 't_06';