MySQL 8.0: Not Only Good, it's GREAT
summary
MySQL 8.0 shows concrete, usable changes: use UUID defaults stored as binary and expression defaults for things like expiration dates; create and toggle invisible indexes to debug planner behavior without rebuilding; descending indexes actually work; roles replace giant grant strings; UTF8MB4 and collations change comparisons; window functions plus CTEs and lateral joins enable per-user top-N and running totals; instant ADD COLUMN and a new data dictionary make metadata changes fast — demoed on large tables (50M rows: index build ~2m on beefy hardware, instant add ~0.26s).
AI-written summary · about
chapters (8)
- 0:00Start
- 4:21Built-In Functions
- 12:08Read-Only User
- 27:04Appending a Column to a Table
- 28:06Data Dictionary
- 31:11Window Functions
- 51:53Sub Query
- 53:37The Use Cases I Want the Biggest Order of the User on a Joint You Would Have no Control over that You Could Use a Group by To Get the Maximum Order You'Re Right but Then I Couldn't Get the Same Id on the Same Row because When You Use an Aggregator the Only Guarantee Is that Column It Doesn't Guarantee the Column That's Next to It You Would Have To Do Twice so that's One Example That's the Same Query and What I Want To Show You It's How They Behave So this I'M GonNa Pin this Result because I Want To Compare to the One Using Tomorrow Which It Is this One It's Not the Same Result and There's a Reason Why When You Do the Sub-Query
