Section1 Understand and install MySQL

08 minutes20 seconds

Section2 client concept

10 minutes48 seconds

Section3 The concept of tables and libraries

06 minutes55 seconds

Section4 Get to know SQL

06 minutes59 seconds

Section5 insert operation

09 minutes01 seconds

Section6 update operation

07 minutes47 seconds

Section7 delete operation

03 minutes48 seconds

Section8 Simple choice

05 minutes58 seconds

Section9 Understand the query model

10 minutes25 seconds

Section10 Query exercises

24 minutes31 seconds

Section11 Query exercises explained

10 minutes25 seconds

Section12 Weird NULL

06 minutes26 seconds

Section13 group group statistics

20 minutes12 seconds

Section14 having filter result set

11 minutes40 seconds

Section15 having comprehensive case explanation

10 minutes43 seconds

Section16 order by order

12 minutes26 seconds

Section17 limit usage

06 minutes02 seconds

Section18 Clause Query Trap

08 minutes39 seconds

Section19 where type subquery

06 minutes55 seconds

Section20 from subquery

06 minutes45 seconds

Section21 exists subquery

05 minutes15 seconds

Section22 Novice 1+N query

05 minutes14 seconds

Section23 inner join query

12 minutes24 seconds

Section24 Left and right join queries and exercises

15 minutes07 seconds

Section25 Connection query interview questions

08 minutes51 seconds

Section26 union query

13 minutes50 seconds

Section27 Union query interview questions

05 minutes10 seconds

Section28 Table creation process

11 minutes06 seconds

Section29 integer column

07 minutes49 seconds

Section30 Integer column properties

10 minutes44 seconds

Section31 Floating point columns and fixed point columns

08 minutes33 seconds

Section32 character column

20 minutes37 seconds

Section33 datetime column

10 minutes02 seconds

Section34 Column default value

03 minutes42 seconds

Section35 Primary key and auto-increment

10 minutes13 seconds

Section36 Comprehensive table building case

11 minutes46 seconds

Section37 Column addition, deletion and modification

12 minutes31 seconds

Section38 view view

23 minutes28 seconds

Section39 viewalgorithm

15 minutes41 seconds

Section40 Commonly used table management statements

14 minutes32 seconds

Section41 The concept of storage engine

12 minutes38 seconds

Section42 Character set and garbled code issues

23 minutes27 seconds

Section43 Index concept

34 minutes01 seconds

Section44 Index operation syntax

08 minutes45 seconds

Section45 Commonly used functions

12 minutes10 seconds

Section46 transaction concept

18 minutes21 seconds