Understand and install MySQL
08 minutes20 secondsclient concept
10 minutes48 secondsThe concept of tables and libraries
06 minutes55 secondsGet to know SQL
06 minutes59 secondsinsert operation
09 minutes01 secondsupdate operation
07 minutes47 secondsdelete operation
03 minutes48 secondsSimple choice
05 minutes58 secondsUnderstand the query model
10 minutes25 secondsQuery exercises
24 minutes31 secondsQuery exercises explained
10 minutes25 secondsWeird NULL
06 minutes26 secondsgroup group statistics
20 minutes12 secondshaving filter result set
11 minutes40 secondshaving comprehensive case explanation
10 minutes43 secondsorder by order
12 minutes26 secondslimit usage
06 minutes02 secondsClause Query Trap
08 minutes39 secondswhere type subquery
06 minutes55 secondsfrom subquery
06 minutes45 secondsexists subquery
05 minutes15 secondsNovice 1+N query
05 minutes14 secondsinner join query
12 minutes24 secondsLeft and right join queries and exercises
15 minutes07 secondsConnection query interview questions
08 minutes51 secondsunion query
13 minutes50 secondsUnion query interview questions
05 minutes10 secondsTable creation process
11 minutes06 secondsinteger column
07 minutes49 secondsInteger column properties
10 minutes44 secondsFloating point columns and fixed point columns
08 minutes33 secondscharacter column
20 minutes37 secondsdatetime column
10 minutes02 secondsColumn default value
03 minutes42 secondsPrimary key and auto-increment
10 minutes13 secondsComprehensive table building case
11 minutes46 secondsColumn addition, deletion and modification
12 minutes31 secondsview view
23 minutes28 secondsviewalgorithm
15 minutes41 secondsCommonly used table management statements
14 minutes32 secondsThe concept of storage engine
12 minutes38 secondsCharacter set and garbled code issues
23 minutes27 secondsIndex concept
34 minutes01 secondsIndex operation syntax
08 minutes45 secondsCommonly used functions
12 minutes10 secondstransaction concept
18 minutes21 seconds