Managing & Using MySQL and over one million other books are available for Amazon Kindle. Learn more
CDN$ 43.40
  • List Price: CDN$ 45.99
  • You Save: CDN$ 2.59 (6%)
Usually ships within 2 to 4 weeks.
Ships from and sold by Amazon.ca.
Gift-wrap available.
Quantity:1
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Managing & Using MySQL: Open Source SQL Databases for Managing Information & Web Sites Paperback – May 3 2002


See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
Paperback
"Please retry"
CDN$ 43.40
CDN$ 25.03 CDN$ 0.60

2014 Books Gift Guide
Thug Kitchen, adapted from the wildly popular web site beloved by Gwyneth Paltrow ("This might be my favorite thing ever"), is featured in our 2014 Books Gift Guide. More gift ideas

Special Offers and Product Promotions

  • Join Amazon Student in Canada


Customers Who Bought This Item Also Bought



Product Details

  • Paperback: 444 pages
  • Publisher: O'Reilly Media; Second Edition edition (May 3 2002)
  • Language: English
  • ISBN-10: 0596002114
  • ISBN-13: 978-0596002114
  • Product Dimensions: 17.8 x 2.7 x 23.3 cm
  • Shipping Weight: 612 g
  • Average Customer Review: 3.1 out of 5 stars  See all reviews (13 customer reviews)
  • Amazon Bestsellers Rank: #1,589,410 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

From Amazon

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

From the Publisher

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.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

3.1 out of 5 stars

Most helpful customer reviews

Format: Paperback
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.
Read more ›
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
Format: Paperback
I bought this book as a reference when I was migrating from SQL Server to MySQL. I was hoping to learn from this book some of the language implementations and how to administer on-line databases (backups, benchmarking, security). I found this book to be very lacking. The book provides very little of the language references of SQL, and devotes the majority of the text to function call references for C, Perl/DBI, PHP and Python. (I would think if you were looking for mysql function calls for these languages you would use the specific language reference). If you don't develop front-ends to MySQL in these languages (but still want to "Manage and Use MySQL") then the bulk of this book is probably useless to you.
As for managing MySQL, this text provides very little practical information. Sure it covers the GRANT statements, but doesn't go into much depth. For example, I found very little information about archiving or trying to incorporate some type of pseudo-replication.
In general, I notice that my book is still in fairly new condition, and doesn't get used much ... it is just an arm's reach away. I use the FREE online MySQL manual almost everyday. That should tell you something right there, huh.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
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.
Read more ›
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
Format: Paperback
This book is a significant improvement over the 1st edition (which was titled MySQL & mSQL), mainly because it focuses directly on MySQL instead of focusing on the differences between MySQL and mSQL. This book leaves out critical information, which is why I gave it only 2 stars. The word REPLICATION isn't even in the book's Index (I skimmed the book and didn't see it covered anywhere in the text either), and MySQL's Replication Functionality is one of its most valuable features for fault tolerance! Also, the book is ambiguous on other Fault Tolerance issues. For example, on page 74 the book says to "store the binary logs on the same device as the backups". Binary logs are generated real-time as incremental updates between the nightly dumps - the book makes no effort to explain how to replicate those logs real-time to a separate server. If you're going to buy only one book on MySQL, I'd suggest Atkinson's book: core MySQL.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.

Most recent customer reviews



Feedback