How to Print Prime number using SQL

weixin_30394669

于 2019-05-22 23:48:00 发布

阅读量101

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/codingyangmao/p/10909347.html

博客展示了使用SQL语句打印素数的代码。通过一系列的SELECT语句和子查询，结合变量赋值和条件判断，筛选出1到1000之间的素数，并使用GROUP_CONCAT函数将结果连接输出。代码转载自相关博客。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SELECT
    GROUP_CONCAT(NUMB SEPARATOR '&')
FROM
    (
        SELECT
            @num :=@num + 1 AS NUMB
        FROM
            information_schema. TABLES t1,
            information_schema. TABLES t2,
            (SELECT @num := 1) tmp
    ) tempNum
WHERE
    NUMB <= 1000
AND NOT EXISTS (
    SELECT
        *
    FROM
        (
            SELECT
                @nu :=@nu + 1 AS NUMA
            FROM
                information_schema. TABLES t1,
                information_schema. TABLES t2,
                (SELECT @nu := 1) tmp1
            LIMIT 1000
        ) tatata
    WHERE
        FLOOR(NUMB / NUMA) =  (NUMB / NUMA) 
    AND NUMA *NUMA <= NUMB

)