MySQL Pocket Reference

By George Reese
February 2003
Pages: 94
Series: Pocket References
ISBN 10: 0-596-00446-X | ISBN 13: 9780596004460
starstarstarstarstar (Average of 2 Customer Reviews)

This book has been updated—the edition you're requesting is OUT OF PRINT. Please visit the catalog page of the latest edition.

The latest edition is also available on Safari Books Online.

Description

Easy to take and use anywhere, the MySQL Pocket Reference provides instant reminders on how to use important MySQL functions in conjunction with key parts of the LAMP open source infrastructure. 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.
Full Description

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.



Featured customer reviews

Write a Review


MySQL Pocket Reference Review,  January 23 2004
Rating: StarStarStarStarStar
Submitted by Dominic   [Respond | View]

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.


MySQL Pocket Reference Review,  May 12 2003
Rating: StarStarStarStarStar
Submitted by AP   [Respond | View]

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.



Read all reviews


Media reviews
"...this first edition would be of value to anyone using MySQL. In essence, MySQL Pocket Reference is neatly organized, extremely portable, and packs much valuable information into a succinct format. "
-- Michael J. Ross, Web Developer, Slashdot.org


"[Consumers] will find the fine 'pocket references' produced by O'Reilly to be compact and affordable."
-- James Cox, The Computer Shelf: Midwest Book Review



Read all reviews

See larger cover


"...packs a substantial amount of useful information into a diminutive form."
--Michael J. Ross, Web Developer, Slashdot.org