Lompat ke kandungan utama

Pemformat SQL

Alat Pembangun

Kata kunci huruf besar, inden, kecilkan

Jawapan Pantas

SQL Formatter: Uppercase keywords, indent, minify. SQL Formatter uses standard developer formulas to compute accurate results instantly.

Input SQL

Output

SELECT
    u.id,
    u.name,
    COUNT(o.id) AS orders,
    SUM(o.amount) AS total
FROM users u
LEFT
JOIN orders o
  ON u.id = o.user_id
WHERE u.status = 1
  AND o.created_at > '2024-01-01'
  OR o.amount > 1000
GROUP BY u.id, u.name
HAVING COUNT(o.id) > 3
ORDER BY total DESC
LIMIT 20;
285 Aksara · 16 Baris
Ini pemformatan kata kunci ringan: besarkan kira-kira 40 kata kunci SQL dan buat lekukan baris bahagian mengikut klausa utama (SELECT/FROM/WHERE/GROUP BY/ORDER BY/LIMIT/JOIN/ON/AND/OR…). Tidak menghurai literal rentetan & subkueri bersarang dengan tepat — disyorkan gunakan sql-formatter dalam rantaian alat untuk persekitaran pengeluaran.

Adakah alat ini membantu anda?

Cara Guna

  1. Paste or type content: drop code/text into the SQL Formatter or fill the parameters.
  2. Choose mode/options: switch format, rules or processing as needed.
  3. Live output: results appear instantly — nothing is submitted, data stays in your browser.
  4. One-click copy: copy the output straight into your development environment.

Perkara Utama

  • SQL Formatter is a free online developer tool — open and use, no sign-up.
  • All calculations run locally in your browser; your data never leaves the device.
  • Key capability: Uppercase keywords, indent, minify.
  • Results come with formulas and reference tables so you can verify every number.

Prinsip & Formula

SQL Formatter formula

SQL Formatter uses standard developer formulas to compute accurate results instantly.

Soalan Lazim

How do I use the SQL Formatter?
Open the page and fill in the input fields — results update automatically. Uppercase keywords, indent, minify.
Are the results accurate?
Yes. Standard formulas and conversion factors are used and verified.
Is it free? Do I need to sign up?
Completely free. No registration, login or download required.
Does it work on mobile?
Yes. The responsive design works on phones, tablets and desktops.
Is my data saved?
No. Everything runs locally in your browser.

Alat Berkaitan

Panduan berkaitan

Sumber & Kemas Kini

Based on RFC 4648, ECMA-262 and related specifications. Last updated: 2025-07

Kemas Kini Terkini:

Formula dan kandungan di halaman ini telah disemak semula oleh pasukan YiJianSuan, hanya untuk rujukan pembelajaran — sila rujuk sumber rasmi untuk urusan sebenar.

Kandungan diselenggara dan disemak semula secara berkala oleh pasukan editorial YiJianSuan — proses kemas kini dan semakan boleh dilihat diDasar Editorial.

Petik Halaman Ini: YiJianSuan. Pemformat SQL[EB/OL]. https://www.yijiansuan.com/ms/c/dev/sql-format

Keputusan yang diberikan oleh alat ini hanyalah untuk rujukan, tidak membentuk sebarang nasihat profesional — sila rujuk pengiraan rasmi.