MySQL Cookbook: Solutions for Database Developers and Administrators

For MySQL, 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 MySQL 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 MySQL 5.7 and 8.0. Beginners as well as professional database and web developers will dive into topics such as MySQL Shell, MySQL replication, and working with JSON.

You'll learn how to:

• Connect to a server, issue queries, and retrieve results
• Retrieve data from the MySQL 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 MySQL administration tasks
• Understand MySQL monitoring fundamentals

對於MySQL來說，其受歡迎的代價是使用者對於如何解決特定數據相關問題的大量問題。這就是這本食譜的用途所在。當您需要快速解決方案或技巧時，這個方便的資源提供了數以百計的短小、專注的程式碼片段，數百個實例，以及對於沒有時間（或專業知識）從頭解決MySQL問題的程式設計師的清晰、簡潔的解釋。

在這本更新的第四版中，作者Sveta Smirnova和Alkin Tezuysal提供了超過200個食譜，涵蓋了MySQL 5.7和8.0中的強大功能。無論是初學者還是專業的數據庫和網頁開發人員，都將深入研究MySQL Shell、MySQL複製和處理JSON等主題。

您將學習如何：
- 連接到服務器，發出查詢並檢索結果
- 從MySQL服務器檢索數據
- 存儲、檢索和操作字符串
- 處理日期和時間
- 對查詢結果進行排序並生成摘要
- 評估數據集的特性
- 編寫存儲函數和程序
- 使用存儲過程、觸發器和定期事件
- 執行基本的MySQL管理任務
- 理解MySQL監控基礎知識

Sveta Smirnova is a MySQL Support Engineer at Percona. Her main professional interests are problem-solving, working with tricky issues and bugs, and teaching others how to deal with MySQL issues, bugs and gotchas effectively. In addition to authoring MySQL Troubleshooting and JSON UDF Functions for MySQL, Sveta has spoken at many events, including Fosdem, Percona Live, and Oracle Open World.

Alkin Tezuysal has extensive experience in open source relational databases, working in various sectors for large corporations. With over 25 years of industry experience, he has acquired skills for managing large projects from the ground up to production. For the past decade, he's been focused on e-commerce, SaaS, and MySQL technologies. Alkin has managed and architected database topologies for high-volume sites. He has several years of experience in 24X7 support and operational tasks and improving database systems for major companies. He has led global operations teams on Tier 1/2/3 support for MySQL customers. He currently holds the position of EVP - Global Services at fast-growing startup ChistaDATA Inc.

Sveta Smirnova是Percona的MySQL支援工程師。她主要的專業興趣是解決問題、處理棘手的問題和錯誤，並教導他人如何有效地處理MySQL問題、錯誤和陷阱。除了撰寫《MySQL故障排除》和《MySQL的JSON UDF函數》之外，Sveta還在許多活動中發表演講，包括Fosdem、Percona Live和Oracle Open World。

Alkin Tezuysal在開源關聯式數據庫方面擁有豐富的經驗，曾在大型企業的各個部門工作。憑藉超過25年的行業經驗，他具備了從頭到尾管理大型項目並將其投入生產的能力。在過去的十年中，他專注於電子商務、SaaS和MySQL技術。Alkin曾管理和設計高流量網站的數據庫拓撲結構。他在24x7支援和運營任務以及改進主要公司的數據庫系統方面擁有數年的經驗。他曾領導全球運營團隊為MySQL客戶提供1/2/3級支援。他目前擔任快速成長初創公司ChistaDATA Inc.的EVP - 全球服務職位。