MySQL Cookbook: Solutions for Database Developers and Administrators
暫譯: MySQL 食譜：資料庫開發者與管理員的解決方案
Smirnova, Sveta, Tezuysal, Alkin
買這商品的人也買了...
相關主題
商品描述
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 Server 中檢索數據
- 儲存、檢索和操作字串
- 處理日期和時間
- 對查詢結果進行排序並生成摘要
- 評估數據集的特徵
- 編寫儲存函數和程序
- 使用儲存例程、觸發器和排程事件
- 執行基本的 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 客戶提供 Tier 1/2/3 支援。他目前擔任快速成長的初創公司 ChistaDATA Inc. 的全球服務執行副總裁 (EVP)。
