MySQL database collection

Chapter 1: Introduction to MySQL Database, Download and Install

1.1 Database Introduction

1.2 MySQL server download

1.3 MySQL Installation

1.4 Client Installation

1.5 Database connection

1.6 Basic use of sqlyog

1.7 ECshop Database Introduction and Creation

1.8 sqlyog Data Operation

Chapter 2: Basic MySQL Query Statements

2.1 Basic syntax specification of SQL

2.2 Select clause

2.3 Orderby

2.4 Where comparison operation

2.5 Where range and set operation

2.6 Where string judgment

2.7 Where logic operation

2.8 Where Null Value Judgment

2.9 Where conditional statement judgment rules

Chapter 3: MySQL Grouping Statistics

3.1 Statistical function

3.2 Grouping

3.3 Statistics after grouping

3.4 Filtering after statistics

Chapter 4: MySQL Multi table Connection

4.1 Connection and cross connection

4.2 Equivalent connection of internal connection

4.3 Inter connected multi meter connection

4.4 Practical application of internal connection

4.5 External connection

4.6 Application of external connection

Chapter 5: MySQL sub query statements

5.1 Sub query statement

5.2 Sub query after select

5.3 Sub query after from

5.4 Sub query in where comparison statement

5.5 Subquery in where member judgment statement

5.6 Subqueries in the exists statement of where

Chapter 6: MySQL DDL and DML Statements

6.1 DML insertion statement

6.2 DML Update and Delete Statements

6.3 DDL Database Operation

6.4 DDL Database Table Operation

Chapter 7: MySQL Stored Procedures

7.1 mysq | Preface to the stored procedure

7.2mysq | Stored procedure creation

7.3 mysq | Definition and use of stored procedure variables

7.4 mysq | Settings of stored procedure parameters

7.5 mysq | Stored procedure loop statement

7.6 mysq | Stored procedure conditional statements

7.7 mysq | Stored procedure flow control statement

7.8 mysq | Stored procedure user-defined function

7.9mysq | Stored procedure trigger

seven point one zero Mysq | Stored procedure event

Chapter 8: Advanced Course of MySQL Database

eight point one Use of common statistical functions

8.2 Use of common string functions, numeric functions and date time functions

8.3 MySQL database view, index concept and purpose

8.4 MySQL Database Stored Procedure Creation and Variable Usage

8.5 Stored Procedure Parameter Settings and the Use of Circular Statements

8.6 Use of conditional statements and process control statements

8.7 Use of user-defined functions, triggers and events