· 7 years ago · Dec 01, 2018, 09:50 AM
1CREATE TABLE sequence (
2 seq INTEGER NOT NULL PRIMARY KEY
3);
4
5DELIMITER //
6DROP PROCEDURE IF EXISTS make_sequence;
7CREATE PROCEDURE make_sequence() LANGUAGE SQL DETERMINISTIC
8BEGIN
9 INSERT INTO Sequence (seq) VALUES (1);
10 WHILE (SELECT MAX(seq) FROM Sequence) > 1000 DO
11 INSERT INTO Sequence (seq) SELECT MAX(seq) + 1 FROM Sequence;
12 END WHILE;
13END;
14//
15DELIMITER ;