Differences

This shows you the differences between two versions of the page.

--- mysql [2026/01/19 22:48] – created phong2018
+++ mysql [2026/02/23 00:00] (current) – removed phong2018
@@ Line 1: / Line 1: @@
-====== MySQL ======
-===== Keyword Tree (click to open each child page) =====
-  * [[mysql:overview|Overview (What is MySQL?)]]
-  * [[mysql:install|Install & Tools (mysql, mysqld, client)]]
-  * [[mysql:sql|SQL Basics]]
-    * [[mysql:sql:ddl|DDL (CREATE/ALTER/DROP)]]
-    * [[mysql:sql:dml|DML (SELECT/INSERT/UPDATE/DELETE)]]
-    * [[mysql:sql:dcl|DCL (GRANT/REVOKE)]]
-    * [[mysql:sql:tcl|TCL (COMMIT/ROLLBACK)]]
-  * [[mysql:datatypes|Data Types]]
-    * [[mysql:datatypes:string|String types]]
-    * [[mysql:datatypes:numeric|Numeric types]]
-    * [[mysql:datatypes:datetime|Date & Time types]]
-    * [[mysql:datatypes:json|JSON]]
-  * [[mysql:schema|Schema & Table Design]]
-    * [[mysql:schema:normalization|Normalization]]
-    * [[mysql:schema:constraints|Constraints (PK/FK/UNIQUE/CHECK)]]
-    * [[mysql:schema:relationships|Relationships (1-1, 1-N, N-N)]]
-  * [[mysql:index|Indexing]]
-    * [[mysql:index:btree|B-Tree index]]
-    * [[mysql:index:fulltext|FULLTEXT index]]
-    * [[mysql:index:composite|Composite index]]
-  * [[mysql:queries|Joins & Query Patterns]]
-    * [[mysql:queries:inner_join|INNER JOIN]]
-    * [[mysql:queries:left_join|LEFT JOIN]]
-    * [[mysql:queries:subquery|Subquery]]
-    * [[mysql:queries:cte|CTE (WITH)]]
-  * [[mysql:tx|Transactions & Concurrency]]
-    * [[mysql:tx:acid|ACID]]
-    * [[mysql:tx:isolation|Isolation Levels]]
-    * [[mysql:tx:locking|Locking]]
-    * [[mysql:tx:deadlock|Deadlock]]
-  * [[mysql:engine|Storage Engines]]
-    * [[mysql:engine:innodb|InnoDB]]
-  * [[mysql:charset|Charset & Collation (utf8mb4)]]
-  * [[mysql:optimize|EXPLAIN & Query Optimization]]
-  * [[mysql:backup|Backup & Restore]]
-    * [[mysql:backup:mysqldump|mysqldump]]
-  * [[mysql:replication|Replication]]
-  * [[mysql:security|Security (Users, Privileges)]]
-  * [[mysql:config|Configuration (my.cnf)]]
-  * [[mysql:monitoring|Monitoring (slow log, metrics)]]