MySQL 在MySQL中生成整数序列

SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5;

DELIMITER CREATE FUNCTION generate_series(start INT, stop INT)
   RETURNS TABLE
   AS
   RETURN (
      WITH RECURSIVE tmp(value) AS (
         SELECT start
         UNION ALL
         SELECT value + 1 FROM tmp WHERE value

DELIMITER ;

SELECT * FROM generate_series(1, 5);