Managing & Using MySQL: Open Source SQL Databases for Managing Information & Web Sites
Conditions
An apparently unread copy in perfect condition.
Formats
Conditions
An apparently unread copy in perfect condition.
Conditions
An apparently unread copy in perfect condition.
Formats
Conditions
An apparently unread copy in perfect condition.
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.
This book was excellent for my need: I had used SQL before but didn't know much of anything about relational databases let alone MySQL. I am in the process of building a web application that reports survey data. It will tell you everything you need to know to get started with a small to mid-size database. Best of all, this book is well written, clear, the examples are GREAT and if you cut out the portions that are not relevant to you (for me this was security and the sections on PHP and Perl to name a few) you can literally learn all you need to know to get started in less than two weeks of studying for a few hours per day. Amazing value. The portions of the book on MySQL itself are not obviously dated, but the Python DB API interface has changed (to version 2.0) since this book was written.
This book covers MySQL at a good level of both depth and breadth. It weaves in a great combination of the history and philosophy behind design choices the MySQL development community made, and provides many examples of how to use MySQL in different languages.
The security chapter is well written and the reference section is comprehensive.
This book is an excellent reference book for MySQL. In fact I'd rate it the best MySQL reference out there when using MySQL as a coder. But if your looking for this book to tell you how to manage MySQL look on, this book is not for you! It's pretty weak in that area (as is the official MySQL documentation). But again, as a programmer I've found this book invaluable as a resource and would never be without it. I'd recommend it for novices and advanced users.
This book contains everything you will need to know about MySQL. As a MySQL DBA and developer, every time I've needed to look something up I've found it in this book. The chapter on security is comprehensive and the reference section is well-organized and concise.