Binding: Paperback Dewey Decimal Number: 005.133 EAN: 9780596514266 ISBN: 0596514263 Label: O'Reilly Media, Inc. Manufacturer: O'Reilly Media, Inc. Number Of Items: 1 Number Of Pages: 132 Publication Date: July 17, 2007 Publisher: O'Reilly Media, Inc. Sales Rank: 230425 Studio: O'Reilly Media, Inc.
Product DescriptionTo 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.
Customer Reviews
Average Rating:
Rating: - Explanations are accompanied by tables and examples for maximum efficiency.
George Reese's MY SQL POCKET REFERENCE 2ND EDITION covers Version 5.1 and provides SQL statements, functions, and insights into its variations and utilities. Explanations are accompanied by tables and examples for maximum efficiency.
Rating: - Excellent Quick Reference for MySQL RDBMS
Reese hits a solid triple to start the inning off and scores easily on the wild pitch thrown by the reader who says that the GRANT section is wrong.
This book works easily and appropriately at your deskside. I found the book to be a very simple, easy-to-navigate reference text that presents the most important aspects of MySQL in the quickest, most logical manner.
It is very easy to thumb through with every possible random page landing at a topic of interest. In a way, it was like working with ... Read More
Rating: - Entry level pocket reference
MySQL has gained a lot of functionality after this book was done, but if you are a infrequent developer and like to have a quick reference into basic MySQL functions this book is great.
Rating: - Good, but needs updating & improving
It's handy, but a little old and too brief with important parts left out. It needs to be updated and improved. Ie: The admin commands are poorly covered. Do not use this book to help you use Grant or Revoke. The Grant All section is simply wrong.
Rating: - small and excellent
Very practical and after every command there is a very useful example.
- Explanations are accompanied by tables and examples for maximum efficiency.
- Good, but needs updating & improving
