From 326815aaf1f27c8f5b8a97e24b4df480c01985d5 Mon Sep 17 00:00:00 2001 From: TheSiahxyz <164138827+TheSiahxyz@users.noreply.github.com> Date: Fri, 13 Dec 2024 22:54:00 +0900 Subject: modified MySQL.md --- SI/Resource/Data Science/SQL/MySQL/MySQL.md | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) 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 -- cgit v1.2.3