msyql select 1到1024

最新推荐文章于 2024-04-25 20:51:25 发布

kawayime

最新推荐文章于 2024-04-25 20:51:25 发布

阅读量362

点赞数

分类专栏： mysql 文章标签： mysql

本文链接：https://blog.csdn.net/kawayime/article/details/84530474

版权

mysql 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

mysql select 1到1024;
SELECT
TWO_1.num+TWO_2.num+TWO_4.num+TWO_8.num+TWO_16.num+TWO_32.num+
TWO_64.num+TWO_128.num+TWO_256.num+TWO_512.num num
FROM
(SELECT 0 num UNION ALL SELECT 1 num) TWO_1
cross JOIN (SELECT 0 num UNION ALL SELECT 2 num) TWO_2
CROSS JOIN (SELECT 0 num UNION ALL SELECT 4 num) TWO_4
CROSS JOIN (SELECT 0 num UNION ALL SELECT 8 num) TWO_8
CROSS JOIN (SELECT 0 num UNION ALL SELECT 16 num) TWO_16
CROSS JOIN (SELECT 0 num UNION ALL SELECT 32 num) TWO_32
CROSS JOIN (SELECT 0 num UNION ALL SELECT 64 num) TWO_64
CROSS JOIN (SELECT 0 num UNION ALL SELECT 128 num) TWO_128
CROSS JOIN (SELECT 0 num UNION ALL SELECT 256 num) TWO_256
CROSS JOIN (SELECT 0 num UNION ALL SELECT 512 num) TWO_512