Community
Articles
Topics
Q&A
Learn
Course
Programming Dictionary
Tools Library
Development tools
Website Source Code
PHP Libraries
JS special effects
Website Materials
Extension plug-ins
Leisure
Game Download
Game Tutorials
English
简体中文
English
繁体中文
日本語
한국어
Melayu
Français
Deutsch
Login
singup
Next Section: Data backup and restore - single table data backup
(2319 plays)
Next Section
Watch Again
ဆ
Chapter
Note
Ask
Courseware
Feedback
六天带你玩转MySQL视频教程
Chapter1 The first day of playing with mysql
1-1 Database course introduction
1-2 Database - Basics
1-3 Relational Database
1-4 Relational database keyword description
1-5 Database - SQL
1-6 mysql database
1-7 mysql server data object
1-8 Basic SQL operations - adding a new database
1-9 Basic SQL operations - View database
1-10 Basic SQL operations - update database
1-11 Basic SQL operations - delete database
1-12 Basic SQL operations - adding a new data table
1-13 Basic SQL operations - View data table
1-14 Basic SQL operations - update data table
1-15 Basic SQL operations - delete data table
1-16 Basic SQL operations - adding new data
1-17 SQL Basic Operations - View Data
1-18 Basic SQL operations - update data
1-19 Basic SQL operations - delete data
1-20 Chinese data problem
1-21 Proofreading set problem
1-22 Garbled code problem
Chapter2 The second day of playing with mysql
2-1 Review of the first day of playing with mysql
2-2 Homework - Site Statistics
2-3 Column type - integer
2-4 Column type - float
2-5 Column type - fixed point
2-6 Column type - time date type
2-7 Column type - fixed length + variable length string
2-8 Column type - text string
2-9 Column type - enum
2-10 Column type - collection
2-11 column type - mysql record length
2-12 Column properties - empty properties
2-13 Column Properties - Column Description
2-14 Column properties - default values
Chapter3 The third day of playing with mysql
3-1 Review of the second day of playing with mysql
3-2 Column Properties - Add Primary Key
3-3 Column Properties - Primary Key Constraints
3-4 Column Properties - Primary Key Delete
3-5 Column Properties - Primary Key Classification
3-6 Column properties - new auto-increment
3-7 Column Properties - Autoincrement Use
3-8 Column Properties - Modify AutoGrown
3-9 Column properties - delete autoincrement
3-10 Column Properties - Add Unique Key
3-11 Column Properties - Unique Key Constraints
3-12 Column Properties - Remove Unique Key
3-13 A brief introduction to indexing
3-14 Relationship - one to one
3-15 Relationship - one to many
3-16 Relationship - many-to-many
3-17 Paradigm - Basics
3-18 Normal Form - 1NF
3-19 Normal Form - 2NF
3-20 Normal Form - 3NF
3-21 Normalization - Denormalization
3-22 Advanced Data New - Primary Key Conflict
3-23 Advanced Data New - Worm Replication
3-24 Advanced Data Update - Limit Records
3-25 Advanced Data Removal - Delete Data
3-26 Advanced data query - select option
3-27 Advanced data query - field alias
3-28 Advanced data query - data source
3-29 Advanced data query - where clause
3-30 Advanced data query - groupby clause
3-31 Advanced data query - having clause
3-32 Advanced data query - order by clause
3-33 Advanced data query - limit clause
Chapter4 The fourth day of playing with mysql
4-1 Review of the third day of playing with mysql
4-2 Join Query - Understand
4-3 Join Query - Cross Join
4-4 Join Query - Inner Join
4-5 Join Query - Outer Join
4-6 Join Query - Natural Join
4-7 PHP operation mysql - preparation
4-8 PHP operation mysql - basic operations
4-9 PHP operation mysql - write operation
4-10 PHP operation mysql - read operation
4-11 Comprehensive application - login function
4-12 Comprehensive application - home page display
4-13 Comprehensive application - paging function
Chapter5 The fifth day of playing with mysql
5-1 Review of the fourth day of playing with mysql
5-2 Foreign Key - New
5-3 Foreign Key - Delete
5-4 Foreign Key - Default Constraint
5-5 Foreign Key - Condition
5-6 Foreign Key - Constraint Mode
5-7 Union query - basic syntax
5-8 Union query - meaning
5-9 Union query - order by
5-10 Subquery - Classification
5-11 Subquery - scalar subquery
5-12 Subquery - column subquery
5-13 Subquery - row subquery
5-14 Subquery - table subquery
5-15 Subquery - exists subquery
5-16 View - Create
5-17 View - view
5-18 View - use
5-19 View - Modify
5-20 View - Delete
5-21 view - meaning
5-22 View - Add new data operation
5-23 View - delete data operation
5-24 View - update data operation
5-25 View - Algorithm
5-26 Data backup and restore - data table backup (storage engine)
5-27 Data backup and restore - single table data backup
5-28 Data Backup and Restore - SQL Backup
5-29 Data Backup and Restore - Incremental Backup
Chapter6 The sixth day of playing with mysql
6-1 Review of the fifth day of playing with mysql
6-2 Transaction - Manual Action
6-3 Transactions - Principles
6-4 Transaction - rollback point
6-5 Transactions - Automatic Transactions
6-6 Transaction - Properties
6-7 Variables - System variables
6-8 Variables - custom variables
6-9 Triggers - a basic understanding
6-10 Trigger - Create
6-11 trigger - view
6-12 trigger - use
6-13 Trigger - Delete
6-14 Trigger - Record
6-15 Code execution structure - if branch
6-16 Code execution structure - while loop
6-17 function - system function
6-18 function - define function
6-19 Functions - view functions
6-20 Function - Delete
6-21 function - parameters
6-22 function - scope
6-23 Stored Procedure - Create
6-24 Stored Procedure - View
6-25 Stored Procedure - Call
6-26 Stored Procedure - Delete
6-27 Stored Procedure - Parameter Type
Previous section
Next Section
Tutorial List
get help
Course Recommendations
Courseware download
Elementary
Chuanzhi Podcast 2017 version takes you through HTML video tutorials in 3 days
12704 people are watching
Elementary
16 days to get you started UI video tutorial
27218 people are watching
Advanced
Video tutorial to teach you how to play Linux step by step
18702 people are watching
Elementary
HTML5 tutorial: Six hours of video tutorial on playing with js and strings-Qianfeng Education
6954 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
Elementary
WEB front-end tutorial [HTML5+CSS3+JS]
3506 people are watching
Elementary
Quick introduction to apipost
2161 people are watching
6 days to take you through the mysql course supporting learning materials
Belongs to chapter:六天带你玩转MySQL视频教程
Download
Students who have watched this course are also learning
492462 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