If you use MySQL, you know why it's the world's most popular open source database: small, fast, and powerful, and so rich in features that no administrator or programmer can stay familiar with all of them. There are always some little-known commands and clauses that could help you become more efficient in your work if you could just keep them in mind. The problem is, you don't always have time to stop and thumb through an exhaustive reference when you're hard at work. If you need a quick reminder, the MySQL Pocket Reference can lead you straight to the answer you need to know to get the job done.
Easy to take and use anywhere, this little book provides instant reminders on how to use important MySQL functions in conjunction with key parts of the LAMP open source infrastructure. A complete reference to the MySQL version of SQL, this pocket guide also serves as a convenient companion to our large, in-depth volume, Managing and Using MySQL. The book covers installation of MySQL and includes a description of SQL commands, data types, operators, and functions. In this small book, you get a handy reference to the enormous feature set of MySQL, the dominant database in the open source world.
O'Reilly's Pocket References have become a favorite among programmers everywhere. By providing important details in a succinct, well-organized format, these pocket-sized books deliver just what you need to complete the task at hand. When you've reached a sticking point in your work and need to get to a solution quickly, the new MySQL Pocket Reference is the book you'll want to have.
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.
Great Reference book. Not to be used as a full tutorial but is great for a quick lookup reference. It is good for those of us who are using MySQL for the first time but have experience with other DB's like MSSQL or Oracle. I did notice one discrepancy with MySQL's reference guide. When creating a Foreign Key constraint, the pocket reference does not show that foreign key column must be part of an index. I definitely recommend this book.
5/12/2003
4.0
MySQL Pocket Reference Review
By AP
from Undisclosed
Comments about oreilly MySQL Pocket Reference:
exactly what the doctor ordered for working with mysql if you are a developer but not so much if you're an admin. (ie nothing about GRANT, REVOKE etc) Two strange ommissions is that it does not contain any entries for "RESTORE TABLE" or "BACKUP TABLE". The subtitle is "complete SQL reference and functions" and I suppose RESTORE and BACKUP are not really SQL, but they are still useful to a developer. Small whine about an otherwise good usefulness to cost ratio.
