| | |  | General | Home » » » » MySQL Pocket Reference: SQL Statements, Functions and Utilities and more (Pocket Reference (O'Reilly)) | | | | | | | Product Promotions: | | | | | 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.
| | | Features: | |
• ISBN13: 9780596514266
• Condition: New
• Notes: BRAND NEW FROM PUBLISHER! 100% Satisfaction Guarantee. Tracking provided on most orders. Buy with Confidence! Millions of books sold!
| | | Product Details: | | | Author:
| George Reese | | Paperback:
| 134 pages | | Publisher:
| O'Reilly Media | | Publication Date:
| July 24, 2007 | | Language:
| English | | ISBN:
| 0596514263 | | Product Length:
| 7.0 inches | | Product Width:
| 4.34 inches | | Product Height:
| 0.35 inches | | Product Weight:
| 0.28 pounds | | Package Length:
| 6.9 inches | | Package Width:
| 4.1 inches | | Package Height:
| 0.5 inches | | Package Weight:
| 0.3 pounds | | Average Customer Rating:
|  based on 11 reviews |
| | | | Customer Reviews: | |
Average Customer Review:
 ( 11 customer reviews )
Write an online review and share your thoughts with other customers.
Most Helpful Customer Reviews
11 of 11 found the following review helpful:
 Excellent, quick referenceDec 07, 2004
By Greg E. Covey
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.
6 of 7 found the following review helpful:
Good ReferenceAug 08, 2003
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.
2 of 2 found the following review helpful:
 Ideal for Intermediate-level UsersNov 01, 2010
By Dr. Bojan Tunguz
I got this pocket reference when I was creating my first MySQL intensive website. I learned most of the basic MySQL from another book, but I found that turning to a textbook for the basic reference was too cumbersome. This pocket guide is primarily useful for quick checking of syntax or the structure of the basic MySQL uses. Despite the plethora of the information on the web, I still find it most efficient to look in this pocket reference if I just need some basic information or a confirmation of a particular use. I think that the ideal audience for this reference would be the intermediate-level MySQL programmers - people who are familiar enough with MySQL that they don't need extensive hand-holding with every detail, and yet are not so advanced to find the information in this reference redundant or not detailed enough.
The only major issue that I have with this pocket guide is that today it's a bit dated and in a need of a major revision and an update. However, despite this shortcoming it is still fairly useful for most everyday MySQL uses.
10 of 14 found the following review helpful:
 Good, but needs updating & improvingMay 06, 2007
By P. N. Payne
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.
Ask Felgall - Book ReviewNov 29, 2011
By Stephen Chapman
If you have at least a basic knowledge of mySQL but haven't yet memorised all of the syntax for all of the possible options that can be used with your mySQL calls then you need this book. The small size of the book makes it easy to keep on you at all times while the extremely detailed content will provide you with the information you need to perform any possible processing on your database.
By making use of the information presented in this book you will hopefully be able to extract data preconverted into the format you require instead of having to reformat it after extraction. You will be able to fine tune your code to minimize the need for substantial processing in the calling program. You will be able to harness the full power of mySQL. An ideal reference resource. Unfortunately it doesn't cover all the functions available for converting your data and so in some cases there will be an easier way to set up the call than the functions that the book does list suggests.
See all 11 customer reviews on Amazon.com
| | |
|
