MySQL Language Reference (Paperback)

by MySQL AB (Author)

Editorial Reviews

Product Description

With more than 4 million active installations, MySQL is the world's most popular open-source database.

Known for its speed, high reliability, and ease of use, MySQL is rapidly becoming a low-cost alternative to high-priced, high-maintenance database systems from Oracle, IMB and Microsoft-and it already has more users than any of these more established proprietary databases.

The MySQL Language Reference is the only official guide to the MySQL language and programming APIs.

Written by the creators of MySQL, and edited by the highly respected MySQL authors, the MySQL Language Reference is designed for database administrators and programmers who need a reliable, detailed reference to every part of the MySQL language and all the available APIs.

About the Author

Paul DuBois is the leading author of books on MySQL topics. His book MySQL (0-7357-1212-3), is widely considered to be the definitive guide to using, administering, and programming MySQL. He is currently an employee of MySQL AB and is in charge of editing and maintaining the official English-language documentation for MySQL.

Product Details

• Paperback: 504 pages
• Publisher: MySQL Press (August 1, 2004)
• Language: English
• ISBN-10: 0672326337
• ISBN-13: 978-0672326332
• Product Dimensions: 8.7 x 7 x 1.3 inches
• Shipping Weight: 1.7 pounds (View shipping rates and policies)
• Average Customer Review: 4.3 out of 5 stars See all reviews (3 customer reviews)
• Amazon.com Sales Rank: #1,188,467 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

19 of 19 people found the following review helpful:

3.0 out of 5 stars Printing Web Pages, September 12, 2004

By	C. E. Morgan (Jacksonville, FL United States) - See all my reviews (REAL NAME)

If you are seriously considering purchasing this book, you should be aware that aside from some typical publisher's mumbo jumbo up front, this is a hardcopy format of the online MySQL Documentation already available via the web. The language of THAT work has always been a little tortured; but once you spend some time with it, it does get the point across.

I don't want to imply this book is without value - it isn't. If nothing else, the covenience of having it in this format is worth something - I'm just not sure $40 is the right number.

8 of 12 people found the following review helpful:

5.0 out of 5 stars All You Need - What More Can I Say., August 19, 2004

By	John Matlock "Gunny" (Winnemucca, NV) - See all my reviews (REAL NAME)

I first looked at using MySql in a web application back around 2001 or 2. Using it would have required a port of the SQL statements. And I decided not to use it. The application I was porting had lots of statements that used SubQueries, and MySql didn't support these. Yes, I could have re-written all the statements using joins and other methods, but what a lot of work.

As a result, when I was first flipping through this book I found a section - Subquery Syntax. In that section, the first example showed a nested SELECT statement that had four cascaded subqueries. So I sat down in the bookstore and started reading this section. Subqueries took a dozen pages to describe, and included enough information that I found myself learning a lot about subqueries that I didn't know. (I'd point these things out, but then you'd just think I was pretty dumb.)

Then I looked for a few other things that I've had trouble finding with other DB books: Reserved Words (go try to find the reserved words in Access for instance) they are the last couple of pages in Chapter 2. Replication - it's there. Everything I looked for was there.

Let's net this out. This book is $40 (that's list price, but you know better than that). The software is ZIP - just go to www.mysql.com, click on developer and download the version you want (Linux in a bunch of versions, Windows, and several versions of Unix). The price is still ZIP. You want to upgrade to the next version, yup, cost is ZIP. Less than $40 is your total investment.

5.0 out of 5 stars Good Book, Most Available Online, May 12, 2009

By	DaWa (NJ, USA) - See all my reviews

This is a great reference book, but note that practically all of this info is available online. That being said, when I develop I like to have the written book handy. It's a well organized and well bound softcover.