MySQL
-
1 General Information | SQL Syntax
- [1.2 Typographical and Syntax Conventions
- () , 一组
- [] , options
- | , 枚举， 选一
- {}， 多选
- 1.8 MySQL Standards Compliance | extensions | difference | constraints
- 1.8.1 MySQL Standards Compliance extensions
- 1.8.2 MySQL Standards Compliance difference
- 1.8.2 MySQL Standards Compliance constraints
- [1.2 Typographical and Syntax Conventions
-
8 Optimizing
- 8.2 Optimizing SQL Statements
- 8.2.1 Optimizing SELECT Statements | where 易读，避免全表扫 | range
- 8.2.1 Optimizing SELECT Statements | Index lookup | Index Range Scan | Inner hash join | Nested loop inner join
- 8.2.2 Optimizing Subqueries, Derived Tables, View References, and Common Table Expressions
- 8.2.3 Optimizing INFORMATION_SCHEMA Queries
- 8.2.4 Optimizing Performance Schema Queries
- 8.2.5 Optimizing Data Change Statements
- 8.2.6 Optimizing Database Privileges
- 8.2.7 Other Optimization Tips
- 8.3 Optimization Indexes
- 8.3.1 How MySQL Uses Indexes | leftmost prefix |
- B-trees(PRIMARY KEY, UNIQUE, INDEX, and FULLTEXT)
- R-trees(spatial data types)
- 8.3.2 Primary Key Optimization
- 8.3.3 SPATIAL Index Optimization
- 8.3.4 Foreign Key Optimization
- 8.3.5 Column Indexes
- 8.3.6 Multiple-Column Indexes
- 8.3.7 Verifying Index Usage
- 8.3.8 InnoDB and MyISAM Index Statistics Collection
- 8.3.9 Comparison of B-Tree and Hash Indexes
- 8.3.10 Use of Index Extensions
- 8.3.11 Optimizer Use of Generated Column Indexes
- 8.3.12 Invisible Indexes
- 8.3.13 Descending Indexes
- 8.3.14 Indexed Lookups from TIMESTAMP Columns
- 8.3.1 How MySQL Uses Indexes | leftmost prefix |
- 8.4 Optimizing Database Structure | data size | data type | table size | row size
- 8.5 Optimizing for InnoDB Tables
- 8.6 Optimizing for MyISAM Tables
- 8.8 Query Execution Plan
- 8.9 Controlling the Query Optimizer | optimizer hints | index hints | cost
- 8.10 Buffering and Caching
- 8.11 Optimizing Locking Operations | internal lock | table lock | metadata lock | external lock
- 8.2 Optimizing SQL Statements
-
9 Language Structure
-
10 Character Sets, Collations, Unicode
-
11 Data Types
- 11.1 Numeric Data Types INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT | Fixed-Point Types |Floating-Point Types
- 11.2 Date and Time Data Types | DATETIME, and TIMESTAMP Types
- 11.3 String Data Types | char | varchar | text | enum | set
- 11.4 Spatial Data Types |Geometry Model
- 11.5 The JSON Data Type
- 11.6 Data Type Default Values
- 11.7 Data Type Storage Requirements
- 11.8 Choosing the Right Type for a Column
-
12 Functions and Operators
- 12.1 Function and Operator Reference
- 12.2 Type Conversion in Expression Evaluation
- 12.3 Operators | logical | comparison
- 12.4 Control Flow Functions
- 12.5 Numeric Functions and Operators
- 12.6 Date and Time Functions
- 12.7 String Functions and Operators
- 12.8 What Calendar Is Used By MySQL?
- 12.9 Full-Text Search Functions
- 12.10 Cast Functions and Operators
- 12.11 XML Functions
- 12.12 Bit Functions and Operators
- 12.13 Encryption and Compression Functions
- 12.14 Locking Functions
- 12.15 Information Functions
- 12.16 Spatial Analysis Functions
- 12.17 JSON Functions
- 12.20 Aggregate (GROUP BY) Functions
- 12.21 Window Functions
- 12.22 Performance Schema Functions
- 12.23 Internal Functions
-
13 SQL Statements
- 13.1 Data Definition Statements
- 13.2 Data Manipulation Statements
- 13.3 Transactional and Locking Statements
- 13.4 Replication Statements
- 13.5 Prepared Statements
- 13.7 Database Administration Statements
-
24 Stored Objects
-
16 Storage Engines
-
17 Replication
-
23 Partitioning
-
4 MySQL Programs
- 4.5.1 mysql — The MySQL Command-Line Client
- 4.5.2 mysqladmin — Client for Administering a MySQL Server
- 4.5.3 mysqlcheck — A Table Maintenance Program
- 4.5.4 mysqldump — A Database Backup Program
- 4.5.5 mysqlimport — A Data Import Program
- 4.5.6 mysqlpump — A Database Backup Program
- 4.5.7 mysqlshow — Display Database, Table, and Column Information
- 4.5.8 mysqlslap — Load Emulation Client
