Amazon.com: Sams Teach Yourself MySQL in 21 Days: Mark Mazlakowski: Books

Editorial Reviews

Product Description
Sams Teach Yourself MySQL in 21 Days teaches you to design and implement your own open source database. Topics include: Designing and Creating your First Database, Normalizing your Data, Adding Tables, Columns, and Indexes, MySQL Data Types, Importing and Exporting Data, Locks and Keys, Building a MyODBC Interface, Building a Perl Interface, Letting MySQL Do the Work - Intrinsic Functions, MySQL Database Security, How MySQL Compares, Administering MySQL, Optimizing MySQL, and Troubleshooting MySQL.

From the Back Cover
Sams Teach Yourself MySQL in 21 Days teaches you to design and implement your own open source database. Topics include: Designing and Creating your First Database, Normalizing your Data, Adding Tables, Columns, and Indexes, MySQL Data Types, Importing and Exporting Data, Locks and Keys, Building a MyODBC Interface, Building a Perl Interface, Letting MySQL Do the Work - Intrinsic Functions, MySQL Database Security, How MySQL Compares, Administering MySQL, Optimizing MySQL, and Troubleshooting MySQL.

See all Editorial Reviews

Look Inside This Book

Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover

Tag this product

(What's this?)

Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items.

Help others find this product — tag it for Amazon search

No one has tagged this product for Amazon search yet. Why not be the first to suggest a search for which it should appear?

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

Customer Reviews

27 Reviews

5 star:		(6)
4 star:		(3)
3 star:		(2)
2 star:		(8)
1 star:		(8)

Average Customer Review

2.7 out of 5 stars (27 customer reviews)

Share your thoughts with other customers:

Create your own review

Most Helpful Customer Reviews

24 of 29 people found the following review helpful:

2.0 out of 5 stars Poorly edited, poorly designed, and poorly put together, July 11, 2000

By	Jeffrey Papen (San Francisco, CA United States) - See all my reviews

Don't buy this book. Go buy "MySQL" by Michael Widenius (New Riders Publishing). It's the best MySQL book out there. The O'Reilly Netshell book by Yarger, Reeses, and King is second. This book is a *distant* third out of three.

I was shocked at the number of typos and other editing errors. I found many of the sections to be poorly glossed over. A good example would be db backups. The first, last and most important thing any DBA should know is how to backup data and restore that data.

The section on backups was cursory and lacking important details. --log-update was mentioned for incremental backups, but how/when the logs should be flushed wasn't metioned. I would have preferred to see an entire crontab, incremental+full backup sequence including a restore from one day or a restore of the entire data.

Another very light brushing over was optimization. At least one paragraph could have been spent to give the user ideas on how MySQL will benefit from putting logs, tables, and indices on multiple disks, rather than dismissing the reader to go research somewhere else. The auhor had another excellent opportunity to help the reader understand how queries are handled by a deeper discussion on optimizing the WHERE clause in queries. But this section received less than half a page and delt only with the unlikely situation of a single index being searched on.

The coverpage reads, "Learn the skills and conepts to *master* MYSQL...". This is a gross overstatement of what this book will give you. I would have sent it back to Amazon.com if working out the shipping wasn't such a pain. Not worth the money. You would better spend your time throwing playing cards in a hat.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

9 of 11 people found the following review helpful:

2.0 out of 5 stars CODE ALL WRONG, February 24, 2001

By	jan jansens (Louvain, Belgium) - See all my reviews

This book just doesn't live up to half of my expectations. The author just says : do this, do that whithout a lot of explanation. Furthermore, the CODE is ALL WRONG in this book. I like the other 'STY in 21 days' books but I'm sorry I bought this one.

Wrong Code : p. 63 : INSERT INTO mysql... should be INSERT INTO host (see figure 4.6) p. 64 : INSERT INTO user... 'Y') should be INSERT INTO USER... 'Y'); p. 64 : INSERT INTO db ... 'Y') should be INSERT INTO db ... 'Y'); p. 79 : Smoker CHAR(0) should be Smoker ENUM('Y','N') DEFAULT 'N' (see figure 6.2) p. 82 : USE DATABASE Temp; should be USE Temp; p. 84 : DROP tablename; should be DROP TABLE tablename; p. 85 : DROP Customers should be DROP TABLE Customers; ... And I'm only at Day 6 ...

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

4 of 4 people found the following review helpful:

1.0 out of 5 stars Typos galore! Don't waste your money., June 9, 2002

By	Patrick F. Graham (Woodland Hills, CA United States) - See all my reviews

Typos galore

I know I'm throwing fuel on a bonfire, but this book [stinks]!

HUNDREDS of errors and misinformation. I tried to return the book but found out if I open the CD it is non-returnable.

The only reason I opened the CD was to get a file that WASN'T EVEN ON THE CD!

Next time I will read the reviews on Amazon first.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

Share your thoughts with other customers: Create your own review

› See all 27 customer reviews...

Most Recent Customer Reviews

2.0 out of 5 stars This is the second worst PC related book i've ever read
Two thirds of the book are about nothing. If the book was completed only on 100 or 150 pages ("the best of"), i could give 3 stars.. Read more

Published on October 23, 2003 by stibor

5.0 out of 5 stars easy to understand
This book doesnt waste time with all the little details and just talks about the major points. Want to be a MySQL guru? Then this books is NOT for you. Read more

Published on October 30, 2002

2.0 out of 5 stars CONFUSING
I thought that this book would teach me the basics of MySQL in a relatively short time. While I did learn some things, I spent most of my time figuring out how the author got from... Read more

Published on September 18, 2002 by Immanuel H Roth

1.0 out of 5 stars Too poor and illogical.
What this book is and what this book is not?
This is not a book neither mysql, nor sql language, nor database management. Read more

Published on March 29, 2002 by Renato Perini

3.0 out of 5 stars Good starter book, but tons of errors.
I have to say, I love the teach yourself series from SAMS. They are always a comforting way to learn a new computer language. Read more

Published on January 10, 2002 by Daniel C. Mcgauley

1.0 out of 5 stars Stopped counting typos and errors at 100
Unbelievably poor proofreading. I started seeing a couple of typos in the first chapter, and decided to highlight them so that I could let the publisher know, but now my book has... Read more

Published on January 2, 2002 by Nicholas Hamlin

1.0 out of 5 stars Very Poor Text
I learned about enough to convince those unfamiliar with MySQL that I know what I'm doing - although I don't!

The examples are full of mistakes. Read more

Published on December 10, 2001 by websmithsdesign

2.0 out of 5 stars Poorly written and full of errors
This book is poorly written (I can't believe an editor even looked at it!) and full of sloppy errors. Read more

Published on September 1, 2001 by Patrick Flanagan

1.0 out of 5 stars Are you trying to fool who?
First of all it's a pitty since normally all the PHP books are good, but this one has typos since chapter 1. Read more

Published on August 29, 2001 by The Vampmaster

4.0 out of 5 stars Great introduction, but not enough depth.
This book is a good read. Sit down with it for a few days, and afterwards, you should know a great deal about MySQL. Read more

Published on May 8, 2001 by sporkdude

› See all 27 customer reviews...

Product Information from the Amapedia Community

Beta (What's this?)

Be the first person to add an article about this item at Amapedia.com.

› See featured Amapedia.com articles

Look for Similar Items by Category

Books > Computers & Internet > Databases > Relational Databases
Books > Computers & Internet > Databases > SQL
Books > Computers & Internet > Databases > Specific Databases > MySQL & mSQL
Books > Computers & Internet > Programming
Books > Computers & Internet > Software > Databases

Shop Tool Storage in Home Improvement

Check out the huge selection of tool storage and organization products offered by Amazon.com.

›See more in the Power & Hand Tools Store

Best Books of 2008

Find our top 100 editors' picks as well as customers' favorites in dozens of categories in our Best Books of 2008 Store.

Get All You Need in One Pack

Combo packs offer an easy and affordable way to start your air tool collection. A variety of combo-pack options are available for any number of projects at prices you'll like.

›Explore combo packs