如何在MySQL中使用“WITH”子句？我正在將我所有的SQLServer查詢轉換為MySQL，并將我的查詢轉換為WITH他們都失敗了。下面是一個例子：WITH t1 AS(
SELECT article.*, userinfo.*, category.*
FROM question INNER JOIN userinfo ON userinfo.user_userid = article.article_ownerid
INNER JOIN category ON article.article_categoryid = category.catid
WHERE article.article_isdeleted = 0)SELECT t1.*FROM t1ORDER BY t1.article_date DESCLIMIT 1, 3
3 回答
精慕HU
TA貢獻1845條經驗 獲得超8個贊
WITH RECURSIVE my_cte AS
(
SELECT 1 AS n
UNION ALL
SELECT 1+n FROM my_cte WHERE n<10
)
SELECT * FROM my_cte;
+------+
| n |
+------+
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
+------+
10 rows in set (0,00 sec)
添加回答
舉報
0/150
提交
取消