MySQL Pocket Reference (Mass Market Paperback)

by George Reese (Author)
Key Phrases: create clause, numerical context, update log, Pocket Reference, Description Stores

Editorial Reviews

Product Description
To help you be more efficient in your work, this handy pocket reference gives you instant reminders on how to use important MySQL functions, especially in conjunction with key parts of the LAMP open source infrastructure. This powerful database system is so rich in features that no administrator or programmer can stay familiar with all of them. MySQL Pocket Reference is an ideal on-the-job companion, well organized to help you find and adapt the statements you need -- quickly.

Updated for the latest versions of this popular database, this edition covers many complex features that have been added to MySQL 5.0 and 5.1, including a section dedicated to stored procedures and triggers. After a brief introduction on installation and initial setup, the book explains:

• How to configure MySQL, such as setting the root password
• MySQL data types, including numerics, strings, dates, and complex types
• SQL syntax, commands, data types, operators, and functions
• Arithmetic, comparison and logical operators
• Aggregate and general functions
• Stored procedures and triggers, including procedure definition, procedure calls, procedure management, cursors, and triggers

You don't have time to stop and thumb through an exhaustive reference when you're hard at work. This portable and affordable guide is small enough to fit into your pocket, and gives you a convenient reference that you can consult anywhere. When you reach a sticking point and need to get to a solution quickly, the MySQL Pocket Reference is the book you want to have. --This text refers to the Paperback edition.

About the Author
George Reese has taken an unusual path into business software development. After earning a B.A. in philosophy from Bates College in Lewiston, Maine, George went off to Hollywood where he worked on television shows such as "The People's Court" and ESPN's "Up Close". The L.A. riots convinced him to return to Maine where he finally became involved with software development and the Internet. George has since specialized in the development of Internet-oriented Java enterprise systems and the strategic role of technology in business processes. He is the author of Database Programming with JDBC and Java, 2nd Edition and the world's first JDBC driver, the mSQL-JDBC driver for mSQL. He currently lives in Minneapolis, Minnesota with his wife Monique and three cats, Misty, Gypsy, and Tia. He makes a living as the National Practice Director of Technology Strategy for digital@jwt in Minneapolis.

Product Details

• Mass Market Paperback: 96 pages
• Publisher: O'Reilly Media, Inc. (February 1, 2003)
• Language: English
• ISBN-10: 059600446X
• ISBN-13: 978-0596004460
• Product Dimensions: 6.8 x 4.2 x 0.4 inches
• Shipping Weight: 3.5 ounces (View shipping rates and policies)
• Average Customer Review: 4.8 out of 5 stars See all reviews (9 customer reviews)
• Amazon.com Sales Rank: #270,649 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #5 in	Books > Computers & Internet > Apple > Databases
  #86 in	Books > Computers & Internet > Databases > Specific Databases > MySQL & mSQL
  #88 in	Books > Computers & Internet > Databases > Data Warehousing

Customer Reviews

Most Helpful Customer Reviews

7 of 7 people found the following review helpful:

5.0 out of 5 stars Excellent, quick reference, December 7, 2004

By	Greg E. Covey (Los Angeles, CA) - See all my reviews (REAL NAME)

This is an excellent reference to the MySQL language. It is faster to use than the online MySQL documentation, and can go anywyere. This is a better reference to MySQL than the O'Reilly book 'SQL in a Nutshell' (first edition), which left out many key MySQL commands and clauses.

The only downside to this book is that it does not include a list of reserved words for MySQL. Other than that, it's a great reference.

4 of 5 people found the following review helpful:

5.0 out of 5 stars Good Reference, August 8, 2003

By A Customer

I'm always looking for a good MySQL reference. I find myself looking for the syntax of a particular command. This book comes in handy when looking for a particular MySQL command. For the size of this book, is really packs a ton of information.

5.0 out of 5 stars great knowledge base, March 29, 2009

By	Patric Lagny (Inglewood, CA United States) - See all my reviews (REAL NAME)

For the occasional MySQL programmer this book is a must. I use MySQL to a small degree in my recent game project and this book gives me all the knowledge I need to write simple queries in C++