By Paul DuBois
First Edition
October 2002
Pages: 1022
Series: Cookbooks
ISBN 10: 0-596-00145-2 |
ISBN 13: 9780596001452
(Average of 3 Customer Reviews)
This book has been updated—the edition you're requesting is OUT OF PRINT. Please visit the catalog page of the latest edition.
The latest edition is also available on Safari Books Online.
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. More than a collection of cut-and-paste code, this book explanation how and why the code works, so you can learn to adapt the techniques to similar situations.
Full Description
- 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
Register your book | Submit Errata | Examples & Author's Site
Browse within this book
Cover | Table of Contents | Index | Sample Chapter | Colophon
Book details
First Edition: October 2002
Series:
Cookbooks
ISBN: 0-596-00145-2
Pages: 1022
Average Customer Reviews: (Based on 3 Reviews)
Featured customer reviews
Dedicated to Future Technical Chefs Everywhere!, June 03 2005
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
MySQL Cookbook Review, November 15 2003
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.
MySQL Cookbook Review, February 25 2003
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.
Media reviews
"As a database user, developer, and maintenance consultant of many years, I found this book endlessly fascinating. I've learned a lot from it, and there's more to learn. I heartily recommend it for all who are already involved with or plan to become involved with MySQL."
--Paul DuBois, MELUG-Central, May 2004
"Paul has served up a real winner with 'MySQL Cookbook'... By the time I'd finished reading the Cookbook, I also decided that I need to accelerate my push to MySQL 4.0. The 'MySQL Cookbook' is going to be a book that stays close at hand. I'm giving it eight stars. If you're interested in working with MySQL, this book is going to provide you with many benefits."
--Pat Eyler, Linux Journal, May 2003
http://www.linuxjournal.com/article.php?sid=6853
"Two years in the making and about a 1000 pages long, 'MySQL Cookbook' is a must-own reference book and tutorial for MySQL developers of every skill level. The book is written in the traditional O'Reilly cookbook style, which involves identifying typical problems, briefly identifying solutions, and then elaborating on the solutions. If you're looking for a complete MySQL reference book or some help to improve your skills, this book is a good choice. It's fascinating to peruse and it's still interesting when read straight through."--Russell J.T. Dyer, UnixReview, March 2003
http://www.unixreview.com/documents/s=1357/ur0303l/
"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."
--Kenneth Wilcox, Boise Software Developers Group, Feb 2003
"I can say that it is excellent work--meticulous, crisp writing and useful recipes.
Paul has also done a nice job of covering the various traps and oddities that people are likely (or in some cases even unlikely) to encounter."
--http://zak.fooassociates.com/, Feb 2003
"'MySQL Cookbook' is a great book for anyone developing a user interface to a MySQL database."
--Brad Crockett, Big Blue and Cousins, Feb 2003
"An impressive collection of SQL query examples, which show you how to accomplish many commonly requested database tasks, The book will find a wide audience not only among professional site administrators, but also among the growing body of users who deal with this versatile database for other non-Web related data processing tasks."
--Netsurfer Digest , Nov 15, 2002
"Overall I give it 3 out of 4 penguins...it can become the only book you'll ever need for MySQL."--Samir Faci, NIU Linux Users Group, May 20, 2003
http://www.distanthaze.com/~z002161/pages/reviews/mysql.html
