mysql 数字序列 拆分字符串 连续日期

MySQL有一张系统表 mysql.help_topic
它有一个从0~657的顺序ID的连续数字序列

生成连续的日期

select 
date_format(date_add('2019-01-01',interval +t.help_topic_id day),'%Y-%m-%d') as 'curr_date'  
from mysql.help_topic t 
where t.help_topic_id<=10;

拆分字符串

select 
t1.id,
substring_index(substring_index(t1.name,',',t2.seq),',',-1) name
-- t1.name,
-- t2.seq
from 
	(select 1 id,'a' name  union 
	select 1 id,'c,b' name  union 
	select 1 id,'e,f,g' name  union  
	select 2 id,'m,n' name  union
	select 2 id,'x,y' name
	) t1
left join 
	(select 1 as seq 
	union select 2 union select 3 union select 4 union select 5
	) t2
on t2.seq <= (length(t1.name)-length(replace(t1.name,',',''))+1)
order by id

我是手动创建，如果分隔符数量多可以替换为 mysql.help_topic

**sqllite oracle **

WITH  numbers(n) AS (
    SELECT 1 
    -- select 1 from dual 
    UNION ALL
    SELECT n + 1 FROM numbers WHERE n < 10
)
SELECT n FROM numbers;