Article
Topic
Learning
Download
Q&A
Programming Dictionary
Game
Recent Updates
LOGIN
简体中文(ZH-CN)
English(EN)
繁体中文(ZH-TW)
日本語(JA)
한국어(KO)
Melayu(MS)
Français(FR)
Deutsch(DE)
Next Section: 2. MySQL8 related knowledge points and lock strategy
(1756 plays)
Next Section
Watch Again
ဆ
Chapter
Note
Ask
Courseware
Feedback
新版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)
Previous section
Next Section
Tutorial List
get help
Course Recommendations
Courseware download
Elementary
Vue2.0+Vue3.0 full set of video tutorials
43766 people are watching
Elementary
The most classic Node.JS full set of video tutorials
8435 people are watching
Intermediate
Band of Brothers new version PHP video tutorial
54110 people are watching
Intermediate
Band of Brothers new version Linux video tutorial
82779 people are watching
Advanced
Video tutorial on the new version of Band of Brothers Linux network service SSH service
11413 people are watching
Intermediate
The latest ThinkPHP 5.1 world premiere video tutorial (60 days to become a PHP expert online training course)
491711 people are watching
Elementary
Imperial CMS enterprise imitation website tutorial
3048 people are watching
Elementary
Newbies with zero foundation in WordPress build personal blogs and corporate websites
6743 people are watching
Elementary
Ultimate CMS zero-based website building instruction video
2724 people are watching
Elementary
Front-end project-Shangyou [HTML/CSS/JS technology comprehensive practice]
3117 people are watching
Intermediate
Vue3.0 from 0 to build a universal backend management system project practice
5351 people are watching
Elementary
Zero-based front-end course [Vue advanced learning and practical application]
2821 people are watching
Students who have watched this course are also learning
491764 plays
Let's briefly talk about starting a business in PHP
Quick introduction to web front-end development
Large-scale practical Tianlongbabu development of Mini version MVC framework imitating the encyclopedia website of embarrassing things
Getting Started with PHP Practical Development: PHP Quick Creation [Small Business Forum]
Login verification and classic message board
Computer network knowledge collection
Quick Start Node.JS Full Version
The front-end course that understands you best: HTML5/CSS3/ES6/NPM/Vue/...[Original]
Write your own PHP MVC framework (40 chapters in depth/big details/must read for newbies to advance)
notes
X
About us
Disclaimer
Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!