About Mysql
1. mysql Workflow analysis
2. MySQL Single instance installation (5.6.31)
DATABASE
1.4 Isolation Levels for transactions
—————————————————— MySQL Management ——————————————————
User Management
1. Login and exit
2. Create and delete
3. Change the password
4. Show current user/query all users/query users and their permissions
Rights Management
1. Permissions table
2. Grant (Permissions granted)
3. REVOKE (Revoke permission)
4. Select/show GRANTS (View permissions)
—————————————————— MySQL Operation ——————————————————
Query operations
1. Query fields
#查询所有字段
#查询指定字段
2. Querying a specified record (where condition expression)
#比较
#指定范围查询 between in
#指定集合查询 in
#匹配字符查询 like
#查询空值
#带AND | Multi-criteria query for or
3. Further operation of the query results
#distinct查询结果不重复
Sort #order by Query results
#limit限制查询结果数目
#union合并查询结果
4. Aggregate functions
#count ()
#sum ()
#avg ()
#max ()
#min ()
5. Packet query (group BY)
#group by + group_concat ()
#group by + aggregate function
#group by + have
#group by + with rollup
6. Connection Query
#内连接查询
#外连接查询
|--> Left connection Query
|--> Right Connection query
#复合条件的连接查询
7. Sub-query
#带IN的子查询
#带比较运算符的子查询
#带exists的子查询
#带any的子查询
#带all的子查询
8. Alias tables and fields
9. Using Regular expression queries
#查询以特定字符 (String) record at the beginning
Record at the end of a #查询以特定字符 (string)
#使用 "." or "*" or "+" to match 1 or more characters
#匹配指定字符 (String)
#{m,n} match string consecutive occurrences
manipulating databases
Table Operations
<mysql index>