MySQL [Paperback]

Michael Kofler (Author)

Book Description

ISBN-10: 1893115577 | ISBN-13: 978-1893115576 | Publication Date: June 2001 | Edition: 1

MySQL by Michael Kofler is a comprehensive guide to MySQL, providing a thorough introduction to the installation, configuration, implementation, and administration of the worlds most popular open source database server. Kofler includes coverage of transactions with BDB, InnoDB, and Gemini tables, and outlines the installation of Apache, MySQL, PHP, and Perl for both Linux and Windows systems. With an eye to those issues most important to MySQL users, Kofler adds to his coverage of the server by focusing on its use in conjunction with various technologies that make database information accessible over the Web, including PHP, Perl, and ODBC.

Editorial Reviews

About the Author

Michael Kofler holds a Ph.D. in computer science from Graz Technical University in Austria. He has written a number of successful computer books on topics such as Visual Basic, Visual Basic .NET, and Linux. Michael is the author of The Definitive Guide to MySQL 5, Third Edition and Definitive Guide to Excel VBA, Second Edition from Apress.

Product Details

• Paperback: 659 pages
• Publisher: Apress; 1 edition (June 2001)
• Language: English
• ISBN-10: 1893115577
• ISBN-13: 978-1893115576
• Product Dimensions: 9 x 7.2 x 1.5 inches
• Shipping Weight: 2.8 pounds (View shipping rates and policies)
• Average Customer Review: 5.0 out of 5 stars  See all reviews (7 customer reviews)
• Amazon Best Sellers Rank: #2,520,249 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

56 of 58 people found the following review helpful:

5.0 out of 5 stars many samples, compact SQL reference, up to date, July 19, 2001

By A Customer

This review is from: MySQL (Paperback)

what I liked most at this book is the sample-oriented approach: the books starts with the setup of a WAMP/LAMP system; in the next chapter, the first 'real' application is presented: a simple web opinion poll (using PHP); thus, after only 80 pages I had a running test environment and my first application to work with

examples are also omnipresent in the following chapters: the chapter on MySQL user interfaces explains how to configure and use phpMyAdmin; relations, normalization and other ideas of good database design are explained by showing the design process for two databases (a books database and a database for a discussion forum); the chapter on SQL shows how to query these databases;

next is programming: the book explains how to build MySQL applications using PHP, Perl and VB (all databases and samples are available for download at the author's website)

the book also covers new MySQL features which have been added only recently: transactions with BDB, InnoDB and Gemini, full-text queries etc.

perhaps the only shortcoming is in the programming part: while the author covers PHP, Perl and VB (via ODBC), he mentions neither Java nor C/C++

overall, this is by far the most useful and up-to-date MySQL book I know of

66 of 72 people found the following review helpful:

5.0 out of 5 stars Saved my you-know-what, February 27, 2003

By 

Ms. Mary R. Sweeney "M. R. Sweeney 'book lover" (Issaquah, WA United States) - See all my reviews
(REAL NAME)   

This review is from: MySQL (Paperback)

I committed to doing a MySQL project because it was less expensive overall for my client than using software I'm more familiar with (I'm not naming names but let's just call them SQL Server and .Net). I'm very experienced creating databases but brand new to MySQL and PHP. I don't know how I would have survived without Kofler's book. He not only explains everything step-by-step but in a very relevant, clear way. I had several other books in my arsenal and found I dropped all of them when I needed to look something up and just used Kofler all the way. Everything I needed to do, he had an example for in his demo files!

I know from experience how frustrating it can be not to have the right resources available. Although there are some great user's groups and so on, Kofler's book saved me a ton of time because I found pretty much everything in his book. Using his book and the free, on-line PDF MySQL manual is all you'll need to do a complex business application for the web.

Thanks Kofler. You're my hero!

16 of 17 people found the following review helpful:

5.0 out of 5 stars Very clear! Best book I found on MySQL, October 17, 2002

By 

They Call Me Trinity (Des Moines, IA USA) - See all my reviews

This review is from: MySQL (Paperback)

This book covers both UNIX/LINUX and Windows for almost every topic - I really like that especially since we run a mixed environment and I'm wanting to learn more LINUX.

I'm a Windows user who needed to setup MySQL that was required by a free message board [;ocal website]). This book made the MySQL portion of the install extremely easy and covered all of the topics I needed to know to setup MySQL in a Windows environment. He covered all the "gotchas" with both Windows and UNIX/LINUX platforms - nice! It also covers setting up and interfacign with PHP, Apache and other system "components" - which really helped me to deploy my message board project.

I enjoyed his writing style so much, I found myself reading the book front to back, versus looking up specific topics - that doesn't happen very often with these types of technical books.

The information is up to date, even though it's over a year old. I checked out the top 3 MySQL books out there and this one was my favorite for getting started clear through advanced usage - there is not a lot of "fluff" - just a clear writing style hitting all the topics.