在MySQL中生成整數序列我需要使用包含整數n到m的表/結果集/任何東西進行連接。有沒有一種不只是建立桌子就能得到它的微不足道的方法呢？(順便說一句，這種類型的構造會被稱為“元查詢”嗎？)m-n與合理的(<1000 s)有界。
3 回答
浮云間
TA貢獻1829條經驗 獲得超4個贊
SELECT @row := @row + 1 as row, t.*FROM some_table t, (SELECT @row := 0) r
@row
慕姐4208626
TA貢獻1852條經驗 獲得超7個贊
以下內容將返回1.10000，并且不會太慢
SELECT @row := @row + 1 AS row FROM
(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t,
(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t2,
(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t3,
(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t4,
(SELECT @row:=0) numbers;
添加回答
舉報
0/150
提交
取消