MySQL Cookbook: Solutions for Database Developers and Administrators, 3/e (Paperback)

Paul DuBois

買這商品的人也買了...

商品描述

MySQL’s popularity has brought a flood of questions about how to solve specific problems, and that’s where this cookbook is essential. 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 solve MySQL problems from scratch.

Ideal for beginners and professional database and web developers, this updated third edition covers powerful features in MySQL 5.6 (and some in 5.7). The book focuses on programming APIs in Python, PHP, Java, Perl, and Ruby. With more than 200+ recipes, you’ll learn how to:

  • Use the mysql client and write MySQL-based programs
  • Create, populate, and select data from tables
  • Store, retrieve, and manipulate strings
  • Work with dates and times
  • Sort query results and generate summaries
  • Use stored routines, triggers, and scheduled events
  • Import, export, validate, and reformat data
  • Perform transactions and work with statistics
  • Process web input, and generate web content from query results
  • Use MySQL-based web session management
  • Provide security and server administration

商品描述(中文翻譯)

MySQL的普及性帶來了大量關於如何解決特定問題的問題,這就是這本食譜書的重要性所在。當您需要快速解決方案或技巧時,這個方便的資源提供了數十個短小而專注的程式碼片段,數百個實例,以及清晰簡潔的解釋,適合那些沒有時間(或專業知識)從頭解決MySQL問題的程式設計師。

這本更新的第三版適合初學者和專業的資料庫和網頁開發人員,涵蓋了MySQL 5.6(以及部分5.7)中的強大功能。本書專注於Python、PHP、Java、Perl和Ruby的程式設計API。通過200多個食譜,您將學習如何:

- 使用mysql客戶端並編寫基於MySQL的程式
- 創建、填充和選擇數據表中的數據
- 存儲、檢索和操作字符串
- 處理日期和時間
- 對查詢結果進行排序並生成摘要
- 使用存儲過程、觸發器和定期事件
- 導入、導出、驗證和重新格式化數據
- 執行事務並處理統計數據
- 處理網頁輸入並從查詢結果生成網頁內容
- 使用基於MySQL的網頁會話管理
- 提供安全性和伺服器管理