MySQL Cookbook: Recipes for Your Business
summary
Announces a fourth edition with concrete recipes: shows X DevAPI and MySQL Shell code for SQL, table and document APIs, JSON schema validation, generated columns for JSON indexes, CTEs and window functions for ranking and sequences, and import/export tools including MySQL Pump and MySQL Shell parallel utilities. Demonstrations run but reveal limits—X DevAPI forces utf8mb4 and has sparse metadata—and the examples include working scripts, performance claims about parallel dumps, and a bug report for Cyrillic handling.
AI-written summary · about
chapters (19)
- 0:00Intro
- 2:1015 years ago
- 3:27MySQL CLI
- 4:22MySQL Shell
- 6:21Reading
- 8:08Working with Results
- 9:05Changing Data
- 11:08Character Encoding
- 12:25Generating Summaries
- 16:07Storing Errors with Diagnostic Area
- 18:42Export and Import
- 24:45Metadata
- 27:36Validation and Formatting
- 31:24Sequences
- 34:36Joins and Subqueries
- 36:24Statistics
- 38:51Duplicates
- 40:19JSON
- 44:08Transactions
