From 7aa8eb1a505d6f206286245fe519b11d96d43903 Mon Sep 17 00:00:00 2001 From: TheSiahxyz <164138827+TheSiahxyz@users.noreply.github.com> Date: Fri, 27 Dec 2024 21:42:38 +0900 Subject: modified Dashboard.md, modified Machine Learning.md", modified MySQL.md --- SI/Resource/Data Science/SQL/MySQL.md | 28 ++++++++++++++++++++++++++++ 1 file changed, 28 insertions(+) (limited to 'SI/Resource/Data Science/SQL/MySQL.md') diff --git a/SI/Resource/Data Science/SQL/MySQL.md b/SI/Resource/Data Science/SQL/MySQL.md index 992ea5d..abec6ec 100644 --- a/SI/Resource/Data Science/SQL/MySQL.md +++ b/SI/Resource/Data Science/SQL/MySQL.md @@ -19,6 +19,34 @@ tags: +- [Variables](#variables) +- [Table](#table) +- [DDL (Data Definition Language) - CREATE, ALTER, DROP, TRUNCATE](#ddl-data-definition-language---create-alter-drop-truncate) +- [DML (Data Manipulation Language): UPDATE commands (UPDATE, INSERT, DELETE) & Query command (SELECT)](#dml-data-manipulation-language-update-commands-update-insert-delete--query-command-select) + - [UPDATE commands](#update-commands) + - [Query command](#query-command) + - [FROM clause](#from-clause) + - [ORDER BY](#order-by) + - [LIMIT](#limit) + - [WHERE clause: Condition / Predicates](#where-clause-condition--predicates) + - [Filtering](#filtering) + - [Functions](#functions) + - [Date](#date) + - [Date Format](#date-format) + - [GROUP BY](#group-by) + - [Division & Analysis](#division--analysis) + - [Division](#division) + - [Before/After](#beforeafter) + - [Border](#border) + - [Merge](#merge) + - [Sub Query / Temporary Table](#sub-query--temporary-table) + - [Multi Columns](#multi-columns) + - [Uni Column & Uni Data](#uni-column--uni-data) + - [VIEW / WITH](#view--with) + - [Custom Function](#custom-function) + + + ## Variables ```sql -- cgit v1.2.3