hUYgBDdj

1USE foo;
2DROP TABLE IF EXISTS tmp;
3CREATE TABLE tmp (
4  id         INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
5  school_id  CHAR(4) NOT NULL,
6  student_id CHAR(6) NOT NULL,
7  INDEX school_id(school_id),
8  INDEX student_id(student_id),
9  INDEX school_id_and_student_id(school_id, student_id)
10);
11DROP PROCEDURE IF EXISTS tmpproc;
12CREATE PROCEDURE tmpproc() BEGIN
13  DECLARE i INT UNSIGNED DEFAULT 0;
14  WHILE i < 10000000 DO
15    INSERT INTO tmp (school_id, student_id)
16    VALUES (SUBSTR(MD5(RAND()) FROM 1 FOR 4), SUBSTR(MD5(RAND()) FROM 1 FOR 6));
17    SET i = i + 1;
18  END WHILE;
19END;
20CALL tmpproc();