Overview

DBMS, SQL, DB relationships

MYSQL installation

data sheet

SQL statement classification

data preparation

Table description

Common commands

Demo data structure

Simple query

Conditional query

sort

Data processing functions

Review the content of the morning

Date processing_str_to_date

Date processing_date_format

grouping function

distinct

Group query

Connection query (1)

Connection query (2)

Connection query (3)

Connection query (4)

Connection query (5)

Connection query (6)

Connection query (7)

Subquery (1)

Subquery (2)

Subquery (3)

union

limit

Table I)

Table II)

Table (3)

Table (4)

Table (5)

Table (6)

Table (7)

Constraints (1)

Constraints (2)

Constraints (3)

Constraints (4)

Constraints (5)

Constraints (6)

Constraints (7)

Cascading updates and deletes

Exercise (1)

Exercise (2)

Exercise (3)

Exercise (4)

Exercise (5)

Exercise (6)

Exercise (7)

Exercise (8)

CaseWhenThenElseEnd

Exercise 1

Exercise 2

Exercise 3

Exercise 4

Exercise 5

Exercise 6

Exercise 7

Exercise 8

Exercise 9

Exercise 10

Exercise 11

Exercise 12

Exercise 13

Exercise 14

Exercise 15

Exercise 16

Exercise 17

Exercise 18

Exercise 19

Exercise 20

Exercise 21

storage engine

Transaction 1

Transaction 2

Transaction 3

Transaction 4

Transaction 5

index

view

DBA command

Database design three paradigms