MySQL Advanced Advanced Video Tutorial

• Chapter1 MySQ Advanced Advanced Video Tutorial
• 1-1 mysql encoding settings 1
• 1-2 mysql encoding setting 2
• 1-3 Session variables and global variables
• 1-4 Stored procedure 1
• 1-5 Stored procedure 2 (definition of variables)
• 1-6 Stored procedure 3 (parameter type)
• 1-7 Flow control statement selection statement 1
• 1-8 Process control (select statement case branch)
• 1-9 Process control (while loop statement)
• 1-10 Process control (loop repeat and loop statements)
• 1-11 Define conditions and processing [vxia.net]
• 1-12 Stored procedure management
• 1-13 Creation of functions
• 1-14 View creation 1
• 1-15 View management
• 1-16 Application of trigger 1
• 1-17 Trigger application 2
• 1-18 My ISAM table lock (shared read lock)
• 1-19 My ISAM table lock (exclusive write lock)
• 1-20 MyISAM table lock (concurrent insert)
• 1-21 Application of business 1
• 1-22 Application of business 2.
• 1-23 Slow query 1 (see slow query)
• 1-24 Slow query 2 (slow query configuration)
• 1-25 Index 1 (category of index)
• 1-26 Index 2 (full text index)
• 1-27 Optimize SQL with indexes
• 1-28 Table optimization
• 1-29 Partition 1 of the table (Range partition)
• 1-30 Partition 2 of the table (List partition, Hash, Keys partition)
• 1-31 Mysql memory optimization
• 1-32 mysql application optimization
• 1-33 mysql account permission grant
• 1-34 mysql account permission management
• 1-35 mysql monitoring
• 1-36 mysql scheduled maintenance [vxia.net]
• 1-37 mysql backup and restore
• 1-38 mysql advanced project