V2EX = way to explore
V2EX 是一个关于分享和探索的地方
现在注册
已注册用户请  登录
V2EX  ›  lovecy  ›  全部回复第 35 页 / 共 35 页
回复总数  685
1 ... 26  27  28  29  30  31  32  33  34  35  
2020-07-08 15:58:33 +08:00
回复了 lovecy 创建的主题 程序员 干了两年开发后,感觉快要被淘汰
@simenet 提桶跑路什么梗[笑哭]
2020-07-08 15:14:49 +08:00
回复了 weiruanniubi 创建的主题 程序员 想知道大家通勤的距离和方式,以及房租费用的占比。
广州,500m,步行,房租占 15%
2020-07-04 15:13:02 +08:00
回复了 felix021 创建的主题 推广 Linux 下删点日志也能搞死人
for i in `find ./ -name "*.log"`;do echo $i;rm -f $i;done;
目前我只能写出这种东西,啊哈哈哈哈
```
啊哈哈哈哈,没有效果啊,白格式化了大半天,貌似 markdown 语法也无效
```
SELECT a.*
FROM (
  SELECT a.*
  FROM (
    SELECT a.*
    FROM (
      SELECT a.*
      FROM (
        SELECT a.*
        FROM (
          SELECT
            PLATFORM_REQUEST_CODE AS platformRequestCode
            , AGGTEGATE_REQUEST_CODE AS aggtegateRequestCode
            , CREATE_TIME AS createTime
            , STATUS AS payStatus, MERCHANT_GENERATE_CODE AS platformCode
            , USER_CODE AS buyCode
            , CHANNEL_NO AS channelNo
          FROM tb_aggtegate_payment_request
          WHERE STATUS != '00' AND DEL_FLAG = 0 AND IS_VALID = 0
          ORDER BY CREATE_TIME DESC
        ) `a` LEFT JOIN (
          SELECT CHANNEL_REQUEST_CODE AS channelOrderCode, AGGTEGATE_REQUEST_CODE AS channelaggtegateRequestCode
          FROM tb_channel_send_report WHERE DEL_FLAG = 0
        ) `b` ON a.aggtegateRequestCode = b.channelaggtegateRequestCode
      ) `a` LEFT JOIN (
        SELECT MERCHANT_INFO_CODE, MERCHANT_INFO_NAME AS platformName
        FROM tb_merchant_info
        WHERE DEL_FLAG = 0
      ) `c` ON c.MERCHANT_INFO_CODE = a.platformCode
    ) `a` LEFT JOIN (
      SELECT PLATFORM_USER_CODE, MERCHANT_NAME AS merchantName
      FROM tb_user_info
      WHERE DEL_FLAG = 0
    ) `b` ON a.buyCode = b.PLATFORM_USER_CODE
  ) `a` LEFT JOIN (
    SELECT CHANNEL_CODE, CHANNEL_NAME AS channelName
    FROM tb_channel_info
    WHERE DEL_FLAG = 0
  ) `b` ON a.channelNo = b.CHANNEL_CODE
) `a` LEFT JOIN (
  SELECT AGGTEGATE_REQUEST_CODE, TIME_END AS payTime
  FROM tb_wxpay_order_business
  WHERE DEL_FLAG = 0 AND IS_VALID = 0
) `b` ON a.aggtegateRequestCode = b.AGGTEGATE_REQUEST_CODE
WHERE 1 = 1
1 ... 26  27  28  29  30  31  32  33  34  35  
关于   ·   帮助文档   ·   博客   ·   API   ·   FAQ   ·   我们的愿景   ·   实用小工具   ·   3248 人在线   最高记录 6543   ·     Select Language
创意工作者们的社区
World is powered by solitude
VERSION: 3.9.8.5 · 26ms · UTC 13:56 · PVG 21:56 · LAX 06:56 · JFK 09:56
Developed with CodeLauncher
♥ Do have faith in what you're doing.