MySQL 8.0 新特性- SQL DML
• 通用表达式
• WITH ... SELECT ...
• WITH ... UPDATE ...
• WITH ... DELETE ...
WITH
cte1 AS (SELECT a, b FROM table1),
cte2 AS (SELECT c, d FROM table2)
SELECT b, d FROM cte1 JOIN cte2
WHERE cte1.a = cte2.c;
• 递归: WITH RECURSIVE CTE
相关文档
评论