MySQL Cookbook
Solutions for Database Developers and Administrators
Publisher: O'Reilly Media
Final Release Date: May 2014
Pages: 866

With Early Release ebooks, you get books in their earliest form — the author's raw and unedited content as he or she writes — so you can take advantage of these technologies long before the official release of these titles. You'll also receive updates when significant changes are made, new chapters as they're written, and the final ebook bundle.



MySQL’s popularity has brought a flood of questions about how to solve 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.

This third edition has been updated to cover new APIs in Python and PHP, as well as powerful new features in MySQL 5.6 and older versions still in common use. Recipes use the mysql client program as well as Java, Perl, PHP, Python, and Ruby APIs.

  • Sort rows in common ways and use aggregate functions to 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
  • Use strict mode to prevent entry of bad data into your database
  • Copy a table or a database to another server
  • Create database events that execute according to a schedule
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyMySQL Cookbook
 
5.0

(based on 1 review)

Ratings Distribution

  • 5 Stars

     

    (1)

  • 4 Stars

     

    (0)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

Reviewed by 1 customer

Displaying review 1

Back to top

 
5.0

So far great read

By FryGuy

from Germany

About Me Developer, Educator, Sys Admin

Verified Buyer

Pros

  • Accurate
  • Concise
  • Easy to understand
  • Helpful examples
  • Well-written

Cons

  • Not complete

Best Uses

  • Expert
  • Intermediate
  • Novice
  • Student

Comments about oreilly MySQL Cookbook:

While this book is not complete I believe that so far it has been very useful and informative. I would say I am fairly familiar with this topic, but it has some great examples of how to interface with different programming languages and APIs that I find very useful. I will give it 5 stars for now, but would like to see more before I say it actually deserves a 5.

Displaying review 1

Back to top

 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Pre-Order  Print: $79.99
August 2014 (est.)