1. Get to know MySQL
2. Install and configure MySQL
3.MySQL login and exit commands
4. Use common symbols in MySQL
5. Use MySQL to modify the MySQL prompt
6.SQL statement introduction and coding specifications
7. Know the character set
8.MySQL common commands and database creation operations
1MySQL data type numerical type
2. MySQL data type date and time types
3MySQL data type string type
4.MySQL database operation to create data tables
5.MySQL data table operation: View data table
6.MySQL data table operation: View data table structure
7. Record operations of MySQL data table operations
8MySQL basic data type out-of-range processing
9.MySQL field constraints
10.Primary key constraints of MySQL field constraints
11.MySQL field constraints unique key constraints
12.MySQL external constraint requirements
13.MySQL external constraint reference
14.Field operations
15. Delete constraints for field operations
16. Field operations to modify columns and data tables
1.MySQL data operation: insert data INSERT
2.MySQL data operation single table change UPDATE
3. MySQL data operation single table deletion DELETE
4. Query expression analysis and writing for MySQL data operations
5. WHERE conditional expression for MySQL database operation
6. MySQL database operation GROUP BY groups query results
7. The HAVING statement of MySQL database operation sets grouping conditions
8. The ORDER BY statement of MySQL database operation sorts the query results.
9. LIMIT limits the number of queries for MySQL database operations
10. Introduction to subquery of MySQL database operation
11.MySQL database operations subqueries caused by comparison operations
12.MySQL database operation subquery caused by [NOT]IN EXISTS
13.MySQL database operation multi-table update
14. MySQL database operation for multiple table updates in one step
15. Introduction to connection query of MySQL database operation
16.Connection query within Mysql database operation
17.MySQL database operation left outer join query
18.MySQL database operation right outer join query
19.MySQL database operation multi-table connection query
20. Some notes on connections for MySQL database operations
21.MySQL database operation self-connection query
22.MySQL database operation multi-table deletion
1.MySQL8 character function
2.MySQL8 string functions
3.MySQL8 numerical operations and functions
4.MySQL8 comparison operators and functions
5.MySQL8 date and time functions
6.MySQL8 database related information functions
7.MySQL8 aggregate function
8.MySQL8 encryption function
9.Basic introduction to MySQL8 custom functions
10.MySQL8 custom function: Create a custom function without parameters
11.MySQL8 custom creation of functions with parameters
12.MySQL8 custom function creates a function body with a composite structure
13.Introduction to stored procedures in MySQL8
14.MySQL8 stored procedure command analysis
15.MySQL8 creates a stored procedure without parameters
16.MySQL8 creates a stored procedure with IN parameters
17.MySQL8 creates a stored procedure with IN and OUT parameters
18.MySQL creates a stored procedure with multiple OUT type parameters
19.The difference between stored procedures and custom functions in MySQL8
20.MySQL8’s new JSON data type creates a JSON type table
21.MySQL8’s new JSON data type creates JSON data and inserts it into the table
22.MySQL8’s new JSON data type inserts new values into JSON data
23.MySQL8 adds new Json data type to modify JSONS data
24.MySQL8 adds JSON data type JSON deletion and other related functions
1. Understanding the storage engine of mysql8
2. MySQL8 related knowledge points and lock strategy
3.Transaction processing of related knowledge points of MySQL8
4. Features of MySQL8 storage engine
5. Setting the storage engine for MySQL8
6.MySQL8 introduces the steps of master-slave and log point-based replication
7.Mysql8 based on log point replication practice
8. Introduction to MySQL8 based on GTID replication
9.MySQL8 based on GTID replication practice_1.small
10. Backup and restore of MySQL database operations
11.Introduction to database management software mysql8
12. PHPmyADMIN mysql8 database management tool
13 Mysql8 database management tool navicat tool download (Part 1)