Database course introduction
Database - Basics
Relational Database
Relational database keyword description
Database - SQL
mysql database
mysql server data object
Basic SQL operations - adding a new database
Basic SQL operations - View database
Basic SQL operations - update database
Basic SQL operations - delete database
Basic SQL operations - adding a new data table
Basic SQL operations - View data table
Basic SQL operations - update data table
Basic SQL operations - delete data table
Basic SQL operations - adding new data
SQL Basic Operations - View Data
Basic SQL operations - update data
Basic SQL operations - delete data
Chinese data problem
Proofreading set problem
Garbled code problem
Review of the first day of playing with mysql
Homework - Site Statistics
Column type - integer
Column type - float
Column type - fixed point
Column type - time date type
Column type - fixed length + variable length string
Column type - text string
Column type - enum
Column type - collection
column type - mysql record length
Column properties - empty properties
Column Properties - Column Description
Column properties - default values
Review of the second day of playing with mysql
Column Properties - Add Primary Key
Column Properties - Primary Key Constraints
Column Properties - Primary Key Delete
Column Properties - Primary Key Classification
Column properties - new auto-increment
Column Properties - Autoincrement Use
Column Properties - Modify AutoGrown
Column properties - delete autoincrement
Column Properties - Add Unique Key
Column Properties - Unique Key Constraints
Column Properties - Remove Unique Key
A brief introduction to indexing
Relationship - one to one
Relationship - one to many
Relationship - many-to-many
Paradigm - Basics
Normal Form - 1NF
Normal Form - 2NF
Normal Form - 3NF
Normalization - Denormalization
Advanced Data New - Primary Key Conflict
Advanced Data New - Worm Replication
Advanced Data Update - Limit Records
Advanced Data Removal - Delete Data
Advanced data query - select option
Advanced data query - field alias
Advanced data query - data source
Advanced data query - where clause
Advanced data query - groupby clause
Advanced data query - having clause
Advanced data query - order by clause
Advanced data query - limit clause
Review of the third day of playing with mysql
Join Query - Understand
Join Query - Cross Join
Join Query - Inner Join
Join Query - Outer Join
Join Query - Natural Join
PHP operation mysql - preparation
PHP operation mysql - basic operations
PHP operation mysql - write operation
PHP operation mysql - read operation
Comprehensive application - login function
Comprehensive application - home page display
Comprehensive application - paging function
Review of the fourth day of playing with mysql
Foreign Key - New
Foreign Key - Delete
Foreign Key - Default Constraint
Foreign Key - Condition
Foreign Key - Constraint Mode
Union query - basic syntax
Union query - meaning
Union query - order by
Subquery - Classification
Subquery - scalar subquery
Subquery - column subquery
Subquery - row subquery
Subquery - table subquery
Subquery - exists subquery
View - Create
View - view
View - use
View - Modify
View - Delete
view - meaning
View - Add new data operation
View - delete data operation
View - update data operation
View - Algorithm
Data backup and restore - data table backup (storage engine)
Data backup and restore - single table data backup
Data Backup and Restore - SQL Backup
Data Backup and Restore - Incremental Backup
Review of the fifth day of playing with mysql
Transaction - Manual Action
Transactions - Principles
Transaction - rollback point
Transactions - Automatic Transactions
Transaction - Properties
Variables - System variables
Variables - custom variables
Triggers - a basic understanding
Trigger - Create
trigger - view
trigger - use
Trigger - Delete
Trigger - Record
Code execution structure - if branch
Code execution structure - while loop
function - system function
function - define function
Functions - view functions
Function - Delete
function - parameters
function - scope
Stored Procedure - Create
Stored Procedure - View
Stored Procedure - Call
Stored Procedure - Delete
Stored Procedure - Parameter Type