Vous voulez voir cette page en fran�ais ? Cliquez ici.

Quantity:

More Buying Choices

15 used & new from CDN$ 24.77

Have one to sell? Sell yours here

Share your own customer images

Search inside another edition of this book

MySQL Cookbook (Paperback)

by Paul DuBois (Author)

4.8 out of 5 stars See all reviews (8 customer reviews)

List Price:	CDN$ 77.95
Price:	CDN$ 49.11 & this item ships for FREE with Super Saver Shipping. Details
You Save:	CDN$ 28.84 (37%)
	o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o

Usually ships within 4 to 6 weeks.
Ships from and sold by Amazon.ca. Gift-wrap available.

Ordering for Christmas?? This item requires additional time to ship and will arrive after December 25. Need a last-minute gift? Send an Amazon.ca Gift Certificate.

6 new from CDN$ 48.11 9 used from CDN$ 24.77

Frequently Bought Together

Total List Price: CDN$ 190.93
Price For All Three: CDN$ 118.48

Some of these items ship sooner than the others. Show details

This item: MySQL Cookbook by Paul DuBois
Usually ships within 4 to 6 weeks.
Ships from and sold by Amazon.ca.
This item ships for FREE with Super Saver Shipping. Details
High Performance MySQL: Optimization, Backups, Replication, and More by Arjen Lentz
In Stock.
Ships from and sold by Amazon.ca.
Eligible for FREE Super Saver Shipping on orders over CDN$ 39. Details
MySQL Stored Procedure Programming by Guy Harrison
In Stock.
Ships from and sold by Amazon.ca.
This item ships for FREE with Super Saver Shipping. Details

Customers Who Bought This Item Also Bought

PHP Cookbook

by David Sklar

4.4 out of 5 stars (14) CDN$ 37.16

High Performance MySQL: Optimization, Backups, Replication, and More

by Arjen Lentz

CDN$ 29.69

MySQL Stored Procedure Programming

by Guy Harrison

CDN$ 39.68

MYSQL in a Nutshell

by Russell J T Dyer

CDN$ 22.04

High Performance MySQL: Optimization, Backups, Replication, Load Balancing & More

by Jeremy D Zawodny

4.8 out of 5 stars (9) CDN$ 36.51

› Explore similar items

Product Details

Paperback: 1022 pages
Publisher: O'Reilly Media; 1 edition (Oct 28 2002)
Language: English
ISBN-10: 0596001452
ISBN-13: 978-0596001452
Product Dimensions: 23.7 x 17.7 x 4 cm
Shipping Weight: 1.3 Kg

Average Customer Review: 4.8 out of 5 stars See all reviews (8 customer reviews)

Amazon.ca Sales Rank: #313,082 in Books (See Bestsellers in Books)
Popular in this category:
#10 in Books > Computers & Internet > Apple > Databases

Would you like to update product info or give feedback on images?

See Complete Table of Contents

Product Description

From Amazon.com

Good programming--which is to say, programming that yields both efficient code and a profitable life for the programmer--depends on not reinventing the wheel. If someone else has solved the problem you're facing (and someone almost always has), you'd be foolish to waste your energy figuring out your own solution. MySQL Cookbook presents solutions to scores of problems related to the MySQL database server. Readers stand a good chance of finding a ready-made solution to problems such as querying databases, validating and formatting data, importing and exporting values, and using advanced features like session tracking and transactions. Paul DuBois has done a great job assembling efficient solutions to common database programming problems, and teaches his readers a lot about MySQL and its attendant APIs in the process.

DuBois organizes his cookbook's recipes into sections on the problem, the solution stated simply, and the solution implemented in code and discussed. The implementation and discussion sections are the most valuable, as they contain the command sequences, code listings, and design explanations that can be transferred to outside projects. The main gripe readers will have about MySQL Cookbook is that the author, in his effort to cover the range of MySQL-friendly programming languages, uses different languages in his solutions to various problems. You'll see a Perl solution to one programming challenge (Perl, in fact, is the most frequently used language, followed by PHP), a Python fix for the next, and a Java sample after that. Readers have to hope that they find a solution in the language they're working with, or that they're able to transliterate the one DuBois has provided. It's usually not a big problem. --David Wall

Topics covered: How to make MySQL databases do your bidding--in terms of queries, table manipulation, data formatting, transactions, and Web interfaces--through the database server's command line interfaces and (more importantly) through the MySQL APIs of Perl, PHP, Java, and Python. Particularly excellent coverage deals with formatting dates and times, management of null values, string manipulation, and import/export techniques.

Review

"...MySQL Cookbook tells you exactly how to solve literally hundreds of problems that you are likely to encounter in getting a MySQL database solution up and running." - Computer Trade Shopper, November 2003

See all Product Description

Inside This Book (Learn More)
Browse and search another edition of this book.

Tag this product

(What's this?)

Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items.

What do customers ultimately buy after viewing this item?

	43% buy the item featured on this page: MySQL Cookbook 4.8 out of 5 stars (8) CDN$ 49.11
	20% buy High Performance MySQL: Optimization, Backups, Replication, and More CDN$ 29.69
	19% buy MySQL 4.7 out of 5 stars (101) CDN$ 34.64
	10% buy PHP and MySQL Web Development 4.4 out of 5 stars (130) CDN$ 41.57

Explore similar items

Customer Reviews

8 Reviews

5 star:		(6)
4 star:		(2)
3 star:		(0)
2 star:		(0)
1 star:		(0)

Average Customer Review

4.8 out of 5 stars (8 customer reviews)

Share your thoughts with other customers:

Create your own review

Most helpful customer reviews

5.0 out of 5 stars Great MySQL Book, Jul 31 2009

By	Brent Knowles - See all my reviews (REAL NAME)

This review is from: MySQL Cookbook (Paperback)

As a bit of an amateur when it comes to database applications, this was a must read for me. I found it took me through the basics into advanced concepts, with clear descriptions and useful examples, and solid, practical advice. It has greatly assisted me in my learning of database systems and how to maintain them. Well worth the money.

Was this review helpful to you? Yes No (Report this)

5.0 out of 5 stars Excellent All-Around Guide To MySQL Programming, April 6 2004

By	Alex Green "alex25019" (Toronto, Canada) - See all my reviews

I am an experienced web developer and recently started using Perl with MySQL to build database-driven CGI applications.
MySQL Cookbook by Paul DuBois turned out to be a valuable reference resource.

While the title mentions only MySQL, the book provides a great deal of solutions (and code) for using MySQL with Perl, PHP, Python and Java. If you are familiar with any of these computer languages, this book and MySQL manual is all you need to start building applications with MySQL-compatible database backend.

Was this review helpful to you? Yes No (Report this)

4.0 out of 5 stars A Hand-on guide to MySQL, May 21 2003

By A Customer

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.

Was this review helpful to you? Yes No (Report this)

Share your thoughts with other customers: Create your own review

› See all 8 customer reviews...

Most recent customer reviews

5.0 out of 5 stars a nice addition to O'Reilly's Cookbook series
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. Read more

Published on April 13 2003 by dsimpson1

5.0 out of 5 stars Excellent Style!
This book is full of examples. This is perfect for a learn-by-example programmer like me. It makes a handy reference, too. Read more

Published on Feb 4 2003 by Phillip A. Grove

4.0 out of 5 stars WELL-DONE, OR RATHER, WELL-COOKED
In this "MySQL Cookbook", Paul DuBois ensured that a wide range of topics were covered. In fact, most Unix and Mac OS X users would cherish the contents of this text... Read more

Published on Jan 30 2003 by reviewer

5.0 out of 5 stars Fantastic
The best thing about the book is that all you need is a rough inkling of what you want to do and you get an immediate kick start. Read more

Published on Jan 29 2003 by Richard S. Gawlik