Managing & Using MySQL, 2nd Edition
Open Source SQL Databases for Managing Information & Web Sites
Publisher: O'Reilly Media
Released: April 2002
Pages: 444

MySQL is a popular and robust open source database product that supports key subsets of SQL on both Linux and Unix systems. MySQL is free for nonprofit use and costs a small amount for commercial use. Unlike commercial databases, MySQL is affordable and easy to use. This book includes introductions to SQL and to relational database theory. If you plan to use MySQL to build web sites or other Linux or Unix applications, this book teaches you to do that, and it will remain useful as a reference once you understand the basics. Ample tutorial material and examples are included throughout.

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.

Table of Contents
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
O'Reilly MediaManaging & Using MySQL, 2nd Edition
 
3.3

(based on 4 reviews)

Ratings Distribution

  • 5 Stars

     

    (1)

  • 4 Stars

     

    (1)

  • 3 Stars

     

    (1)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (1)

Reviewed by 4 customers

Sort by

Displaying reviews 1-4

Back to top

 
5.0

Managing & Using MySQL, 2nd Edition Review

By A$

from Undisclosed

Comments about O'Reilly Media Managing & Using MySQL, 2nd Edition:

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!

 
3.0

Managing & Using MySQL, 2nd Edition Review

By Kevin

from Undisclosed

Comments about O'Reilly Media Managing & Using MySQL, 2nd Edition:

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 :)

 
1.0

Managing & Using MySQL, 2nd Edition Review

By nyb

from Undisclosed

Comments about O'Reilly Media Managing & Using MySQL, 2nd Edition:

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.

 
4.0

Managing & Using MySQL, 2nd Edition Review

By vu

from Undisclosed

Comments about O'Reilly Media Managing & Using MySQL, 2nd Edition:

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

Displaying reviews 1-4

Back to top

 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $31.99
Formats:  DAISY, ePub, Mobi, PDF
Print & Ebook: $43.99
Print: $39.99