Understand triggers
06 minutes23 secondsWrite the first trigger by hand
15 minutes41 secondsRow variable referenced in trigger
14 minutes14 secondsLet’s talk about row variables again
09 minutes57 secondsSimple programming of triggers
22 minutes11 secondsWhat does for each row do?
12 minutes53 secondsStored procedure concept
09 minutes10 secondsIntroducing variables and control structures
13 minutes10 secondsParameter passing of stored procedures
06 minutes47 secondsUse loop structures in procedures
12 minutes00 secondsWhat are output parameters?
15 minutes39 secondsUsage of Case structure
07 minutes00 secondsrepeat loop structure
06 minutes32 secondsCursor concept
16 minutes08 secondscursor loop
06 minutes05 secondsdeclare processing conditions
07 minutes09 secondsCompare the difference between continue and exit
16 minutes30 secondsCorrect logic for cursor loop reading
11 minutes16 secondsMySQL permission check principle
15 minutes28 secondsGlobal authorization and withdrawal
14 minutes43 secondsDatabase and table level authorization and withdrawal
14 minutes41 secondsMaster-slave replication principle
08 minutes32 secondsMaster-slave configuration process
14 minutes06 secondsStart master-slave
20 minutes40 seconds