Save with Used - Very Good
£0.70
£2.80 delivery 20 - 23 July
Dispatches from: World of Books Ltd
Sold by: World of Books Ltd
£0.70
Expedited shipping available on this book. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged. Expedited shipping available on this book. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged. See less
£2.80 delivery 20 - 23 July. Order within 10 hrs 2 mins. Details
Only 7 left in stock.
££0.70 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
££0.70
Subtotal
Initial payment breakdown
Delivery cost, delivery date and order total (including tax) shown at checkout.
Dispatched from and sold by World of Books Ltd.
£3.50
Buy from the UK's book specialist. Enjoy same or next day dispatch. A top-rated and trusted seller on Amazon. Buy from the UK's book specialist. Enjoy same or next day dispatch. A top-rated and trusted seller on Amazon. See less
FREE delivery 20 - 23 July. Details
Or fastest delivery Friday, 19 July. Order within 11 hrs 2 mins. Details
Only 1 left in stock.
££0.70 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
££0.70
Subtotal
Initial payment breakdown
Delivery cost, delivery date and order total (including tax) shown at checkout.
Dispatched from and sold by WeBuyBooks.
Added to

Sorry, there was a problem.

There was an error retrieving your Wish Lists. Please try again.

Sorry, there was a problem.

List unavailable.
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet or computer – no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

Follow the authors

See all
Makoto Akai
Follow
Paul Dubois
Follow
Something went wrong. Please try your request again later.

MySQL Cookbook 2e Paperback – 5 Dec. 2006

by Paul Dubois (Author)
4.5 4.5 out of 5 stars 39 ratings
See all formats and editions

There is a newer edition of this item:

MySQL Cookbook: Solutions for Database Developers and Administrators
MySQL Cookbook: Solutions for Database Developers and Administrators
£49.99
(11)
Only 2 left in stock (more on the way).
{"desktop_buybox_group_1":[{"displayPrice":"£0.70","priceAmount":0.70,"currencySymbol":"£","integerValue":"0","decimalSeparator":".","fractionalValue":"70","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"mmAgT%2BuNONyOM%2B3OI0SkDB6NQBw92rvMZqCyxLkyy7wm%2BxbM4vJR8stJCNFY5a4y1rAAFOrpB1jEJo%2FLPXexfjPOvygktrbcqZ2l5TJdjuodgYrb33YBfhBePsM9J3t8ByHr2LCgiOhoGZzOoNYTKWc3uMspQaf6bVsznLukp7sJA9RWSZ0Z2A%3D%3D","locale":"en-GB","buyingOptionType":"USED","aapiBuyingOptionIndex":0}, {"displayPrice":"£3.50","priceAmount":3.50,"currencySymbol":"£","integerValue":"3","decimalSeparator":".","fractionalValue":"50","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"mmAgT%2BuNONyOM%2B3OI0SkDB6NQBw92rvMKwGxHSIvEHgvXhLFVa6OjcXOo1mL5kxd9LXIdDZEm8UVOe5N4MwuJOemRheITqA3UkkDnDWm2MqNlxIBpR7WutualiiGbW%2B3mX7LGMxEDiZHVoSHDZ2%2FhpZk0O0j5EZnYOAzA3D155vwhrxQEpihvg%3D%3D","locale":"en-GB","buyingOptionType":"USED","aapiBuyingOptionIndex":1}]}

Purchase options and add-ons

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.
Previous slide of product details
  1. ISBN-10
    059652708X
  2. ISBN-13
    978-0596527082
  3. Edition
    2nd
  4. Publisher
    O′Reilly
  5. Publication date
    5 Dec. 2006
  6. Language
    English
  7. Dimensions
    17.78 x 5.33 x 23.34 cm
  8. Print length
    960 pages
  9. See all details
Next slide of product details

Product description

About the Author

Paul DuBois is one of the primary contributors to the MySQL Reference Manual, a renowned online manual that has supported MySQL administrators and database developers for years, now available in an attractive paper format from the O'Reilly Community Press. He is also the author of Using csh & tcsh and Software Portability with imake by O'Reilly, as well as MySQL and MySQL and Perl for the Web by New Riders.

Product details

  • Publisher ‏ : ‎ O′Reilly; 2nd edition (5 Dec. 2006)
  • Language ‏ : ‎ English
  • Paperback ‏ : ‎ 960 pages
  • ISBN-10 ‏ : ‎ 059652708X
  • ISBN-13 ‏ : ‎ 978-0596527082
  • Dimensions ‏ : ‎ 17.78 x 5.33 x 23.34 cm
  • Customer reviews:
    4.5 4.5 out of 5 stars 39 ratings

About the authors

Follow authors to get new release updates, plus improved recommendations.
Previous page
  1. Makoto Akai

    Makoto Akai

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    Discover more of the author’s books, see similar authors, read author blogs and more

    See more on the author's page
  2. Paul Dubois

    Paul Dubois

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    Discover more of the author’s books, see similar authors, read author blogs and more

    See more on the author's page
  3. 北山 貴広

    北山 貴広

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    Discover more of the author’s books, see similar authors, read author blogs and more

    See more on the author's page
  4. Makoto Akai

    Makoto Akai

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    Discover more of the author’s books, see similar authors, read author blogs and more

    See more on the author's page
Next page

Customer reviews

4.5 out of 5 stars
4.5 out of 5
39 global ratings

Top reviews from United Kingdom

Mt N. Holmes
5.0 out of 5 stars Great Book
Reviewed in the United Kingdom on 9 December 2010
Verified Purchase
It is not for the complete beginner, but you don't have to be too far off to get some real benefit from using this book.

The discussions about why you would use a particular technique are excellent too.

In my opinion it is great. I bought it and I am still using it.
One person found this helpful
Helpful
 Report
Jasmin
4.0 out of 5 stars Good book, recommanded
Reviewed in the United Kingdom on 18 October 2010
I like the style of the book which tackles the problems encountered rather than introducing theories chapter by chapter.

The reason I gave it a 4 is that it didn't cover some more advanced skills for database admin such as database management and securities.
Helpful
 Report
Chris Smith
5.0 out of 5 stars Very Useful
Reviewed in the United Kingdom on 10 October 2013
Verified Purchase
This book was a great starter when I got into MySQL and has been the foundation for all my projects and knowledge of MySQL. A great and useful book.
Helpful
 Report
andyc
5.0 out of 5 stars Five Stars
Reviewed in the United Kingdom on 11 September 2015
Verified Purchase
great book - perfectly structured in sections of native mysql and various interfaces for Perl, Python, PHP etc
Helpful
 Report
Craig West
5.0 out of 5 stars Five Stars
Reviewed in the United Kingdom on 31 October 2017
Verified Purchase
did as said
Helpful
 Report
sa.vuec
5.0 out of 5 stars Five Stars
Reviewed in the United Kingdom on 20 October 2014
Verified Purchase
good product. good price.
Helpful
 Report
Ian Hiles
5.0 out of 5 stars Does Exactly What It Says On The Tin
Reviewed in the United Kingdom on 14 May 2008
A few pages past the table of contents, I had solved two issues that had been bugging me since my last install. It was pretty minor stuff, but could I as heck find the answers online. It just shows what research, presentation, and quality control can achieve. So, another score for books over bytes.

The layout is uncluttered, and you can usually get the gist without reading through pages of preamble and exposition. The examples are practical and adaptable (no long and complex routines found on some sites) so they can almost be cut and pasted into your own applications. As your applications develop, there's always something else you can add.

The only downside is that it's a book - a few mods to MySQL and you might have to fork out for the next revision. Still, I should have got my money's worth by then.
5 people found this helpful
Helpful
 Report

Top reviews from other countries

Translate all reviews to English
Nova P Smith
5.0 out of 5 stars Excellent resource
Reviewed in the United States on 1 September 2023
Verified Purchase
There is a lot to get through in this book. I wish it had a disc with it like the old days. I'd settle for a link.
Report
Alex D
5.0 out of 5 stars Excellent All-Around Guide To MySQL Programming
Reviewed in Canada on 6 April 2004
Verified Purchase
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.
Report
Olivier Delrieu
5.0 out of 5 stars Excellent!
Reviewed in France on 18 April 2009
Verified Purchase
très complet, facile à utiliser, bien classé, bien expliqué. Les codes sont dispo sur le web. Va de paire avec mysql admin.
One person found this helpful
 Report
tsingtao
5.0 out of 5 stars 負荷がかかる環境でMySQLを運用する際の手法を紹介
Reviewed in Japan on 12 October 2004
Verified Purchase
Vol.1 は基本的な運用方法を紹介しているとしたら、Vol.2 はMySQLに負荷がかかる運用を行う手法を紹介している。
目次内容からわかるように、会計処理や予約処理よりもWEBアプリケーションの基礎的な運用と処理方法を中心に書かれている。
不特定多数の利用者からのクエリーをいかに無害化させるか、格納されたデータの重複データを探し出す方法、ApacheとPerlとの連携方法、セッション管理なども記述されている。
また、Javaサーブレットとの運用なども記述されているので、興味がある人は一度書店で実物を確認してみると良いはず。
MySQLのマニュアルが無料公開されているので、そちらを読めば済むような話しも多いが、公開されているマニュアルは読みにくいなと思う人は一度、本書の内容を確認してみても損はしないはず。
6 people found this helpful
 Report
Andrew Crawford
4.0 out of 5 stars Excellent Reading for MySQL Users
Reviewed in the United States on 8 February 2007
Verified Purchase
The MySQL Cookbook removes some abstraction from reading the docs. The recipes are concise answers to real-world questions about how to accomplish specific goals with MySQL. It covers common vexing problems that would require significant spelunking in the manuals or web search engines. The recipes provide more clarifying context than the manual, making it easier to learn how to use all those arcane features you had barely noticed. Great as a reference or, upgrade your brain by reading a few entries a day.
4 people found this helpful
 Report