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: show database
(1162 plays)
Next Section
Watch Again
ဆ
Chapter
Note
Ask
Courseware
Feedback
Master the basics of MySQL in 6 days video
Chapter1 Chapter One
1-1 MySQL learning path
1-2 Basic introduction to database learning path
1-3 Database basics
1-4 Database classification
1-5 Relational Database
1-6 non-relational database
1-7 Basic introduction to SQL
1-8 Basic introduction to MySQL
1-9 MySQL access
1-10 Summary of basic introduction to database
Chapter2 Chapter two
2-1 MySQL basic operation learning path
2-2 SQL syntax rules
2-3 SQL library operation learning path
2-4 Create database
2-5 show database
2-6 Use database
2-7 Modify database
2-8 Delete database
2-9 Summary of SQL library operations
2-10 SQL table operation learning path
Chapter3 third chapter
3-1 Create data table
3-2 show data table
3-3 View datasheet
3-4 Change data table
3-5 Change field learning path
3-6 Add new field
3-7 field position
3-8 Change field name
3-9 Modify fields
3-10 Delete field
Chapter4 Chapter Four
4-1 Summary of SQL table operations
4-2 SQL database operation learning path
4-3 Add new data
4-4 View data
4-5 update data
4-6 delete data
4-7 Summary of SQL data operations
4-8 Character set learning path
4-9 Character set concept
4-10 MySQL character set
Chapter5 chapter Five
5-1 Solving the problem of garbled characters
5-2 Character set setting principle
5-3 Character set summary
5-4 Proofreading Set Learning Path
5-5 Proofreading set concept
5-6 Proofing set settings
5-7 Proofreading set application
5-8 Proofreading set summary
5-9 Field type learning path
5-10 Field type role
Chapter6 Chapter Six
6-1 integer type
6-2 display width
6-3 Decimal type (floating point number)
6-4 Decimal type (fixed point number)
6-5 String type (fixed length)
6-6 String type (variable length)
6-7 String type (text string)
6-8 String type (enumeration)
6-9 String type (collection)
6-10 Time date type (year)
Chapter7 Chapter VII
7-1 Time date type (timestamp)
7-2 Time date type (date)
7-3 Time date type (date time)
7-4 Time date type (time)
7-5 Field type summary
7-6 Attribute learning path
7-7 Attribute function
7-8 Null attribute
7-9 Default attribute
7-10 primary key
Chapter8 chapter eight
8-1 Primary key management
8-2 self-increasing property
8-3 self-growth management
8-4 unique key
8-5 Unique key management
8-6 comment attribute
8-7 Property summary
8-8 MySQL record length
8-9 Paradigm learning path
8-10 First normal form 1NF
Chapter9 Chapter nine
9-1 Second normal form 2NF
9-2 Third normal form 3NF
9-3 denormalization
9-4 Summary of design paradigms
9-5 Table relationship learning path
9-6 one-to-one relationship
9-7 one-to-many relationship
9-8 many-to-many relationship
9-9 Table relationship summary
9-10 MySQL advanced SQL operation learning path
Chapter10 chapter Ten
10-1 New learning path for data
10-2 Batch insert
10-3 worm replication
10-4 primary key conflict
10-5 Data query learning path
10-6 Query options
10-7 Field selection and aliasing
10-8 data source
10-9 where child clause
10-10 operator
Chapter11 Chapter 11
11-1 Group statistics (group by)
11-2 Lookback statistics
11-3 Group sorting
11-4 having clause
11-5 order by child clause
11-6 limit clause
11-7 Data query summary
11-8 Update data (restrict updates)
11-9 Restrict deletion
11-10 Clear data
Chapter12 Chapter 12
12-1 MySQL multi-table operation learning path
12-2 Federated Query Learning Path
12-3 Union query
12-4 Union query sorting
12-5 Connect Query Learning Path
12-6 cross connect
12-7 inner join
12-8 outer join
12-9 natural connection
12-10 using keyword
Chapter13 Chapter 13
13-1 Join query summary
13-2 Subquery learning path
13-3 subquery classification
13-4 scalar subquery
13-5 column subquery
13-6 row subquery
13-7 Table subquery
13-8 exists subquery
13-9 comparison method
13-10 Subquery summary
Chapter14 Chapter 14
14-1 MySQL security management learning path
14-2 Foreign key constraint learning path
14-3 foreign key
14-4 foreign key constraints
14-5 Foreign key management
14-6 Transaction Security Learning Path
14-7 affairs
14-8 transaction processing
14-9 Transaction characteristics
14-10 Preprocessing learning path
Chapter15 Chapter 15
15-1 preprocessing
15-2 Preprocessing parameters
15-3 View Learning Path
15-4 view
15-5 View management
15-6 View data operations
15-7 View algorithm
15-8 Data backup and restore learning path
15-9 Table data backup
15-10 Table data restoration
Chapter16 Chapter 16
16-1 File backup
16-2 File restore
16-3 SQL backup
16-4 SQL restore
16-5 Data backup and restore summary
16-6 User management learning path
16-7 Account management
16-8 authority management
16-9 role management
16-10 PHP operation MySQL database learning path
Chapter17 Chapter 17
17-1 PHP extension
17-2 MySQLi extension
17-3 MySQLi common functions
17-4 Add new data
17-5 update data
17-6 delete data
17-7 Query data
17-8 Summary of operating MySQL database with PHP
17-9 Form value passing learning path
17-10 form value
Chapter18 Chapter 18
18-1 post value
18-2 get pass value
18-3 PHP receives form data
18-4 News Management System Learning Path
18-5 Database Design
18-6 Add news (display form)
18-7 Add new news (data into database)
18-8 encapsulation
18-9 news list
18-10 delete news
Chapter19 Chapter 19
19-1 View news
19-2 Editorial News
19-3 Pagination (top)
19-4 Pagination (below)
19-5 Project improvement and summary
Previous section
Next Section
Tutorial List
get help
Course Recommendations
Courseware download
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
Intermediate
Vue3+TypeScript practical tutorial-enterprise-level project practice
3208 people are watching
Elementary
Let's briefly talk about starting a business in PHP
17423 people are watching
Intermediate
VUE e-commerce project (front-end & back-end dual project actual combat)
3828 people are watching
Elementary
Apipost practical application [api, interface, automated testing, mock]
2265 people are watching
Master MySQL Basics Video Courseware in 6 Days
Belongs to chapter:Master the basics of MySQL in 6 days video
Download
Students who have watched this course are also learning
492122 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!