mysql 生成连续数字

CREATE TABLE example_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100)
);

INSERT INTO example_table (name) VALUES ('Alice');
INSERT INTO example_table (name) VALUES ('Bob');

SELECT * FROM example_table;

DELIMITER //

CREATE PROCEDURE generate_sequence(IN num INT)
BEGIN
    DECLARE i INT DEFAULT 1;
    WHILE i <= num DO
        SELECT i;
        SET i = i + 1;
    END WHILE;
END //

DELIMITER ;

CALL generate_sequence(5);

ALTER TABLE example_table AUTO_INCREMENT = 1;

DELIMITER //

CREATE FUNCTION generate_sequence(num INT) RETURNS VARCHAR(255)
BEGIN
    DECLARE result VARCHAR(255) DEFAULT '';
    DECLARE i INT DEFAULT 1;
    WHILE i <= num DO
        SET result = CONCAT(result, i, ', ');
        SET i = i + 1;
    END WHILE;
    RETURN SUBSTRING(result, 1, LENGTH(result) - 2);
END //

DELIMITER ;

SELECT generate_sequence(5);