Wiki.Quizz.vn

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== 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)]]