買這商品的人也買了...
-
$880$695 -
$880$695 -
$1,880$1,786 -
$1,730$1,644 -
$550$468 -
$980$774 -
$1,200$948 -
$620$490 -
$680$537 -
$880$695 -
$990$891 -
$580$452 -
$299$236 -
$600$480 -
$1,200$1,020 -
$980$774 -
$620$490 -
$380$300 -
$750$593 -
$1,880$1,786 -
$820$648 -
$3,240$3,078 -
$825R Cookbook (Paperback)
-
$680$537 -
$680$530
相關主題
商品描述
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 的普及,出現了大量關於解決特定問題的問題,而這本食譜書正是必不可少的資源。這本書設計為一個方便的資源,當你需要快速解決方案或技術時,可以提供數十個簡短、專注的程式碼片段和數百個針對各種程度程式設計師的範例,特別是那些沒有時間(或專業知識)從頭解決 MySQL 問題的人。
新版本涵蓋了 MySQL 5.0 及其強大的新功能,以及仍然廣泛使用的舊版 MySQL 4.1。本書的一個主要重點是如何使用 SQL 來針對特定類型的問題制定查詢,使用 MySQL 發行版中包含的 mysql 客戶端程式。另一個主要重點是如何通過 API 編寫與 MySQL 伺服器互動的程式。你會發現許多使用多種語言 API 的範例,涵蓋多種情境,包括使用 Ruby 來檢索和格式化數據。書中還有許多使用 Perl、PHP、Python 和 Java 的新範例。
書中的其他食譜教你:
- 同時訪問多個表中的數據
- 使用 SQL 選擇、排序和彙總行
- 找出兩個表中行之間的匹配或不匹配
- 確定日期或時間之間的間隔,包括年齡計算
- 將圖像存儲到 MySQL 並檢索以在網頁中顯示
- 使用 LOAD DATA 正確讀取數據文件或找出文件中無效的值
- 使用嚴格模式防止不良數據進入數據庫
- 將表或數據庫複製到另一台伺服器
- 生成序列號作為唯一行標識符
- 創建根據計劃執行的數據庫事件
- 還有更多
《MySQL Cookbook》並不試圖開發完整的複雜應用程式。相反,它旨在幫助你自己開發應用程式,幫助你克服那些讓你感到困惑的問題。