六天带你玩转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