SQL 風格

SQL 中級

Jasmin Ludolf

Data Science Content Developer, DataCamp

SQL 排版

排版不是必需
但缺乏排版會出問題

select title, release_year, country from films limit 3

|title                                           |release_year|country|
|------------------------------------------------|------------|-------|
|Intolerance: Love's Struggle Throughout the Ages|1916        |USA    |
|Over the Hill to the Poorhouse                  |1920        |USA    |
|The Big Parade                                  |1925        |USA    |

最佳做法

SELECT title, release_year, country
FROM films 
LIMIT 3;

|title                                           |release_year|country|
|------------------------------------------------|------------|-------|
|Intolerance: Love's Struggle Throughout the Ages|1916        |USA    |
|Over the Hill to the Poorhouse                  |1920        |USA    |
|The Big Parade                                  |1925        |USA    |

關鍵字用大寫
分行排列

風格指南

SELECT  
    title, 
    release_year, 
    country
FROM films 
LIMIT 3;

|title                                           |release_year|country|
|------------------------------------------------|------------|-------|
|Intolerance: Love's Struggle Throughout the Ages|1916        |USA    |
|Over the Hill to the Poorhouse                  |1920        |USA    |
|The Big Parade                                  |1925        |USA    |

風格指南

Holywell 的風格指南： https://www.sqlstyle.guide/

一串塗鴉逐步變成直線

寫出清楚易讀的程式碼

分號

SELECT title, release_year, country
FROM films 
LIMIT 3;

最佳做法
跨 SQL 方言更好轉換
標示查詢結束

處理非標準欄位名稱

用 release year 取代 release_year
非標準欄位名用雙引號包起來

SELECT title, "release year", country
FROM films 
LIMIT 3;

為何要排版？

更容易協作
乾淨易讀
顯得專業
更好理解
更易除錯

一起來練習吧！

SQL 中級