A tally table consists of a single field that simply counts up. The following SQL will create the table and add 10,000 rows.
-- Create the tally table. CREATE TABLE tally ( id int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (id) ); -- Populate it delimiter // CREATE PROCEDURE create_tally() BEGIN SET @x = 0; WHILE @x<100000 DO --Insert a single row into tally. INSERT INTO tally (id) VALUES (NULL); SET @x = @x + 1; END WHILE; END// delimiter ; CALL create_tally(); DROP PROCEDURE create_tally;