Init

1 files changed, 32 insertions, 4 deletions

diff --git a/SI/Resource/Data Science/SQL/MySQL/MySQL.md b/SI/Resource/Data Science/SQL/MySQL/MySQL.md
index cc23029..5990a20 100644
--- a/SI/Resource/Data Science/SQL/MySQL/MySQL.md
+++ b/SI/Resource/Data Science/SQL/MySQL/MySQL.md
@@ -9,7 +9,9 @@ tags:
   - Data-Science
   - SQL
 ---
+
 # [[MySQL]]
+
 ## Variables
 
 ```sql
@@ -22,7 +24,15 @@ TIMESTAMP -- YYYY-MM-DD HH:MM:SS
 ```
 
 ## Basic
+
 ### Table
+
+- View tables
+
+```sql
+.tables -- sqlite
+```
+
 - Create tables
 
 ```sql
@@ -65,6 +75,7 @@ SET 1_column_name = new_value, (2_column_name = new_value);
 ```
 
 ### Column
+
 - ALTER columns
 
 ```sql
@@ -95,6 +106,7 @@ DROP COLUMN column_name;
 ```
 
 ### Data
+
 - INSERT INTO data
 
 ```sql
@@ -103,7 +115,7 @@ INSERT INTO table_name VALUES(data);
 INSERT INTO table_name(column_name) VALUES(data);
 ```
 
-- SELECT */data
+- SELECT \*/data
 
 ```sql
 SELECT *
@@ -121,6 +133,7 @@ WHERE a_column_name = value;
 ```
 
 ### Condition
+
 - ORDER BY ... ASCending & DESCending
 
 ```sql
@@ -166,13 +179,14 @@ WHERE column_name IN (column_name_1, column_name_2, ...);
 - BETWEEN ... AND ...
 
 ```sql
-SELECT * 
+SELECT *
 FROM table_name;
 WHERE column_name BETWEEN int AND int;
-``` 
+```
 
 #### Filtering
-- LIKE (target: char%, %char, %str%, _char%, char_%_%, char%char)
+
+- LIKE (target: char%, %char, %str%, _char%, char_%\_%, char%char)
 
 ```sql
 SELECT *
@@ -192,6 +206,7 @@ FROM table_name;
 ```
 
 ## Functions
+
 - Calculation (fn: SUM(), COUNT(), MIN(), MAX(), AVG())
 
 ```sql
@@ -235,6 +250,7 @@ FROM table_name;
 ```
 
 ### Date
+
 - Date & Time (fn: CURDATE(), CURTIME(), NOW(), YEAR(), MONTH(), DAY(), LAST_DAY(), WEEKDAY(), DAYNAME())
 
 ```sql
@@ -251,6 +267,7 @@ FROM table_name;
 ```
 
 #### Date Format
+
 - DATE_FORMAT (fm: %Y, %y, %M, %b, %W, %a, %i, %T, %m, %c, %d, %e, %I, %H, %r, %S)
 
 ```sql
@@ -259,6 +276,7 @@ FROM table_name;
 ```
 
 ## GROUP BY
+
 - GROUP BY column_name_1, column_name_2, ..., Calculation_1, Calculation_2, ...
 
 ```sql
@@ -277,6 +295,7 @@ HAVING condition;
 ```
 
 ## Division & Analysis
+
 - RANK()/DENSE_RANK() OVER (ORDER BY column_name)
 
 ```sql
@@ -286,6 +305,7 @@ FROM table_name;
 ```
 
 ### Division
+
 - PARTITION BY
 
 ```sql
@@ -295,6 +315,7 @@ FROM table_name
 ```
 
 ### Before/After
+
 - LAG(column_name, int): before /LEAD(column_name, int): after
 
 ```sql
@@ -305,6 +326,7 @@ ORDER BY column_name
 ```
 
 ### Border
+
 - ROWS (FRAME: CURRENT ROW, int PRECEDING, int FOLLOWING, UNBOUNDED PRECEDING, UNBOUNDED FOLLOWING) AND (FRAME)
 
 ```sql
@@ -326,6 +348,7 @@ ORDER BY column_name_1, column_name_2;
 ```
 
 ### Merge
+
 - (INNER) JOIN
 
 ```sql
@@ -354,7 +377,9 @@ FROM table_name_1 CROSS
 ```
 
 ## Sub Query / Temporary Table
+
 ### Multi Columns
+
 - ()
 
 ```sql
@@ -368,6 +393,7 @@ FROM
 ```
 
 ### Uni Column & Uni Data
+
 - IN
 
 ```sql
@@ -388,6 +414,7 @@ WHERE condition =(/IN)
 ```
 
 ### VIEW / WITH
+
 - Create
 
 ```sql
@@ -416,6 +443,7 @@ FROM table_name
 ```
 
 ## Custom Function
+
 - Nominal Return Value
 
 ```sql