Excellent Quick Reference for MySQL RDBMS | MySQL Pocket Reference

Entry level pocket reference | MySQL Pocket Reference | George Reese

Are you a book author or do you know one? We offer free book publicity!

books:


	• MySQL Pocket Reference George Reese O'Reilly Media, 2003 - 96 pages average customer review:based on 9 reviews view larger image
	for more information click here

highly recommended

great knowledge base

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++

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 a familiar dictionary, you know the kind, where you just kind of naturally crack it open near the word you're accessing and flip a couple of pages either direction to arrive at the exact reference location. In that vein, I'd perhaps recommend that the margins contain "bread crumbs" telling us where we are in the book, but it isn't necessary since thicker sections often obviate themselves with just another page turn. Each page does have the chapter title in the margin, so my point is really one of nit-pickieness rather than a true critique. To its credit, the layout of the book presents the content in a manner that follows the O'Reilly "risen bar" standard. It is easy to scan through the entire reference flipping pages as quickly as possible so that you are able to arrive at your sought information within as much as a second or two. The bold text draws your eye to the page and the size of the page allows one to capture everything in a single glance. In my usage of the book, I found it very accurate and useful. I am a regular MySQL user and the formatting is very familiar to me. I highly recommend this book. If you are already familiar with SQL and the basics of database schema design, this is the perfect reference. I found it amazingly faster than loading the MySQL PDF manual and searching through potentially dozens of hits for the keywords sought. Even at the full cover price, this book is a value-added service at my side. The sections on operators, functions, stored procedures and triggers make this book an invaluable tool for the DBA or programmer who knows the material, but fails to remember every single aspect about the syntax AND who is tired of seeing that familiar: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near..." The text also finds welcomed complement from the numerous examples of using commands and SQL keywords. They are invaluable for immediately deciphering the sometimes too-numerous options of a command. I don't know that the book has taught me anything new at this point, but it certainly makes finding the details of what I already know much easier. Because of its brevity and its ease-of-use, it has made me want to play around with some of the various features of MySQL that I do not regularly use. That alone is going to teach me something new sooner or later! If your budget is constrained to a single reference item on MySQL, you can't go wrong with this very portable pocket reference. The back cover says: "When you reach a sticking point, but have to get to a solution quickly, MySQL Pocket Reference is the book you need." I agree completely.

for more information click here

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.

for more information click here

Good no-fluff reference and read

I've always liked O'Reilly books, and this is no different. It's a small no-fluff reference that makes for a good read as well. The book is physically small enough to fit unobtrusively in your laptop bag without causing too much of a bulge.

Since it is written as a pocket reference, it of course doesn't have all the commands or even all the variants/options for commands. What is does have are the commands and syntax that you are likely to use the most with some good examples.

Just know what you are and are NOT getting. It's not a bible, a step-by-step, or a cookbook. It is (as it is labeled) a pocket reference, at which it excels. Highly recommended.

for more information click here

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.

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.

for more information click here

reviews: page 1, 2

hot