Making the most out of MySQL
summary
MySQL 5.7 adds concrete behaviors: DDL changes use either in-place vs copy alter algorithms so some ALTERs are instant metadata flips while others copy the whole table; SQL mode only_full_group_by forces explicit aggregators instead of ambiguous SELECT GROUP BY results; the JSON type stores binary and must be indexed via generated columns*; virtual generated columns calculate on read (no disk) while stored ones persist and can fail on writes (division by zero); demo on a laps table creates a virtual time and a stored speed and shows indexed JSON lookup avoids full table scans.
AI-written summary · about
chapters (12)
- 0:00Start
- 1:42Ddr Changes
- 2:11In-Place Algorithm
- 3:40Table Copy Operation
- 7:10Dates
- 16:40Demo
- 20:02Generator Columns
- 20:35Types of Generated Columns
- 23:54How To Create a Virtual Column
- 28:32Drop a Column
- 32:49Create a Generated Column
- 35:58Other Features and Deprecations
