Sams Teach Yourself MySQL in 21 Days (2nd Edition) [Paperback]

Anthony Butcher (Author)

Book Description

ISBN-10: 0672323923 | ISBN-13: 978-0672323928 | Publication Date: December 27, 2002 | Edition: 2

MySQL is the most widely installed open-source database. Approximately 3.5 million MySQL servers are in use and more than 45% of databases used on Linux worldwide are MySQL databases.

Its latest version, MySQL 4.1 closes the gap between MySQL and other, more sophisticated databases. Version 4.1 permits the use of MySQL as an embedded database, which means it can be compiled into another application and used in a range of devices.

The second edition of Sams Teach Yourself MySQL in 21 Days has been completely rewritten by a new author. The book enables a reader to create powerful databases using MySQL. He willnot only learn how to integrate MySQL into a database-driven Web site, but also how to embed MySQL into other compiled applications.

Editorial Reviews

About the Author

Tony Butcher is a consultant for Tribal Internet. The company develops database-driven Web sites using MySQL, with PHP and other languages. He also takes on specialist MySQL consulting work and has installed, developed, repaired and tuned MySQL systems for over five years.

Having first encountered MySQL in 1997, he quickly recognised it as a powerful tool for enterprise-level systems. Since then has he used it in several mission-critical, heavy-load online databases.

Tony is an occasional contributor to newspapers and trade magazines, writing on various topics relating to computing and the Internet. He also co-authored the first edition of this book.

Product Details

• Paperback: 640 pages
• Publisher: Sams; 2 edition (December 27, 2002)
• Language: English
• ISBN-10: 0672323923
• ISBN-13: 978-0672323928
• Product Dimensions: 9.2 x 7.2 x 1.4 inches
• Shipping Weight: 2.4 pounds (View shipping rates and policies)
• Average Customer Review: 3.2 out of 5 stars  See all reviews (4 customer reviews)
• Amazon Best Sellers Rank: #173,175 in Books (See Top 100 in Books)
  • #99 in Books > Computers & Technology > Databases > SQL

More About the Author

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

Customer Reviews

Most Helpful Customer Reviews

5 of 5 people found the following review helpful:

5.0 out of 5 stars An Excellent Primer and More, July 21, 2003

By 

Ray Varley (Worcester UK) - See all my reviews

This review is from: Sams Teach Yourself MySQL in 21 Days (2nd Edition) (Paperback)

The book is aimed at the beginner/intermediate level, which I think is about right. Readers at both levels would benefit significantly from this well written and easily read volume.

Each chapter gives you a `kick start' in that aspect of MySQL starting at a basic level and progressing to a stage where you have a very useful knowledge.
The chapters on Querying Data for example take you to a point where you (as an intermediate user) could do most everyday queries.

This is achieved by using straightforward examples with carefully graded and well explained steps. I never felt too pushed nor felt I was being patronised - quite an achievement.

What I particularly liked were the chapters on interfacing with the real world.
The chapter on PHP does not pretend to be a primer on PHP but does introduce the few functions in PHP which allow you to write to and query a MySQL database, retrieve the results and present them to the rest of your PHP code - just what a PHP coder needs from a book on MySQL. This is repeated for those who need to interface with C and PERL.

I would unreservedly recommend this book to anyone starting out in MySQL.

6 of 7 people found the following review helpful:

3.0 out of 5 stars Check examples please., May 2, 2003

By 

"derekschramm2" (Roseville, MN United States) - See all my reviews

This review is from: Sams Teach Yourself MySQL in 21 Days (2nd Edition) (Paperback)

It was missing alot of information in the area of new users and granting privileges. Quotations marks were left out of key commands to grant privileges and there are limits...There were misspellings of words. The book should have gone through spellcheck and a thorough test of examples.
I would rate this book lower but I admit, it helped me get started. If I didn't have teaching and other data processing experience I would be bald trying to follow this book.

1 of 1 people found the following review helpful:

4.0 out of 5 stars Great starter book on MySql, July 17, 2005

By 

D. Trent (Virginia) - See all my reviews

This review is from: Sams Teach Yourself MySQL in 21 Days (2nd Edition) (Paperback)

This is the best starter book on MySql that I've read and I've read quite a few. Start with this one.