Product Description
This book teaches you how to use MySQL and mSQL, two popular and robust database products that support key subsets of SQL on both Linux and Unix systems. Unlike commercial databases, mSQL and MySQL are affordable and easy to use. Both are free for nonprofit use and cost a small amount for commercial use. If you know basic C, Java, Perl, or Python, you can quickly write a program to interact with a database. This book takes you through the whole process, from installation and configuration to programming interfaces and basic administration, and includes ample tutorial material. It covers:
- Simple database design and SQL
- Building, installation, and configuration
- Basic programming APIs for C, C++, Java (JDBC), Perl, and Python
- CGI programming with databases in C and Perl
- Web interfaces: PHP, W3-mSQL, Lite, and mSQLPerl
Amazon.com Review
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
MySQL Cookbook, Paul DuBois, New Book | US $68.85 End Date: Tuesday Feb-28-2012 21:26:18 PST Buy It Now for only: US $68.85 Buy it now | Add to watch list |
This is a great reference book that I use all the time.
Amazon User Rating: 4 / 5
If you are a (real) computer professional and need a great book to get your self up to speed on MySQL. Then this is your book. Best used with MySQL’s online documentation. Also a really good section for perl DBI /DBD API. Note: I read the bad reviews placed about this book. And it seemed that the people who gave bad reviews don’t know much about computers or databases. This book is not meant for cover-to-cover reading. Just read the first 4 chapters then use as a reference when needed. You will find it an exhalent source for problem solving MySQL issues and when you need to get more in-depth go to the online doc provide by MySQL.
Amazon User Rating: 5 / 5
This certainly the worst book on computers that I’ve ever seen. O’Reilly, do something about this NOW!!
Amazon User Rating: 1 / 5
This book was a huge disappointment to me. It was one of the softest watered down computer texts i’ve ever seen. My only question is where’s the “Que” book when you need it?
Amazon User Rating: 2 / 5
This is the worst O’Reilly book ever. It made me not use MySQL for over a year. I switched to PostgreSQL instead. No step by step on how to add users, etc. I did think the Perl-DBI/DBD part was good, but it was useless because of the early chapters.
I’m not saying the book was dog, but it does chase cars and eat kibble.
Amazon User Rating: 1 / 5