The Super Fun Kids' Graphic Novel Sale

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to
for a chance to win.
Privacy Policy

Visit our stores

    Recently Viewed clear list

    Original Essays | September 21, 2015

    Annie Jacobsen: IMG Mirrors on the Moon: A Reporter's Story about Sources and Secrets in the Modern World

    As a national security reporter, I write about war, weapons, security, and secrets. The question most commonly asked of me is, "How do you get... Continue »
    1. $21.00 Sale Hardcover add to wish list

Qualifying orders ship free.
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
6 Remote Warehouse Software Engineering- Programming and Languages
25 Remote Warehouse Computer Languages- XML

MySQL Cookbook: Solutions for Database Developers and Administrators


MySQL Cookbook: Solutions for Database Developers and Administrators Cover


Synopses & Reviews

Publisher Comments:

MySQLs 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

About the Author

Paul DuBois was one of the first contributors to the online MySQL Reference Manual, a renowned documentation project that supported MySQL administrators and database developers in the first few years of MySQL's existence in the late 1990's. Paul went on to write more than six books on MySQL, including the first edition of "MySQL Cookbook". He is also the author of "Using csh & tcsh" and "Software Portability with imake", both by O'Reilly.

Product Details

Dubois, Paul
O'Reilly Media
DuBois, Paul
Database Management - General
Computer Languages-XML
Edition Description:
Print PDF
Publication Date:
9.19 x 7 in

Related Subjects

Computers and Internet » Computer Languages » XML
Computers and Internet » Computers Reference » General
Computers and Internet » Database » Applications
Computers and Internet » Database » Database Management
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Programming and Languages

MySQL Cookbook: Solutions for Database Developers and Administrators New Trade Paper
0 stars - 0 reviews
$79.99 In Stock
Product details 866 pages O'Reilly Media - English 9781449374020 Reviews:
  • back to top


Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at