Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Managing and Using MySQL (2nd Edition) 2nd Edition

3.3 out of 5 stars 14 customer reviews
ISBN-13: 063-6920002116
ISBN-10: 0596002114
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used On clicking this link, a new layer will be open
$7.50 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$39.99 On clicking this link, a new layer will be open
More Buying Choices
31 New from $2.14 43 Used from $0.01
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Save Up to 90% on Textbooks Textbooks
$39.99 FREE Shipping. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

  • Managing and Using MySQL (2nd Edition)
  • +
  • Database Processing: Fundamentals, Design, and Implementation (13th Edition)
Total price: $263.41
Buy the selected items together

Editorial Reviews

About the Author

Tim King has been working with computers since the early 1980s, when he programmed games on his Commodore 64 computer and founded a computer club in his high school. He earned a bachelor's degree in computer science from the University of Minnesota Institute of Technology in 1991. While there, he taught Unix and vi classes and was the leader of a rag-tag group of vi devotees called the "VI Zombies." Presently, Tim is a software consultant in San Francisco, CA, specializing in database and web technologies. His favorite activity is snowboarding, but he also enjoys photography and reading. You can reach him at kingt@verio.com

George Reese has taken an unusual path into business software development. After earning a B.A. in philosophy from Bates College in Lewiston, Maine, George went off to Hollywood where he worked on television shows such as "The People's Court" and ESPN's "Up Close". The L.A. riots convinced him to return to Maine where he finally became involved with software development and the Internet. George has since specialized in the development of Internet-oriented Java enterprise systems and the strategic role of technology in business processes. He is the author of Database Programming with JDBC and Java, 2nd Edition and the world's first JDBC driver, the mSQL-JDBC driver for mSQL. He currently lives in Minneapolis, Minnesota with his wife Monique and three cats, Misty, Gypsy, and Tia. He makes a living as the National Practice Director of Technology Strategy for digital@jwt in Minneapolis.

NO_CONTENT_IN_FEATURE


Like this book? Find similar titles from O'Reilly and Partners in our O'Reilly Bookstore.

Product Details

  • Paperback: 442 pages
  • Publisher: O'Reilly Media; 2 edition (April 2002)
  • Language: English
  • ISBN-10: 0596002114
  • ISBN-13: 978-0596002114
  • Product Dimensions: 7 x 1.1 x 9.2 inches
  • Shipping Weight: 1.4 pounds (View shipping rates and policies)
  • Average Customer Review: 3.3 out of 5 stars  See all reviews (14 customer reviews)
  • Amazon Best Sellers Rank: #1,317,513 in Books (See Top 100 in Books)

More About the Author

I am the CTO of enStratus Networks (http://www.enstratus.com), the leading cloud infrastructure management vendor for enterprise clouds. Based in Minneapolis, MN, I co-founded enStratus as a spin-off from a company in the middle of moving into the cloud, Valtira. I was the primary architect of the enStratus software as well as the Open Source cloud abstraction API for Java, Dasein Cloud (http://dasein-cloud.sf.net).

My professional career began in Hollywood working on TV shows like the People's Court and ESPN Up Close, but my "Internet Career" started in 1991 developing Open Source online gaming software, specifically the Nightmare and Dead Souls mud libraries. I got involved with Java in 1995 and wrote my first book, Database Programming with JDBC and Java in 1996.

Customer Reviews

Top Customer Reviews

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 ›
Comment 35 of 36 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback 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.
Read more ›
Comment 20 of 20 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback 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.
Comment 13 of 14 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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.
Comment 13 of 15 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Managing and Using MySQL (2nd Edition)
This item: Managing and Using MySQL (2nd Edition)
Price: $39.99
Ships from and sold by Amazon.com
Want to discover more products? Check out this page to see more: computing