🍋 Developer Tools

SQL Formatter

Format and minify SQL queries

Free 仅在浏览器中 No sign-up

输入

chars words sentences lines

第二输入

选项

操作

缩进空格数

关键词大写

{# ═══════════════════════════════════════════════════════════════ DEVELOPER TOOL OPTIONS — Phase 20 (dev-* engines batch 2) ═══════════════════════════════════════════════════════════════ #}

结果

关于 SQL Formatter

Format messy SQL queries into readable, indented code or minify formatted SQL into a single line. Supports keyword uppercasing.

工作原理

Tokenizes the SQL string and inserts line breaks and indentation after major keywords (SELECT, FROM, WHERE, JOIN, etc.). Minify mode removes extra whitespace and joins everything to one line.

分步教程

1 [
2 '
3 P
4 a
5 s
6 t
7 e
8
9 a
10
11 S
12 Q
13 L
14
15 q
16 u
17 e
18 r
19 y
20
21 i
22 n
23
24 t
25 h
26 e
27
28 i
29 n
30 p
31 u
32 t
33
34 a
35 r
36 e
37 a
38 '
39 ,
40
41 '
42 C
43 h
44 o
45 o
46 s
47 e
48
49 a
50 c
51 t
52 i
53 o
54 n
55 :
56
57 F
58 o
59 r
60 m
61 a
62 t
63
64 o
65 r
66
67 M
68 i
69 n
70 i
71 f
72 y
73 '
74 ,
75
76 '
77 S
78 e
79 t
80
81 i
82 n
83 d
84 e
85 n
86 t
87 a
88 t
89 i
90 o
91 n
92
93 (
94 2
95
96 o
97 r
98
99 4
100
101 s
102 p
103 a
104 c
105 e
106 s
107 )
108 '
109 ,
110
111 '
112 T
113 o
114 g
115 g
116 l
117 e
118
119 k
120 e
121 y
122 w
123 o
124 r
125 d
126
127 u
128 p
129 p
130 e
131 r
132 c
133 a
134 s
135 i
136 n
137 g
138 '
139 ,
140
141 '
142 C
143 l
144 i
145 c
146 k
147
148 F
149 o
150 r
151 m
152 a
153 t
154 '
155 ]

提示

[
'
U
p
p
e
r
c
a
s
e
d
k
e
y
w
o
r
d
s
(
S
E
L
E
C
T
,
F
R
O
M
,
W
H
E
R
E
)
a
r
e
t
h
e
i
n
d
u
s
t
r
y
c
o
n
v
e
n
t
i
o
n
f
o
r
r
e
a
d
a
b
i
l
i
t
y
'
,
'
U
s
e
m
i
n
i
f
y
t
o
c
o
m
p
r
e
s
s
S
Q
L
f
o
r
U
R
L
s
o
r
c
o
n
f
i
g
u
r
a
t
i
o
n
f
i
l
e
s
'
,
'
T
h
e
f
o
r
m
a
t
t
e
r
h
a
n
d
l
e
s
c
o
m
m
o
n
S
Q
L
d
i
a
l
e
c
t
s
i
n
c
l
u
d
i
n
g
M
y
S
Q
L
,
P
o
s
t
g
r
e
S
Q
L
,
a
n
d
S
Q
L
i
t
e
'
]

Categories

SQL Formatter

选项

结果

关于 SQL Formatter

工作原理

分步教程

提示

常见问题