- Paperback: 444 pages
- Publisher: O'Reilly Media; 2 edition (30 April 2002)
- Language English
- ISBN-10: 0596002114
- ISBN-13: 978-0596002114
- Product Dimensions: 23.4 x 17.9 x 2.7 cm
- Average Customer Review: 3.5 out of 5 stars See all reviews (2 customer reviews)
-
Amazon Bestsellers Rank:
117,696 in Books (See Top 100 in Books)
- #15 in Books > Computers & Internet > Computer Science > Databases > Databases & the Web
- #18 in Books > Computers & Internet > Computer Science > Databases > Applications > MySQL
- #31 in Books > Computers & Internet > Software & Graphics > Internet Applications > Web-server Software > UNIX & Linux Operating Systems
- See Complete Table of Contents
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
Product details |
More About the Author
Product Description
Amazon.co.uk Review
Managing and Using MySQL describes the installation, administration and programming of this hugely popular open source database manager. The main focus is on using MySQL in Web applications hosted on Linux or Unix. The book is based on MySQL 3.23. It’s aimed at programmers, but database design and the SQL language are explained from scratch, so it’s also suitable for Web developers who are beginners when it comes to databases.
The scene is set with a brief history of MySQL, explaining its position as a fast and generally free alternative to the fuller-featured commercial heavyweights like Oracle or DB2. Next comes an introduction to SQL, followed by three chapters on administration, covering configuration, data recovery, tuning, security and user management. There's a brief look at database design too. That accounts for around one third of the book. The rest is about programming with chapters on using MySQL from Perl, Python, PHP and Java, and a look at how to extend MySQL with user-defined functions written in C. The last part of the book is a reference section, covering SQL syntax and functions, along with the MySQL API in PHP, C, and Python.
This is an excellent book for getting started with MySQL as well as a convenient reference. It has a broad scope, which means it does not go deeply into the various topics. For example, those using PHP might be better off with a more specialist title like Web Database Applications with PHP and MySQL. On the other hand, Managing and Using MySQL is ideal for a general and highly accessible overview of what MySQL can do.--Tim Anderson
Geekboy, slashdot.org, July 2, 2002
"....Overall, the authors have an excellent introduction to SQL databases and MySQL...Rating 9/10."
Inside This Book
(Learn More)
Suggested Tags from Similar Products(What's this?)Be the first one to add a relevant tag (keyword that's strongly related to this product)
|
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
38 of 39 people found the following review helpful
Format:Paperback
I bought "Managing and Using MySQL" in the hope that it
would include more up-to-date information on administering
and maintaining a MySQL database than the book by Paul
Dubois, which is now two-and-half years old.
would include more up-to-date information on administering
and maintaining a MySQL database than the book by Paul
Dubois, which is now two-and-half years old.
I was disappointed. Although it constantly refers to new
features that are available in MySQL 4, it fails to cover
important features of the MySQL 3.23 series of releases
at all. Given that many installations and ISPs still
rely on MySQL 3.23.x, the emphasis on MySQL 4 is premature.
One glaring omission is the subject of replication, which
allows real-time mirroring of a database server for
load-sharing and/or live backup. Even Dubois, writing in
late 1999, knew this feature was imminent, but Reese and
colleagues don't even mention it in passing.
If you don't already have "MySQL" by Paul Dubois, buy that
instead. It is a much better book all round, covering all
of the major subjects in greater depth. If you do have the
Dubois book, and you're running a MySQL 3.23.x installation,
you won't gain much from "Managing and Using MySQL".
1 of 2 people found the following review helpful
Format:Paperback
A good, authoritative reference which will guide you from finding out about MySQL and getting it installed all the way to configuring it, locking down security and optimisation, all the way through to good database design and day-to-day usage.
Even once you've got your database up and running well, this book is an invaluable reference to have to hand, for those commands and their syntax that slip your brain. Well done O'Reilly, another quality title!
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
14 reviews
34 of 35 people found the following review helpful
A good book covering a lot of topics
9 Sep 2002
Format:Paperback
The title is not all together indicative of what the authors try to accomplish in this book. The book attempts to be both a tutorial and a reference for programmers and administrators. The book consists of four major parts. The first part is the Introduction, which contains chapters on MySQL in general, installation on Unix and Windows, SQL for MySQL, and general Database Administration. This is accomplished in less than eighty pages which makes for brief explanations, limited illustrations, and examples. The second part is the MySQL Administration. This part has chapters on Performance Tuning, Security, and Database Design. The third part is MySQL Programming. The chapters' topics include general database applications, Perl, Python, PHP, C API, Java, and extending MySQL. Part four is the MySQL Reference. SQL syntax for MySQL, MySQL data types, Operators and Functions, MySQL PHP API Reference, C Reference, and Python DB-API are the chapter topics included in this part.
The authors do not assume that the reader is knowledgeable about relational databases in general, SQL, or the related topics. For example, the chapter on SQL on MySQL does not just describe the subset of SQL-92 that MySQL supports, but rather it contains a tutorial on the SQL for the commands that MySQL supports. Chapter seven on Database Design contains a tutorial on taking a database to third normal form complete with Entity-Relationship diagrams, unique identifiers and relationships. In part four, the PHP chapter contains a mini-tutorial on PHP and a complete PHP application. While the level of thoroughness is nice in the sense that you do not have to refer to other volumes to comprehend the subject, it makes for some very intense reading because of the size of the book versus the topics covered.
Overall, I like the book as a general tool, however there are certain omissions, for example: there is no reference phpMyAdmin or WinMySQLadmin. These tools are very easy to use and helpful in working with MySQL. In addition, the topic of creating InnoDB or BDB tables for transaction support is not addressed. The explanation of granting privileges in MySQL was a little confusing. Some supporting illustrations or diagrams would be well received there. The book is fairly successful in covering its broad topic domain. In conjunction with the MySQL manual, the book should meet most of my needs, but if I were a full time database administrator, I would probably want a dedicated reference book.
20 of 20 people found the following review helpful
Good Introduction to MySQL - But Only an Introduction
6 Nov 2003
Format:Paperback|Amazon Verified Purchase
This book is clearly and succinctly written, and provides an excellent introduction to MySQL. It starts with a few pages on the history and philosophy behind MySQL, which is useful if you want to understand the advantages and disadvantages of MySQL relative to other options such as PostgreSQL or Oracle. It then follows with chapters on installation, with specific instructions for Solaris, Linux, and Windows; on MySQL's dialect of SQL (Structured Query Language); and on basic administration tasks such as configuration, startup and shutdown, logging, backup, and recovery. That's really all you need to get a basic database up and running, and it's all in the first 80 pages of the book.
Part II of the book covers more advanced administrative tasks, with chapters on performance tuning, security, and database design. This section of the book is weaker than the first section; while there's some useful introductory material on each of these topics, depth is lacking. For example, the discussion of putting a database into second normal form is misleading because it uses a table with only one field as the unique identifier, making it impossible to clearly illustrate the removal to a smaller table of fields that are dependent on only part of a (typically multifield) unique identifier. Also, some of the more advanced MySQL features which might be appropriate for this section are omitted.
Part III of the book, entitled "MySQL Programming", has sections accessing MySQL from Perl, Python, PHP, C, Java. These sections are mostly limited to information specific to MySQL that might not be found in general purpose documentation of these languages. For example, the PHP section documents the relevant function calls, since PHP uses different functions to access MySQL than it does to access, say, ODBC databases, while the Java section focuses on JDBC (Java Database Connectivity) driver configuration since the JDBC API is database independent.
Finally, there is a reference section and a good, complete index.
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. If you want more than an introductory level of detail and depth, though, you might look at other books; Leon Atkinson's "Core MySQL", for example, has more complete coverage, though the writing style is not as clear and direct.
13 of 14 people found the following review helpful
Excellent Reference But Not Much On Managment
18 Sep 2002
Format:Paperback|Amazon Verified Purchase
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.
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > MySQL
- Books > Computing & Internet > Databases > Applications > SQL
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Theory
- Books > Computing & Internet > Databases > Databases & the Web
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > UNIX & Linux
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
