diff options
| author | TheSiahxyz <164138827+TheSiahxyz@users.noreply.github.com> | 2024-12-13 22:54:00 +0900 |
|---|---|---|
| committer | TheSiahxyz <164138827+TheSiahxyz@users.noreply.github.com> | 2024-12-13 22:54:00 +0900 |
| commit | 326815aaf1f27c8f5b8a97e24b4df480c01985d5 (patch) | |
| tree | f50562cf3fad6ae8acbdcde34bb7695232bb1c22 | |
| parent | e08f00c4b47e2717bc267b645d6bcd19b46982bb (diff) | |
modified MySQL.md
| -rw-r--r-- | SI/Resource/Data Science/SQL/MySQL/MySQL.md | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/SI/Resource/Data Science/SQL/MySQL/MySQL.md b/SI/Resource/Data Science/SQL/MySQL/MySQL.md index 1e1a269..b453779 100644 --- a/SI/Resource/Data Science/SQL/MySQL/MySQL.md +++ b/SI/Resource/Data Science/SQL/MySQL/MySQL.md @@ -137,7 +137,7 @@ FROM table_name; #### FROM clause -##### Condition +##### ORDER BY - ORDER BY ... ASCending & DESCending @@ -147,6 +147,8 @@ FROM table_name; ORDER BY column_name ASC / DESC; ``` +##### LIMIT + - LIMIT int ```sql @@ -155,6 +157,8 @@ FROM table_name; LIMIT int; ``` +##### WHERE clause: Condition / Predicates + - condition (cmp: <, <=, >, >=, =, <>) ```sql |