Introduction and use of MySQL

PHP operation MySQL

User data query

Adding user data and preventing SQL injection attacks

Modify user data

Delete user data

Introduction to MySQL

Install MySQL on a Mac computer

Install MySQL on a Windows computer

Install MySQL on a Linux computer

Create, use and delete MySQL database

MySQL database table operations

Obtain information about databases and tables and an introduction to database physical files

MySQL numeric types

MySQL character type

MySQL date and time types

MySQL connects to the database through shell

MySQL Connect to the database through MySQL Workbench

MySQL Connect to the database through Navicat for MySQL

MySQL arithmetic operators

MySQL comparison operators

MySQL logical operators and bitwise operators

MySQL basic insert data

MySQL advanced insert data

MySQL update data and delete data

MySQL math functions and aggregate functions

MySQL string functions

MySQL date and time functions

MySQL data encryption function

MySQL control flow functions

MySQL formatting functions and type conversion functions

MySQL connection concepts and types

MySQL cross join, inner join and outer join

MySQL self joins and unions

The concept of MySQL subquery

Common ways to use MySQL subqueries (1)

Common ways to use MySQL subqueries (2)

Basic concepts of MySQL transaction processing

MySQL transaction life cycle

Autocommit for MySQL transactions

The concept of MySQL transaction isolation level and serialization isolation

MySQL transaction isolation levels repeatable read, committed read and uncommitted read

MySQL performance and table locking for non-transactional tables

Basic tasks of MySQL database management

MySQL authorization table

MySQL permission control

PDO object knowledge

PDO object initialization

PDO object application

Course Introduction

PDO exception handling

PDO preprocessing

PDO transaction processing

System introduction and construction

Add and view system functions

System function deletion and modification