Sams Teach Yourself MySQL in 21 Days [Paperback]

Mark Mazlakowski (Author)

Book Description

ISBN-10: 0672319144 | ISBN-13: 978-0672319143 | Publication Date: June 23, 2000 | Edition: Book & CD

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.

Editorial Reviews

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.

About the Author

A long-time developer, Mark Maslakowski is co-owner of ForeFront Solutions specializing in development of 3-tier applications. He designed, developed and implemented an N-Tier Capital Budget application using Visual Basic, Microsoft Transaction Server and MySQL, and has created several internet and intranet sites employing MySQL databases.

Product Details

• Paperback: 560 pages
• Publisher: Sams; Book & CD edition (June 23, 2000)
• Language: English
• ISBN-10: 0672319144
• ISBN-13: 978-0672319143
• Product Dimensions: 9 x 7.2 x 0.9 inches
• Shipping Weight: 2 pounds
• Average Customer Review: 2.8 out of 5 stars  See all reviews (28 customer reviews)
• Amazon Best Sellers Rank: #2,676,459 in Books (See Top 100 in Books)

More About the Author

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

Customer Reviews

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 - See all my reviews

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

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.

10 of 12 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 review is from: Sams Teach Yourself MySQL in 21 Days (Paperback)

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 ...

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

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

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.