MySQL Cookbook: Recipes for Developers
summary
Fourth edition cookbook documents concrete fixes and runnable recipes: using MySQL Shell X DevAPI for document-store CRUD and async calls, replacing kludgy temp-table tricks with recursive CTEs and window functions for sequences, gaps and ranking, and validating JSON with built‑in schemata. MySQL 8 adds histograms, rewritten spatial indexes, full‑text tweaks and JSON in‑place updates so partial document edits avoid full rewrites. Examples include longest‑trip queries, explain plans showing index use, and notes where optimizer still requires testing.
AI-written summary · about
chapters (16)
- 0:00Start
- 1:09Sveta the Speaker
- 1:47MySQL Cookbook by O'Reilly
- 2:1915 years ago
- 3:40MySQL CLI
- 4:23MySQL Shell
- 5:56Reading
- 6:32Working with Results
- 7:15Changing Data
- 7:29Character Encoding
- 8:25Generating Summaries
- 10:52Validation and Formatting
- 12:43Sequences
- 14:23Joins and Subqueries
- 15:30Statistics
- 17:10Duplicates
