MySQL and mSQL Paperback – Jul 11 1999
There is a newer edition of this item:
No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
To get the free app, enter your e-mail address or mobile phone number.
MySQL and mSQL provides the essentials to programming with these two popular Unix freeware database packages in C/C++, Perl, Python, and Java. The book begins with a fine introduction to databases that covers tables, fields, indexes, and normalization. Then it explains the history of the freeware mSQL and MySQL packages (which offer better performance than commercial relational database management system (RDBMS) packages, though they don't support transactions or other features). Next the authors look at SQL as used within MySQL and mSQL and clarify where to download these packages and how to install them. Examples of how to program with MySQL/mSQL in C/C++ follow.
One of the best parts of this book is its introduction to using Common Gateway Interface (CGI) and Perl to power a Web site with a MySQL/mSQL database. This section offers complete information on using mSQL Perl (and the emerging Database Independent [DBI] standard) for developing CGI database scripts in Perl, and it includes clear examples (including a student database). The book then moves from Perl on to other programming languages--Python and Java. Reference material to all the relevant APIs is featured for each language.
Whatever programming API you choose, MySQL and mSQL are ready to meet the needs of the small to moderate-size Web site. This book delivers essential information on these packages and will help both Web masters and programmers get the most out of these powerful freeware database tools. --Richard Dragan
From Library Journal
Using a database is the ony way to assure that a web siteAeven a small web siteAwill scale as Internet traffic grows. MySQL & mSQL are two very popular databases for those small sites, first because they are comparatively easy to use and second because they are freeware designed for Linux and UNIX systems. Yarger's book is a great tutorial; covering both programs it is sure to be in demand in public and undergraduate libraries. It is not really appropriate for database beginners, but it will serve intermediate users and is an excellent technical guide for those who already know SQL but don't know MySQL & mSQL.
Copyright 1999 Reed Business Information, Inc.
Top Customer Reviews
It also serves as a pretty good reference for both servers (though, by no means a complete one). It explains some database building basics, as well as what 2NF and 3NF mean (and how to make your database 3NF). It contains several useful chapters on different APIs to MySQL and mSQL including a very helpful introduction to the Perl DBI.
I still find the reference pages pretty helpful, but for people looking for an advanced reference, I'd say look elsewhere (perhaps "Managing and Using MySQL" (ASIN 0596002114)).
If you're just learning SQL or MySQL, this is a great book!
Instead of this book, I would go with:
The Practical SQL handbook- for general learning about SQL
MySQL by Paul DuBois
and depending on whether you plan to use PHP or Perl:
MySQL and Perl for the Web by Paul DuBois
PHP and MySQL Web Development by Luke Welling and Laura Thomson
Even when you finish to read this book
it will serve you as good SQL (mSQL and MySQL dialects) reference.
Conclusion: this is your first MySQL book! I think the second will be MySQL Reference Book.
Most recent customer reviews
I have had this book for 3 years now and it is still on my "easy-access bookshelf". I use MySQL and can't comment on the mSQL portion. Read morePublished on Nov. 24 2003 by Amazon Customer
Do NOT buy any other book on MySQL. You will end up tossing others aside and buying this one. As others have said, chapter 2 gives the absolute best discussion of normalization... Read morePublished on Oct. 28 2003
Look for similar items by category
- Books > Computers & Technology > Databases > Specific Databases > MySQL & mSQL
- Books > Computers & Technology > Operating Systems > Unix
- Books > Computers & Technology > Programming
- Books > Computers & Technology > Software
- Books > Computers & Technology > Web Development > Programming > SQL
- Books > Professional & Technical > Professional Science > Mathematics
- Books > Textbooks > Computer Science & Information Systems > Database Storage & Design
- Books > Textbooks > Computer Science & Information Systems > Operating Systems
- Books > Textbooks > Computer Science & Information Systems > Programming Languages