Programming Books C Java PHP Python Learn more Browse Programming Books
MySQL Phrasebook (Developer's Library) and over one million other books are available for Amazon Kindle. Learn more

Sorry, this item is not available in
Image not available for
Image not available

To view this video download Flash Player


Sign in to turn on 1-Click ordering
More Buying Choices
Have one to sell? Sell yours here
Start reading MySQL Phrasebook (Developer's Library) on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

MySQL Phrasebook [Paperback]

Zak Greant , Chris Newman
4.2 out of 5 stars  See all reviews (4 customer reviews)

List Price: $24.99
Price: $15.17 & FREE Shipping on orders over $35. Details
You Save: $9.82 (39%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 3 left in stock (more on the way).
Ships from and sold by Gift-wrap available.
Want it Monday, July 14? Choose One-Day Shipping at checkout. Details
Free Two-Day Shipping for College Students with Amazon Student


Amazon Price New from Used from
Kindle Edition $9.99  
Paperback $15.17  
Shop the new
New! Introducing the, a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Book Description

March 26, 2006 0672328399 978-0672328398

The MySQL Phrasebook is a pocket guide that is jam-packed with useful and essential code "phrases" for the MySQL developer's everyday use. Packed with practical solutions for tasks that the MySQL developer must accomplish every day, it fills the need for a short, functional, to-the-point reference for MySQL. This is the guide to consult when you need an immediate, applicable solution to frequent tasks and code that is flexible and adaptable to your needs. Your time won't be wasted on more tutorials — it simply puts essential "phrases" at your fingertips that you can take with you everywhere.

Frequently Bought Together

MySQL Phrasebook + Apache Phrasebook + PHP Phrasebook
Price for all three: $54.08

Buy the selected items together
  • Apache Phrasebook $15.17
  • PHP Phrasebook $23.74

Customers Who Bought This Item Also Bought

Editorial Reviews

About the Author

Zak Greant is a technical evangelist, author and programmer whose deep and constant love of Free Software and Open Source has made him an admired and sought-after speaker, developer and advocate. Zak currently works at eZ Systems where he helps businesses and Free/Open projects create and execute plans for their strategic, marketing, human resource, product, service, and information technology management activities.


Chris Newman is a consultant programmer specializing in database development with an Internet twist.  He has extensive commercial experience of using PHP to integrate various database systems and has produced a wide range of applications for an international client base.  He runs Lightwood Consultancy Ltd, the company he founded in 1999 to further his interest in online database development.  Newman has served as a technical editor on several books from Sams, including PHP and MySQL Web Development, Teach Yourself PHP, MySQL & Apache All in One, and Red Hat Fedora Unleashed.  He is a frequent contributor to and also wrote SQLite and Sams Teach Yourself PHP in 10 Minutes.

Product Details

  • Paperback: 192 pages
  • Publisher: Sams Publishing (March 26, 2006)
  • Language: English
  • ISBN-10: 0672328399
  • ISBN-13: 978-0672328398
  • Product Dimensions: 0.4 x 4.4 x 7 inches
  • Shipping Weight: 5 ounces (View shipping rates and policies)
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (4 customer reviews)
  • Amazon Best Sellers Rank: #1,647,405 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

4.2 out of 5 stars
4.2 out of 5 stars
Share your thoughts with other customers
Most Helpful Customer Reviews
10 of 11 people found the following review helpful
4.0 out of 5 stars Great reference tool April 15, 2006
It's a very light book, slightly taller than your average paper back, weighing in at only 181 pages. In those pages the authors have managed to cram in lots of different types of information: From a basic introduction to the relational database model, to basic administration information, to query design and code examples in C, PHP & Perl. That's a lot of information for such a tiny book, so necessarily the coverage is brief. Fortunately the authors managed to hone in on the information from each section that would be most useful to the reader, and concentrate on that.

The "phrases" the book introduces deal are basically short little answers to questions that come up frequently when working with MySQL (I might say that a Phrasebook Sam's pocketbook version of O'Reilly's cookbooks). Starting off with basic things like select queries, and moving up to cross table queries (incidentally I finally understand the difference between an inner and outer join). It also goes into performance tips, server administration, and backups.

If you're already well versed in the world of MySQL, this isn't the book for you. However, if you're anything like me, someone who uses MySQL a lot for a few basic things but doesn't really know much beyond that, this book will be a good addition to your reference library. If you're just getting started with MySQL this book isn't going to teach you everything you know, but will help answer some questions for you along the way.

Overall I'd recommend this book to most of my friends.
Comment | 
Was this review helpful to you?
3 of 4 people found the following review helpful
5.0 out of 5 stars Good Little Book September 13, 2006
I got my hands on several copies of the new Phrasebook series from Developer's Library back in April 2006 but as they were intended as handouts at my conference talks, I could not hold onto them long enough to review them. I've since managed to hold onto a copy of the MySQL Phrasebook long enough to review it and consider it worth the wait.

The MySQL Phrasebook makes a useful companion for a beginning MySQL administrator or developer looking for a guide that can be carried along wherever they happen to be coding. It comes with a useful overview of the MySQL architecture followed by useful information organized by use-case.

There are useful chapters on APIs, advanced queries and troubleshooting that I found particularly nice. As an occasional developer, having a simple sample PHP script is usually all I need to reference when developing and I was happy to see that the included example was written against the mysqli provider instead of the older mysql provider.

In addition to being quite useful, the price is certainly right at at list of $14.99 (less on Amazon). At just over 150 pages in pocket format I wouldn't expect to pay much more, but I'm happy to see that the price is reasonable.

This phrasebook, along with its PHP and Apache companions, will certainly accompany me on future coding trips where other reference materials would prove too bulky.
Comment | 
Was this review helpful to you?
4.0 out of 5 stars Book Review from Silicon Valley Web Builder (SVWB) October 26, 2009
By Bess Ho
I will never estimate how practical and useful a pocket guide are. This pocket guide can replace a standard developer book on MySQL as far as covering the most essential details to create, design, develop and maintain MySQL database. Sometimes bigger book with more pages does not offer you more concise knowledge. This pocket guide gives you the reference links that would save you time and effort in filtering search results and identifying appropriate documentation. At last the Appendix on "A Brief MySQL Tutorial" is one of the best written tutorial in MySQL using a simple application with code samples and chronological tasks.

MySQL Phrasebook
Comment | 
Was this review helpful to you?
4.0 out of 5 stars Nice Reference August 23, 2008
Format:Paperback|Verified Purchase
This book is pretty nice. It's fairly handy. However, I'm inclined to group it in the beginner-intermediate range (not that it's advertised otherwise).

The majority of the times that I've picked it up to investigate things that I wasn't sure about/had never attempted, I failed to find them in the index. Thumbing through the book to find various things I find a proliferation of information that any experienced user (note--I've only been using MySQL for a year now) will almost certainly not need to look up.

Don't get me wrong, it is a very useful book; it's just that most of the times I reach for it, I find myself disappointed and getting another book or looking online.
Comment | 
Was this review helpful to you?
Search Customer Reviews
Search these reviews only

What Other Items Do Customers Buy After Viewing This Item?


There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
First post:
Prompts for sign-in

Look for Similar Items by Category