DROP SCHEMA IF EXISTS tb300; CREATE SCHEMA tb300; USE tb300; DELIMITER § CREATE PROCEDURE create_tbl() BEGIN DECLARE cnt INTEGER DEFAULT 1; DECLARE cntminusone INTEGER DEFAULT 0; DROP TABLE IF EXISTS t0; CREATE TABLE t0(i INTEGER, j INTEGER, PRIMARY KEY(i))ENGINE=INNODB; WHILE cnt < 300 DO SET @droptable = CONCAT('DROP TABLE IF EXISTS t', cnt); PREPARE ps1 FROM @droptable; EXECUTE ps1; SET @createtable = CONCAT('CREATE TABLE t', cnt, '(i INTEGER, j INTEGER, PRIMARY KEY(i), FOREIGN KEY(i) REFERENCES t', cntminusone, '(i))Engine=Innodb'); PREPARE ps2 FROM @createtable; EXECUTE ps2; SET cnt = cnt + 1; SET cntminusone = cntminusone + 1; END WHILE; END§ DELIMITER ; CALL create_tbl();