Programming Books C Java PHP Python Learn more Browse Programming Books
MySQL: The Complete Reference and over one million other books are available for Amazon Kindle. Learn more
Qty:1
  • List Price: $46.00
  • Save: $17.40 (38%)
FREE Shipping on orders over $35.
Only 1 left in stock (more on the way).
Ships from and sold by Amazon.com.
Gift-wrap available.
FREE Shipping on orders over $35.
Used: Acceptable | Details
Condition: Used: Acceptable
Comment: Great buy on a reading copy with significant cosmetic wear to covers, pages, and binding. May not include CD/DVD as issued. Ships directly to you with tracking from Amazon's warehouse - fast, secure and FREE WITH AMAZON PRIME.
Access codes and supplements are not guaranteed with used items.
Have one to sell? Sell on Amazon
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

MySQL(TM): The Complete Reference Paperback – December 18, 2003

ISBN-13: 078-3254040199 ISBN-10: 0072224770 Edition: 1st

Buy New
Price: $28.60
20 New from $23.25 32 Used from $0.37
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$28.60
$23.25 $0.37
Best%20Books%20of%202014

Frequently Bought Together

MySQL(TM): The Complete Reference + Guide to UNIX Using Linux (Networking (Course Technology))
Price for both: $181.81

Buy the selected items together
NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Series: Osborne Complete Reference Series
  • Paperback: 544 pages
  • Publisher: McGraw-Hill Osborne Media; 1 edition (December 18, 2003)
  • Language: English
  • ISBN-10: 0072224770
  • ISBN-13: 978-0072224771
  • Product Dimensions: 7.4 x 1.3 x 9.1 inches
  • Shipping Weight: 2 pounds (View shipping rates and policies)
  • Average Customer Review: 3.5 out of 5 stars  See all reviews (8 customer reviews)
  • Amazon Best Sellers Rank: #131,802 in Books (See Top 100 in Books)

Editorial Reviews

Review

From the Computer Media column by Rachel Singer Gordon

...perennially popular open-source companions for creating database-driven web sites. These guides cover MySQL, as well as its use with PHP and other languages...Complete Reference tries to be all things to all people, covering topics from an introduction to relational databases and installing and configuring MySQL to reference material for administrators, but is most appropriate for new and intermediate users. Sidebars and notes add info and link to additional resources, while a welcome thoroughness and clarity make this a good, basic purchase for all libraries. (Library Journal)

From the Back Cover

The Most Authoritative Resource on the MySQL Database Available! Reviewed by the MySQL Development Team.

Get the most out of the MySQL database server--today’s most popular open source database--with help from this definitive guide. Take advantage of MySQL’s cross-platform support, independent storage engines, advanced permissions and security system, query caching, full-text indexing and searching, and much more. Reviewed by the MySQL database development team, MySQL: The Complete Reference explains in full detail how to use this customizable RDMS to support robust, reliable, mission-critical applications.

  • Install, configure, and test a MySQL database on Linux/UNIX or Windows
  • Use MySQL data types, statements, operators, and functions
  • Manage databases and tables with the Data Definition Language (DDL)
  • Add, delete, and query records using the Data Manipulation Language (DML)
  • Take advantage of transactional support
  • Implement MySQL’s five-tiered access control and privilege system
  • Handle database optimization, backup, recovery, and replication
  • Create applications in C, C++, Perl, Java, PHP, and other languages
Vikram Vaswani is the founder and CEO of Melonfire, a company specializing in Web design, development, and content creation for a variety of clients. He has also written extensively on open source technologies, including MySQL, Perl, Python, and PHP.

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

3.5 out of 5 stars
Share your thoughts with other customers

Most Helpful Customer Reviews

20 of 20 people found the following review helpful By Brian D. Lang on January 28, 2004
Format: Paperback
I highly recommend anyone working with MySQL in any capacity to pick up a copy of MySQL: The Complete Reference; it's the most thorough, easy to follow, well laid out book on the subject I've seen (and I have several computer texts, many of which deal with MySQL in some way or other). Every facet of MySQL is covered: system admin, table types and structure, data types, basic to advanced SQL syntax. There are sections dealing with new features in v4.1 (still considered under development as of this writing) such as subqueries (which are going to be a huge help) and other new methods for handling data. My favorite parts of the book are the nested sidebars that have tricks and tips for doing things in one of several different ways, most of which I've never seen before.
The most impressive feature of the book, in my opinion, is the balance between visual examples and technical detail. Usually you find a computer text is strong in one or the other; the author Vikram Vaswani has done an excellent job in illustrating his talent to show the end user exactly what he / she needs to see to understand the task at hand, not to mention his depth of knowledge on the subject. The book has MySQL's logo on it for a reason, people.
I had personally put off purchasing a book on MySQL, instead relying on online documentation and tutorials. When I realized I wasn't moving in the right direction, I took a look at several available texts and chose this one. Even though I've been working with MySQL for over a year, after having read a majority of the book, I can honestly say I've easily doubled my understanding of syntax and the inner workings of MySQL in the past two weeks.
Read more ›
Comment 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
3 of 3 people found the following review helpful By P. N. Payne on April 17, 2005
Format: Paperback Verified Purchase
I've learned a lot from Vaswani. I think he has done an outstanding job of cataloging and summarizing MySQL. You can go to the very good index and find a few references, then find what you need. To me, a good index is a top priority, & Vaswani did a pretty good job with the index.

I did find a few subjects which need more depth, but most subjects were covered well enough to answer my questions.

This 4 star rating is from the perspective of a beginning to intermediate web application developer. My purpose in buying this book was to get from a basic SQL knowledge (via a local community college Oracle class) to a better understanding of MySQL, to use with PHP etc. I am not a systems administrator and have no desire to be one. Just wanted to use MySQL on a couple business projects, and MySQL Complete Reference has definitely helped.

I think it is an excellent choice for a beginning to intermediate LAMP or MySQL application developer. For an application developer, I highly recommend it.
Comment 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
Note: This book only covers through MySQL 4.1, so I would recommend another book if you plan on moving to MySQL 5.0 or higher (which you should).

This is a good introduction for MySQL users who have not read through a MySQL book before, and need somebody to help them work through reasonably complicated concepts in plain English. It's also a good book for people who have worked through online documentation but want to integrate the bits and pieces they've picked up from other places.

It has copious and easy-to-follow examples, and if you read it through, you will become confident using MySQL's basic and intermediate functionalities.

This book is not as good when it gets to more advanced topics. Part of that is due to the fact that it only covers MySQL through version 4.1, so many of the more advanced features in verison 5.0 like stored procedures and triggers are not covered at all (nor is the mysqli extension for PHP covered in the PHP section of the book). Also, a number of features that were available in 4.1, like transactions, are not covered in enough detail. For example, while a basic example of a transaction is given, I don't think that this book contains enough real-world examples for determining what specific transaction isolation level one would choose in a given circumstance. The discussion of isolation levels relies on theoretical graphs instead.

For a current purchaser, I'd give this 3 stars - good for a beginner or intermediate reader, not as good for an advanced reader. I would give it 4 stars but it's out of date so I wouldn't recommend it for most current purchasers.
Comment 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 Verified Purchase
I am very pleased with how I was able to

purchase this text for an affordable price

here at Amazon. Thank you for making this

possible!
Comment 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