接下来，生成从 1 至 899 的连续编号。
SELECT a.num + (b.num * 10) + (c.num * 100) AS num FROM Digits AS a
CROSS JOIN Digits AS b
CROSS JOIN Digits AS c
WHERE a.num + (b.num * 10) + (c.num * 100) BETWEEN 1 AND 899;
一、生成数列1.1 生成连续编号首先构建一张 Digits 表，包含数字 0 至 9。Table: DigitsSELECT a.num + (b.num * 10) AS num FROM Digits AS aCROSS JOIN Digits AS b;1.2 生成部分编号接下来，生成从 1 至 899 的连续编号。SELECT a.num + (b.num * 10) + (c.num ...
CREATE table rabbit(
num tinyint UNSIGNED auto_increment primary key,
rabbit_num DECIMAL(21) UNSIGNED DEFAULT 1);
DELIMITER //
CREATE PROCEDURE rabbitnum()
BEGIN
declare n i
Oracle
生成
自然序列
SELECT rownum AS rownum_id, 1527609600 + (rownum - 1) * 60 * 15 AS sjsj
FROM dual CONNECT BY rownum < (1527677219 - 1527609600) / (60 * 15) + 1;
Mysql
切分时间片段
SELECT DATE_ADD('2021-06-07',INTERVAL 3*help_topic_id MINUTE) AS begin_time,DATE_
