MySQL

• Installation Using Binaries
  • Installing MySQL on Unix/Linux Using Generic Binaries
  • Postinstallation Setup and Testing
    • Initializing the Data Directory
    • Starting the Server
    • Testing the Server
    • Securing the Initial MySQL Accounts
    • Tips
  • References
• Installation Using Yum
  • Steps for a Fresh Installation of MySQL
  • Installing Additional MySQL Products and Components with Yum
  • References
• Using Option Files
  • Option Files Read on Windows Systems
  • Option Files Read on Unix and Unix-Like Systems
  • Option File Syntax
  • References
• mysqld
  • References
• mysqld_safe
  • mysqld_safe Options
  • References
• mysql.server
  • mysql.server Option-File Options
  • References
• mysqld_multi
  • References
• mysql_secure_installation
  • References
• mysqldump
  • Invocation Syntax
  • Option Syntax - Alphabetical Summary
  • Examples
  • Tips
  • References
• mysqlslap
  • mysqlslap Options
  • References
• ALTER USER Statement
  • References
• CREATE USER Statement
  • References
• DROP USER Statement
  • References
• GRANT Statement
  • GRANT General Overview
  • Object Quoting Guidelines
  • Account Names and Passwords
  • Privileges Supported by MySQL
  • Global Privileges
  • Database Privileges
  • Table Privileges
  • Column Privileges
  • Stored Routine Privileges
  • Proxy User Privileges
  • Implicit Account Creation
  • Other Account Characteristics
  • References
• RENAME USER Statement
  • References
• REVOKE Statement
  • References
• SET PASSWORD Statement
  • References
• InnoDB Backup and Recovery
  • InnoDB Backup
    • Hot Backups
    • Cold Backups
    • Logical Backups Using mysqldump
    • Tips
  • InnoDB Recovery
    • Point-in-Time Recovery
    • Recovery from Data Corruption or Disk Failure
    • InnoDB Crash Recovery
  • References
• MySQL Sample Database
  • Download Sample Database
  • Sample Database Schema
  • References
• MySQL Index
  • Creating indexes
    • CREATE INDEX statement
    • CREATE INDEX example
  • Removing indexes
    • DROP INDEX syntax
    • DROP INDEX examples
    • DROP PRIMARY KEY index
  • Listing table indexes
    • SHOW INDEXES command
    • SHOW INDEXES examples
  • Unique indexes
    • CREATE UNIQUE INDEX statement
    • UNIQUE Index & NULL
    • UNIQUE index examples
  • Prefix indexes
  • Invisible indexes
    • Invisible index system variables
  • Descending indexes
  • Composite indexes
  • Clustered indexes
  • Index cardinality
  • USE INDEX hint
  • FORCE INDEX hint
  • References
• MySQL Functions
  • Aggregate Functions
    • AVG function
    • COUNT function
    • SUM function
    • MAX function
    • MIN function
  • Control Flow Functions
    • CASE
    • IFNULL
    • NULLIF
  • Comparison Functions
    • COALESCE
    • GREATEST & LEAST
    • ISNULL
  • References
• MySQL Date Functions
  • CURDATE
  • DATEDIFF
  • DAY
  • DATE_ADD
  • DATE_SUB
  • DATE_FORMAT
  • DAYNAME
  • DAYOFWEEK
  • EXTRACT
  • NOW
  • MONTH
  • STR_TO_DATE
  • SYSDATE
  • TIMEDIFF
  • TIMESTAMPDIFF
  • WEEK
  • WEEKDAY
  • References
• MySQL String Functions
  • CONCAT
  • LENGTH & CHAR_LENGTH
  • LEFT
  • REPLACE
  • SUBSTRING
  • TRIM
  • FIND_IN_SET
  • FORMAT
  • References
• MySQL Math Functions
  • ABS()
  • CEIL()
  • FLOOR()
  • MOD()
  • ROUND()
  • TRUNCATE()
  • Others
  • References
• MySQL Window Functions
  • Window Function list
  • References
• MySQL my.cnf
  • my.cnf
  • References
• MySQL Docker
  • MySQL 5.x in Docker
  • MySQL 5.x in Docker Compose
    • Tests
  • MySQL 8.x in Docker Compose
    • Tests
  • MySQL Client
  • References
• phpMyAdmin Docker
  • Demo
  • Docker
  • Docker Compose
  • Environment variables summary
  • Screenshots
  • References
• Adminer Docker
  • Demo
  • Docker
  • Docker Compose
  • Choosing a design
  • Screenshots
  • References
• Yearning Docker
  • Docker
  • Docker Compose
  • Screenshots
  • References
• Locks
  • 乐观锁
    • Version
    • CAS
    • Results
  • 悲观锁
  • 分布式锁
  • 行锁
    • 读锁
    • 写锁
  • 表锁
  • 死锁
  • References