Test table with 100000 rows

CREATE TABLE `test_data`
(
  `id`      bigint(20) NOT NULL      AUTO_INCREMENT,
  `col0`    int(11)                  DEFAULT 0,
  `col1`    int(11)                  DEFAULT 0,
  `col2`    int(11)                  DEFAULT 0,
  `sort_col`    int(11)              DEFAULT 0,
  PRIMARY KEY (`id`)
);

DELIMITER $$
CREATE PROCEDURE generate_data()
BEGIN
  DECLARE i INT DEFAULT 0;
  WHILE i < 100000 DO
    INSERT INTO `test_data` (`col0`,`col1`,`col2`) VALUES (
      ROUND(RAND()*1000,0),
      ROUND(RAND()*1000,0),
      ROUND(RAND()*1000,0)
    );
    SET i = i + 1;
  END WHILE;
  UPDATE test_data SET sort_col = col1*col2;
END$$
DELIMITER ;

CALL generate_data();