Print Book $39.95
Print+PDF
$51.94
Print Book £28.50
By George Reese, Randy Jay Yarger, Tim King
With
Hugh E. Williams
April 2002
Pages: 442
ISBN 10: 0-596-00211-4 |
ISBN 13: 9780596002114
(Average of 4 Customer Reviews)
Learn how to use MySQL, a popular database product that supports key subsets of SQL on Linux and Unix systems. Using C/C++, Java, Perl, PHP, or Python, you can write programs to interact with a MySQL database, either as a stand-alone application or through a web page. This book covers the whole process, from installation to programming interfaces and database administration. It includes ample tutorial material and examples.
Full Description
This book has all you need to take full advantage of this powerful database management system. It takes you through the whole process from installation and configuration to programming interfaces and database administration. This second edition has a greatly enhanced administration chapter that includes information on administrative tools, server configuration, server startup and shutdown, log file management, database backup and restore, and database administration and repair. In addition, a new chapter on security describes data, server, and client-server security, while a chapter on extending MySQL provides an overview of MySQL internals and describes the use of MySQL user-defined functions.
If you know C/C++, Java, Perl, PHP, or Python, you can write programs to interact with your MySQL database. In addition, you can embed queries and updates directly in an HTML file so that a web page becomes its own interface to the database. Managing and Using MySQL includes chapters on the programming language interfaces, and it also includes a complete reference section with specific function calls for each language.
Also included in the reference section are references to the SQL language, and details of the MySQL system variables, programs, and utilities. New to the second edition is a reference to the internal MySQL tables, which will be of particular interest to those who want to work extensively with MySQL security.
Featured customer reviews
Managing & Using MySQL, 2nd Edition Review, June 06 2003
LOVE IT! Fanstastic review of use on OS X. Great examples. Very readable, but it didn't bog me down in BS. I was up an running quickly!
Managing & Using MySQL, 2nd Edition Review, March 25 2003
This book is much better than mSQL & MySQL versus errata, however, it still lacks in a number of areas, such as clear instruction on how to set up MySQL security and protection against intrusions. I like the section on Perl, though some as another reviewer noted, it would be helpful if more examples were included. Rather than spending a lot of time on the CGI module, they would have better invested it in giving us a working example of a well-commented database in Perl such as personal phone book or something similar with add, delete and update functionality and at least a simple search function. I found the manual on the mysql.com web page to be much more helpful/useful in getting the info I needed. On CGI.pm, I rely on Lincoln Stein's book. I'm certain that writing my own class or templates would be interesting to say the least, but when I have code to crank out, I want to know how to get through the basics. I found my SQL reference a better resource for general SQL since it compares MySQL with PostgreSQL, MS SQL, and Oracle.
If you're just getting started, this book can be helpful, but you'll still need the online docs from mysql.com to serve as a backup resource if you're going to get serious.
I must say at the least, I'm very happy with O'Reilly customer support. When I told them how crummy the first book was and how dissatisfied I was with the quality of the SQL books coming from O'Reilly, I was happy to hear them say they'd send me a free copy of the second version when it came out. Months later (on-time), without prompting, they did as they had promised. Also, as promised, the need for lots of errata dropped significantly (QA works - imagine that :)
Managing & Using MySQL, 2nd Edition Review, March 04 2003
Very, very poorly done with regard to Java and Windows environments. The download examples completely skip the Java chapter. This not the usual good quality I've found from 0'Reilly. I'll definitely look elsewhere and more closely at the content next time around.
Managing & Using MySQL, 2nd Edition Review, June 27 2002
Thanks for writting this book.
First of all, sorry for my English.
So far, my complain is that there is no database example came with the book so readers/learners can see actions in corresponding to what/commands used in the book. The examples downloaded from your website do not help on this concern.
Hope you have mysql database examples relates to what you wrote in the book. It is probably that the book is so good at materials explainations, guides...but there is no examples packaged with the book; I give 4/5 for contents.
Best regards,
- vu
Media reviews
"...clearly and succinctly written, and provides an excellent introduction to MySQL...If what you want to do is get a small database up and running in a minimum of time with a minimum of hassle, this is the book for you."
-- Mark, Dl51
"In this 425 page book O'Reilly has produced another winner."
--Paul Scott, The Journal of the Tuscon Computer Society, Feb 2003
"This is the book you'll want if you're faced with an implementation project and don't know where to start. The introductory chapters are an excellent tutorial on the open-sourced MySQL structural methods and query capabilities. Even if you've never worked with databases before, this is a clear-headed, non-hysterical approach that doesn't even require programming experience. And, if you're a well-heeled code geek, you won't feel left out. By the time you're into aspects of administration, directory, and replication servers, you'll feel like you're at home."--BookBytes, March 3, 2003
"What is particularly refreshing about MU's coverage is that even items which are not specifically about MySQL get a fair shake. For example, the chapter covering the use of PHP with MySQL provides a wonderfully clear and concise explanation on some key aspects such as security and sessions. If you are looking to embrace MySQL, it's worth considering 'Managing and Using MySQL.'"
--Paul Schneider, Compunotes
Read all reviews
- Table of Contents
- Index
- Examples
- Sample Chapter
- Colophon
- Register Your Book
- View/Submit Errata
- View/Submit Review
Got a Question?
 © 2008, O'Reilly Media, Inc. (707) 827-7000 / (800) 998-9938 All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners. |
About O'Reilly Privacy Policy Contacts Authors Press Room Jobs User Groups Academic Solutions Newsletters Writing for O'Reilly RSS Feeds |
Other O'Reilly Sites O'Reilly Radar Ignite Tools of Change for Publishing Digital Media Inside iPhone O'Reilly FYI makezine.com craftzine.com hackszine.com perl.com xml.com |
Sponsored Sites Inside Aperture Inside Lightroom Inside Port 25 InsideRIA |