Navigation

    MemFireDB论坛

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    1. Home
    2. pekin
    • Profile
    • Following 1
    • Followers 0
    • Topics 1
    • Posts 13
    • Best 3
    • Groups 0

    pekin

    @pekin

    一个bug制造机器,天渐凉,保护自己的脑壳

    4
    Reputation
    3
    Profile views
    13
    Posts
    0
    Followers
    1
    Following
    Joined Last Online
    Website pekin.store Location 西安 Age 29

    pekin Unfollow Follow

    Best posts made by pekin

    • Navicat Premium 通过PostgreSQL连接MemFireDB(通过账号密码方式)

      1、先安装navicat
      链接:https://pan.baidu.com/s/17r_oHwjeiC6Pqdq2c8yFLQ
      提取码:s4l7
      复制这段内容后打开百度网盘手机App,操作更方便哦

      073ce18c-9342-4caa-9095-e02245cd82ae-image.png
      2、安装成功后
      通过PostgreSQL链接
      ca27614f-11cd-4fd5-b2b9-4291047db759-image.png
      填写信息
      438f1599-8a0b-425c-ad01-b5aa7711b7cd-image.png

      测试
      920df8b1-e8aa-42e0-be4a-675b46db8845-image.png

      感觉写的好沙雕😰 👮 官方图标好看

      eg:当你有一天尝尽了社会的无情,爱情的不堪,人心的险恶,你终会明白别人的屋檐再大都不如自己有把伞
      
      posted in MemFireDB新手区
      pekin
      pekin
    • RE: 叮~您有一封国庆SQL闯关邀请函,请查收

      第一关

      select concat(right(attr,2),right(left(attr,4),2)) from level1
      

      cb724f4b-e0fe-4f81-a7d0-e3cf750c8d2c-image.png
      第二关

      with tmp as (select num, string_agg(content, ' ') str
                   from (select num, array_to_string(array_agg(concat(guo, qing, kuai, le)), '') as content
                         from (select row_number() over (PARTITION BY attr)   num,
                                      CASE attr WHEN '国' THEN '国' ELSE '' END guo,
                                      CASE attr WHEN '庆' THEN '庆' ELSE '' END qing,
                                      CASE attr WHEN '快' THEN '快' ELSE '' END kuai,
                                      CASE attr WHEN '乐' THEN '乐' ELSE '' END le
                               from level2) as rn
                         group by num, guo, qing, kuai, le
                         order by num, guo desc, qing desc, kuai desc, le desc) as nc
                   group by num
                   order by num)
      
      select '                   ' chart union all
      select '       chart       ' chart union all
      select '-------------------' chart union all
      select chart
      from (select format('%2s | %s  ', lpad(concat(tmp.num), 2, '0'),
                          concat(CASE
                                     WHEN position('国' in str) = 0 THEN '   '
                                     ELSE (CASE
                                               WHEN position('庆' in str) <> 0 or position('快' in str) <> 0 or
                                                    position('乐' in str) <> 0 THEN ''
                                               ELSE str END) END,
                                 CASE
                                     WHEN position('庆' in str) = 0 THEN '   '
                                     ELSE (CASE
                                               WHEN position('快' in str) <> 0 or position('乐' in str) <> 0 THEN ''
                                               ELSE str END) END,
                                 CASE
                                     WHEN position('快' in str) = 0 THEN '   '
                                     ELSE (CASE WHEN position('乐' in str) <> 0 THEN '' ELSE str END) END,
                                 CASE WHEN position('乐' in str) = 0 THEN '   ' ELSE str END)) chart
            from tmp
            order by num desc) as tc
      union all
      select '-------------------' chart
      union all
      select '    2022-10-01     ' chart;
      

      467d0f25-66b9-4cb3-9be4-d52e620357b8-image.png

      posted in 活动
      pekin
      pekin
    • RE: 咚~1024邀请函,进击的“程序猿”

      全评论区最烂

      select  '
              *   *****   *****   *   *
              *   *   *       *   *   *
              *   *   *   *****   *****
              *   *   *   *           *
              *   *****   *****       *' as zero
      

      3dc9936d-b9ab-41ce-82b8-01adc2244d90-image.png

      posted in 活动
      pekin
      pekin

    Latest posts made by pekin

    • RE: 咚叮咚~进击的“程序猿”--第三弹

      一箱 6个核桃没了
      cef09347-c6b3-49cf-977c-83381b1a2998-image.png

      posted in 活动
      pekin
      pekin
    • RE: 咚叮咚~进击的“程序猿”--第三弹

      @rui 等我再喝两罐 三个核桃

      posted in 活动
      pekin
      pekin
    • RE: 咚叮~进击的“程序猿”--第二弹

      @彭于晏 e571a133-9e6b-47a5-964d-f63343d80748-image.png

      posted in 活动
      pekin
      pekin
    • RE: 咚叮~进击的“程序猿”--第二弹

      4334aa50-6091-4517-b509-b219ee624de7-image.png

      posted in 活动
      pekin
      pekin
    • RE: 咚叮~进击的“程序猿”--第二弹

      @花殇 哈哈哈哈,大意了

      posted in 活动
      pekin
      pekin
    • RE: 咚~1024邀请函,进击的“程序猿”

      继续摸鱼

      select '
         _     __      ___    __ __      
       /  \  / __ \  / ___ \ /\ \\ \     
      /\_  \/\ \/\ \/\_\ /\ \\ \ \\ \    
      \/_/\ \ \ \ \ \/_/// /__\ \ \\ \_  
         \ \ \ \ \_\ \ // /_\ \\ \__  __\
          \ \_\ \____//\______/ \/_/\_\_/
           \/_/\/___/ \/_____/     \/_/  
      ' as zero
      

      8047169b-86f5-4822-8939-3bb32041e776-image.png 🏃 🏃 🏃 🏃 🏃 👅 👅 👅 👅 👅 👅 😸 😸 😸 😸 😸

      posted in 活动
      pekin
      pekin
    • RE: 咚~1024邀请函,进击的“程序猿”

      @花殇 看来咱两的差不多,哈哈哈哈
      👯 👯 👯 👯

      posted in 活动
      pekin
      pekin
    • RE: 咚~1024邀请函,进击的“程序猿”

      全评论区最烂

      select  '
              *   *****   *****   *   *
              *   *   *       *   *   *
              *   *   *   *****   *****
              *   *   *   *           *
              *   *****   *****       *' as zero
      

      3dc9936d-b9ab-41ce-82b8-01adc2244d90-image.png

      posted in 活动
      pekin
      pekin
    • RE: 叮~您有一封国庆SQL闯关邀请函,请查收

      第一关

      select concat(right(attr,2),right(left(attr,4),2)) from level1
      

      cb724f4b-e0fe-4f81-a7d0-e3cf750c8d2c-image.png
      第二关

      with tmp as (select num, string_agg(content, ' ') str
                   from (select num, array_to_string(array_agg(concat(guo, qing, kuai, le)), '') as content
                         from (select row_number() over (PARTITION BY attr)   num,
                                      CASE attr WHEN '国' THEN '国' ELSE '' END guo,
                                      CASE attr WHEN '庆' THEN '庆' ELSE '' END qing,
                                      CASE attr WHEN '快' THEN '快' ELSE '' END kuai,
                                      CASE attr WHEN '乐' THEN '乐' ELSE '' END le
                               from level2) as rn
                         group by num, guo, qing, kuai, le
                         order by num, guo desc, qing desc, kuai desc, le desc) as nc
                   group by num
                   order by num)
      
      select '                   ' chart union all
      select '       chart       ' chart union all
      select '-------------------' chart union all
      select chart
      from (select format('%2s | %s  ', lpad(concat(tmp.num), 2, '0'),
                          concat(CASE
                                     WHEN position('国' in str) = 0 THEN '   '
                                     ELSE (CASE
                                               WHEN position('庆' in str) <> 0 or position('快' in str) <> 0 or
                                                    position('乐' in str) <> 0 THEN ''
                                               ELSE str END) END,
                                 CASE
                                     WHEN position('庆' in str) = 0 THEN '   '
                                     ELSE (CASE
                                               WHEN position('快' in str) <> 0 or position('乐' in str) <> 0 THEN ''
                                               ELSE str END) END,
                                 CASE
                                     WHEN position('快' in str) = 0 THEN '   '
                                     ELSE (CASE WHEN position('乐' in str) <> 0 THEN '' ELSE str END) END,
                                 CASE WHEN position('乐' in str) = 0 THEN '   ' ELSE str END)) chart
            from tmp
            order by num desc) as tc
      union all
      select '-------------------' chart
      union all
      select '    2022-10-01     ' chart;
      

      467d0f25-66b9-4cb3-9be4-d52e620357b8-image.png

      posted in 活动
      pekin
      pekin
    • RE: 叮~您有一封国庆SQL闯关邀请函,请查收

      @rui 哈哈哈哈,这出题人绝对领悟到了羊的精髓了👶 🤡

      posted in 活动
      pekin
      pekin