SQL在线美化工具

原创

AI在线工具

修改于 2025-05-16 19:53:08

1.2K0

文章被收录于专栏：在线AI工具在线AI工具

在处理SQL语句查询的时候，往往会遇到复杂、阅读不友好的语句。

冗余嵌套的语法结构、混乱的缩进格式以及非标准化的关键字书写方式，不仅会显著增加代码解读的时间成本，更会导致团队协作效率下降与潜在错误风险的累积。

为解决这一问题，我专门开发了一个可在线美化SQL的工具，可将杂乱的SQL脚本转化为符合ANSI/ISO标准的可读性代码，使开发人员能够更高效地进行语句调试与版本维护工作。

未美化前：

SELECT DATE_FORMAT(b.t_create, '%Y-%c-%d') dateID, b.title memo

FROM (SELECT id FROM orc_scheme_detail d WHERE d.business=208

AND d.type IN (29,30,31,321,33,34,3542,361,327,38,39,40,41,42,431,4422,415,4546,47,48,'a',

29,30,31,321,33,34,3542,361,327,38,39,40,41,42,431,4422,415,4546,47,48,'a')

AND d.title IS NOT NULL AND t_create >=

DATE_FORMAT((DATE_SUB(NOW(),INTERVAL 1 DAY)),'%Y-%c-%d') AND t_create

< DATE_FORMAT(NOW(), '%Y-%c-%d') ORDER BY d.id LIMIT 2,10) a,

orc_scheme_detail b WHERE a.id = b.id

美化后：

SELECT
  DATE_FORMAT(b.t_create, '%Y-%c-%d') dateID,
  b.title memo
FROM
  (
    SELECT
      id
    FROM
      orc_scheme_detail d
    WHERE
      d.business = 208
      AND d.type IN (
        29, 30, 31, 321, 33, 34, 3542, 361, 327,
        38, 39, 40, 41, 42, 431, 4422, 415, 4546,
        47, 48, 'a', 29, 30, 31, 321, 33, 34, 3542,
        361, 327, 38, 39, 40, 41, 42, 431, 4422,
        415, 4546, 47, 48, 'a'
      )
      AND d.title IS NOT NULL
      AND t_create >= DATE_FORMAT(
        (
          DATE_SUB(NOW(), INTERVAL 1 DAY)
        ),
        '%Y-%c-%d'
      )
      AND t_create < DATE_FORMAT(NOW(), '%Y-%c-%d')
    ORDER BY
      d.id
    LIMIT
      2, 10
  ) a,
  orc_scheme_detail b
WHERE
  a.id = b.id