Amazon Kindleでは、
MySQL Cookbook
をはじめとする140万冊以上の本をご利用いただけます。 詳細はこちら
 | 会員なら、この商品は10%Amazonポイント還元 （ポイントが表示されている場合は、表示ポイント＋10％還元）。 |
商品の説明
内容紹介
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.
内容（「BOOK」データベースより）
本書は、世界で最も人気が高いオープンソースのデータベースシステム「MySQL」の解説書です(全2巻)。MySQLの特長である「処理の高速性」は、Webサイトのバックエンドとして使用することで、最大の効果を発揮します。VOLUME2では「Web環境でMySQLを使用するためのPerl、PHP、Python、およびJSP(JavaServer Pages)のスクリプトを記述する方法」「クエリ結果から様々なHTMLを出力する方法」「Webからのユーザの入力を処理する方法」「MySQLを使ってWebセッション管理を行う方法」を解説します。他に「トランザクションの実行」「シーケンスの生成と使用」「複数テーブルの使用」「統計手法」「重複の処理」なども解説。MySQLを知り尽くした著者が持てる知識を惜しみなくつぎ込んだ本書は、すべてのMySQLユーザ必携の書。
--このテキストは、絶版本またはこのタイトルには設定されていない版型に関連付けられています。
登録情報
|
この商品を見た後に買っているのは？
カスタマーレビュー
最も参考になったカスタマーレビュー
8 人中、8人の方が、｢このレビューが参考になった｣と投票しています。
By tsingtao
形式:単行本
Vol.1 は基本的な運用方法を紹介しているとしたら、Vol.2 はMySQLに負荷がかかる運用を行う手法を紹介している。
目次内容からわかるように、会計処理や予約処理よりもWEBアプリケーションの基礎的な運用と処理方法を中心に書かれている。
不特定多数の利用者からのクエリーをいかに無害化させるか、格納されたデータの重複データを探し出す方法、ApacheとPerlとの連携方法、セッション管理なども記述されている。
また、Javaサーブレットとの運用なども記述されているので、興味がある人は一度書店で実物を確認してみると良いはず。
MySQLのマニュアルが無料公開されているので、そちらを読めば済むような話しも多いが、公開されているマニュアルは読みにくいなと思う人は一度、本書の内容を確認してみても損はしないはず。
Amazon.com で最も参考になったカスタマーレビュー (beta)
Amazon.com:
5つ星のうち 4.7
29件のカスタマーレビュー
36 人中、35人の方が、｢このレビューが参考になった｣と投票しています。
5つ星のうち 5.0
The only MySQL book needed for programming my web sites
2004/12/10
By David L. Hickman
- (Amazon.com)
形式:ペーパーバック
I built several web sites using PHP/MySQL and the only two books I use day-to-day are "MySQL Cookbook" and "PHP Cookbook".
If you're already somewhat familiar with MySQL, this book is a great reference for the SQL and database manipulation you already know how to do. In addition, the examples push the envelope of what is possible with MySQL making it a good learning tool for becoming truly expert.
Some of the information in the book I found useful includes:
- simplifying complex SQL using temporary tables.
- using FULLTEXT searches (similar to pattern matching but more efficient and easier to code when you're looking for the same text in several columns at the same time).
- effective use of LEFT JOIN's for finding rows in one table that don't have a match in another table.
- effective use of LAST_INSERT_ID( fieldName + 1 ) for transactionally updating a numeric field without using transactions and without locking a table.
- numbering output rows using SQL variables (select @rownum := @rownum + 1; (see chapter 13.9))
I really can't say enough good things about this book. It's comprehensive, easy to read and just plain awesome.
If you're already somewhat familiar with MySQL, this book is a great reference for the SQL and database manipulation you already know how to do. In addition, the examples push the envelope of what is possible with MySQL making it a good learning tool for becoming truly expert.
Some of the information in the book I found useful includes:
- simplifying complex SQL using temporary tables.
- using FULLTEXT searches (similar to pattern matching but more efficient and easier to code when you're looking for the same text in several columns at the same time).
- effective use of LEFT JOIN's for finding rows in one table that don't have a match in another table.
- effective use of LAST_INSERT_ID( fieldName + 1 ) for transactionally updating a numeric field without using transactions and without locking a table.
- numbering output rows using SQL variables (select @rownum := @rownum + 1; (see chapter 13.9))
I really can't say enough good things about this book. It's comprehensive, easy to read and just plain awesome.
18 人中、17人の方が、｢このレビューが参考になった｣と投票しています。
5つ星のうち 4.0
A Hand-on guide to MySQL
2003/5/21
By カスタマー
- (Amazon.com)
形式:ペーパーバック
There are many databases out there. MySQL is one of the better ones. It's a free (for personal use) database system which can be easily integrated into a web application on virtually any system. It has supports most of the standard feature found in most database system and has quiet a few features unique to MySQL. This particular book is a good reference for the experienced user as well as for new comers and as an added bonus even covers MySQL 4.0.
This is book was my first introduction to O'Reilly's cookbook series. It provides solutions to some of the most common challenged faced by the particular subject being covered (in this case MySQL). I thoroughly enjoyed it and was quiet impressed with it. Too many technical books simply introduce the concept without relating it to real world applications.
This particular book introduces all of the most basic concepts of database manipulation (table creation, data insertion, data deletion, data update). As well as writing simple and advanced SQL statements to retrieve data. It approaches database design using 4 of the most popular languages (Perl, PHP, Python and Java). These are only a few of the many possible languages which can be used to manipulate a MySQL database.
MySQL cookbook touches on a variety of different topics which I don't have the space or time to cover in detail, but here is a list of them:
* Handeling duplicates
* MySQL on the Web
* Processing Web input with MySQL
* Using MySQL-based Web Session Management
One of my favorite topics covered in the book is the idea of storing binary data such as images within a database. Although not ideal for most cases (unless you need fast access to a vast array of images), just the idea of it has a certain kewlness effect.
Well, overall I give it 4 out of 5 stars. It needs to touch slightly more on the basic concepts of databases, and it can become the only book you'll ever need for MySQL.
14 人中、13人の方が、｢このレビューが参考になった｣と投票しています。
5つ星のうち 5.0
a nice addition to O'Reilly's Cookbook series
2003/4/14
By "dsimpson1"
- (Amazon.com)
形式:ペーパーバック
As an experienced Oracle DBA I had a need to learn about MySQL for the development of the FmPro Migrator utility to migrate FileMaker databases to MySQL. This book enabled me to quickly learn how to perform tasks in MySQL which are equivalent to what I would perform with Oracle. Congratulations to O'Reilly and Paul DuBois for continuing the fine tradition of Cookbook series books.
›
Amazon.comのカスタマーレビューを見る(29)
5つ星のうち 4.7
これらのレビューは参考になりましたか？
ご意見はクチコミでお聞かせください。
リストマニア
|
|
関連商品を探す
- 洋書 > Computers & Internet > Databases
- 洋書 > Computers & Internet > Programming > Languages & Tools
- 洋書 > Computers & Internet > Software
- 洋書 > Computers & Internet > Web Development > Programming
- 洋書 > O'Reilly > Programming > General
- 洋書 > O'Reilly > Programming > Oracle & Database Programming
- 洋書 > O'Reilly > Programming > Perl
- 洋書 > Special Features > all foreign books
フィードバック
- カタログ情報、または画像について報告
- 著者からのコメント
- 出版社からのコメント
|
