MySQL Cookbook
Publisher: O'Reilly Media
Final Release Date: October 2002
Pages: 1024

While MySQL has turned up among high profile users such as Yahoo!, NASA and the U.S. Census Bureau, the rising popularity of this open source database is especially keen among users with little database experience. These days, even a small organization or web site has uses for a database, and MySQL is an obvious choice. Affordable and easy to use, MySQL packs the power, speed and efficiency that enable it to rival expensive, proprietary database solutions. Yet, even if you know the basics, anyone without practical MySQL experience--novices and skilled DBAs alike--might stumble over common database-related tasks. Fortunately, there's a sensible shortcut.MySQL Cookbook provides a unique problem-and-solution format that offers practical examples for everyday programming dilemmas. For every problem addressed in the book, there's a worked-out solution or "recipe"--short, focused pieces of code that you can insert directly into your applications. But MySQL Cookbook is more than a collection of cut-and-paste code. You also get explanations of how and why the code works, so you can learn to adapt the techniques to similar situations.The book covers a lot of ground. Solutions for typical MySQL dilemmas range from simple ways to find all records that contain a given string, to more difficult problems, such as finding matching/non-matching records in two tables. Whether you use MySQL on Unix, Linux, Windows or the Mac OS X platform, the book will show you how to:

  • Import data from external sources
  • Export data for use by external programs
  • Access MySQL from your web server
  • Use scripts with MySQL to read queries from a file
  • Access MySQL from within client programs that use Perl, PHP, Java, Python and other languages
  • Construct queries that solve commonly-occurring questions
  • Interact with the server
This learn-as-you-go resource will help users of all levels exploit MySQL more fully. MySQL Cookbook supplies you with an armory of ready-made techniques for specific problems so that, even if you're an experienced MySQL user, you don't have to write everything from scratch.
Table of Contents
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyMySQL Cookbook
 
5.0

(based on 3 reviews)

Ratings Distribution

  • 5 Stars

     

    (3)

  • 4 Stars

     

    (0)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

Reviewed by 3 customers

Sort by

Displaying reviews 1-3

Back to top

 
5.0

Dedicated to Future Technical Chefs Everywhere!

By Anonymous

from Undisclosed

Comments about oreilly MySQL Cookbook:

I am a big fan of hands-on books. I especially like the `From Scratch` and `Cookbook` type titles.

Well, lucky me. When I attended the 2005 MySQL Users Conference in Santa Clara CA in April '05, I received the "MySQL Cookbook" by Paul DuBois as a reward for early registration.

The day after I returned back to work from the conference, one of my co-workers came looking for some guidance in regards to a MySQL database issue he was having. His description sounded familiar to one of the recipes I skimmed in the cookbook. Sure enough, I found the resolution within two minutes, and had sent

another satisfied customer on his way.

The great aspect of this book is that it is written to provide solutions to over 315 real-world problems. Whenever I come up against an obstacle in regards to MySQL, I head straight to the table of contents and scan for a recipe that looks like it might be a match.

One topic I wish was covered somewhere in this text is the concept of derived tables, which are basically sub-queries used as tables in a join.

Take a look at the book description located at the following URL, and try out some of the recipes shown:

http://www.oreilly.com/catalog/mysqlckbk/

The "MySQL Cookbook" and "MySQL in a Nutshell" books are permanent fixtures in my office ... except for when my co-workers borrow them.

-Brett Berry

PERL/PHP/JavaScript/MySQL

http://www.BrettBerry.com

 
5.0

MySQL Cookbook Review

By Yasser Hawari

from Undisclosed

Comments about oreilly MySQL Cookbook:

I had some hesitation choosing a book for a kick-start in Mysql. I looked for book reveiws @ amazon and I chose this book. In simple words, if you are a hands-on kinda guy, then this is the book for u. the book simply exposes your to consecutive subjects smoothly and shows u how to deal with them - or at least sheds some light on the subject. I personally like this book.

 
5.0

MySQL Cookbook Review

By Kenneth Wilcox

from Undisclosed

Comments about oreilly MySQL Cookbook:

This has got to be one of the best technical books in print. From the very start the authors assume nothing. Need to get MySQL up and running? it's in there. Need to access the data with Perl, Python, PHP, Java, it's in there. I'm actually using this book to help me learn Perl and Python. MySQL AB should bundle this book with each license it sells. I have not read it all but have been very impressed with what I have read so far.

Displaying reviews 1-3

Back to top

 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?