workze · April 29, 2020 02:13
diff --git a/mysql-cte-with.sql b/mysql-cte-with.sql

 with t1 as (select * from t_table where id = 1), t2 as (select * from t1 where id = 1)
 select * from t1, t2

 递归CTE
 with recursive cte(n) as (
  select 1
  union all
  select n+1 from cte where n < 5
 )
 select * from cte;
 ---
 n 
 ---
 1
 2
 3
 4
 5

	with t1 as (select * from t_table where id = 1), t2 as (select * from t1 where id = 1)
	select * from t1, t2

	递归CTE
	with recursive cte(n) as (
	select 1
	union all
	select n+1 from cte where n < 5
	)
	select * from cte;
	---
	n
	---
	1
	2
	3
	4
	5