MySQL Cookbook, 2/e (Paperback)

Along with MySQL's popularity has come a flood of questions about solving specific problems, and that's where this Cookbook is essential. Designed as a handy resource when you need quick solutions or techniques, the book offers dozens of short, focused pieces of code and hundreds of worked-out examples for programmers of all levels who don't have the time (or expertise) to solve MySQL problems from scratch.

The new edition covers MySQL 5.0 and its powerful new features, as well as the older but still widespread MySQL 4.1. One major emphasis of this book is how to use SQL to formulate queries for particular kinds of questions, using the mysql client program included in MySQL distributions. The other major emphasis is how to write programs that interact with the MySQL server through an API. You'll find plenty of examples using several language APIs in multiple scenarios and situations, including the use of Ruby to retrieve and format data. There are also many new examples for using Perl, PHP, Python, and Java as well.

Other recipes in the book teach you to:

• Access data from multiple tables at the same time
• Use SQL to select, sort, and summarize rows
• Find matches or mismatches between rows in two tables
• Determine intervals between dates or times, including age calculations
• Store images into MySQL and retrieve them for display in web pages
• Get LOAD DATA to read your data files properly or find which values in the file are invalid
• Use strict mode to prevent entry of bad data into your database
• Copy a table or a database to another server
• Generate sequence numbers to use as unique row identifiers
• Create database events that execute according to a schedule
• And a lot more

MySQL Cookbook doesn't attempt to develop full-fledged, complex applications. Instead, it's intended to assist you in developing applications yourself by helping you get past problems that have you stumped.

MySQL Cookbook 是一本針對 MySQL 的問題解決提供快速解決方案和技巧的實用資源。這本書包含了數十個短小而專注的程式碼片段和數百個實例，適合各種程式設計師使用，無論是初學者還是有經驗的開發者，都能在短時間內解決 MySQL 的問題，而不需要從頭開始。

這本新版書籍涵蓋了 MySQL 5.0 的新功能，以及較舊但仍廣泛使用的 MySQL 4.1。書中主要強調如何使用 SQL 撰寫特定類型的查詢，並使用 MySQL 發行版中包含的 mysql 客戶端程式。另一個主要重點是如何通過 API 撰寫與 MySQL 伺服器互動的程式。書中提供了多種語言 API 的示例，並涵蓋了多種情境和場景，包括使用 Ruby 檢索和格式化資料的示例。同時還有許多新的示例，使用 Perl、PHP、Python 和 Java 等語言。

書中的其他篇章教導讀者：
- 同時從多個表中存取資料
- 使用 SQL 選擇、排序和總結資料列
- 在兩個表中查找匹配或不匹配的資料列
- 計算日期或時間之間的間隔，包括年齡計算
- 將圖像存儲到 MySQL 中，並在網頁中檢索和顯示
- 使用 LOAD DATA 正確讀取資料檔案，或找到檔案中無效的值
- 使用嚴格模式防止錯誤資料進入資料庫
- 將表格或資料庫複製到另一個伺服器
- 生成序列號作為唯一的資料列識別符
- 創建按照時間表執行的資料庫事件
- 還有更多內容

MySQL Cookbook 不試圖開發完整而複雜的應用程式，而是旨在通過幫助讀者解決困擾的問題，協助他們自行開發應用程式。