Print Book $39.95
Print Book £28.50
By George Reese, Randy Jay Yarger, Tim King
With Hugh E. Williams
Second Edition
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.
Register your book | Submit Errata | Examples
Browse within this book
Cover | Table of Contents | Index | Sample Chapter | Colophon
Book details
Second Edition: April 2002
ISBN: 0-596-00211-4
Pages: 442
Average Customer Reviews: (Based on 4 Reviews)
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
"'Managing & Using MySQL' is an ideal book for beginner MySQL users and developers. The author does a good job of getting the concepts across on a basic and beginner level. With chapters on installation and initial set up, author George Reese takes the reader from square one into the sometimes-scary world of SQL programming...To have your data being served securely and quickly is the best of both worlds, and this book certainly helps show the MySQL developer how to accomplish both...'Managing & Using MySQL' is the book of choice for the new user of this open source database tool. Also, it is valuable to the intermediate DBA who may have taken over some MySQL databases in helping them tune the product and make it secure. This book should be on the shelf as a resource for anyone who needs general MySQL knowledge."
--Peter MacIntyre, eweek, Feb 6, 2003
"To get up to speed, I recommend starting, as ever, with the manuals from O'Reilly & Associates (specifically, 'Managing and Using MySQL' and 'MySQL Reference Manual'). You may be surprised by the richness of what you find."
--Andrew Binstock, Software Development Times, Nov 2002
"An excellent introduction and desktop reference for MySQL. Coming from the world of commercial relational database software, this book really opened my eyes to the power--sheer speed--available from MySQL. I plan to put it to use immediately!...MySQL definitely has my attention now, after reading this excellent book from O'Reilly & Associates...I highly recommend this book to anyone wanting to learn about database development or thinking of moving from commercial relational databases to open source software. With open source development growing there will be more and more demand for open source relational databases. I for one plan to utilize MySQL in my next web development project!"--Steve Mitchell, KCJava.org, August 17, 2002
"The authors presented enough information that I was able to write programs that interfaced with MySQL in less than 10 minutes...Overall, the authors have an excellent introduction to SQL databases and MySQL. Full examples are included for each topic, with full explanations...the only thing you need to make a usable database. Rating 9/10."
--Geekboy, slashdot.,org, July 2, 2002
"If you could have only one MySQL manual, this might be a good choice. The information is very practical and well presented, and the examples are reasonably easy to follow."
--Roger Walker, The Edmonton Linux User Group, April 8, 2003
