新版MySQL8全套视频教程

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