Sveta Smirnova & Alkin Tezuysal 
MySQL Cookbook [PDF ebook] 

For My SQL, the price of popularity comes with a flood of questions from users on how to solve specific data-related issues. That’s where this cookbook comes in. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out examples, and clear, concise explanations for programmers who don’t have the time (or expertise) to resolve My SQL problems from scratch.In this updated fourth edition, authors Sveta Smirnova and Alkin Tezuysal provide more than 200 recipes that cover powerful features in both My SQL 5.7 and 8.0. Beginners as well as professional database and web developers will dive into topics such as My SQL Shell, My SQL replication, and working with JSON.You’ll learn how to:Connect to a server, issue queries, and retrieve results Retrieve data from the My SQL Server Store, retrieve, and manipulate strings Work with dates and times Sort query results and generate summaries Assess the characteristics of a dataset Write stored functions and procedures Use stored routines, triggers, and scheduled events Perform basic My SQL administration tasks Understand My SQL monitoring fundamentals