Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Tell the Publisher!
Id like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

MySQL & mSQL [Paperback]

Tim King , George Reese , Randy Yarger
3.2 out of 5 stars  See all reviews (17 customer reviews)

Available from these sellers.

There is a newer edition of this item:
Managing & Using MySQL: Open Source SQL Databases for Managing Information & Web Sites Managing & Using MySQL: Open Source SQL Databases for Managing Information & Web Sites 3.5 out of 5 stars (2)
In stock.

Book Description

11 July 1999 1565924347 978-1565924345 1

MySQL and mSQL are popular and robust database products that support key subsets of SQL on both Linux and Unix systems. Both products are free for nonprofit use and cost a small amount for commercial use.

Even a small organization or web site has uses for a database. Perhaps you keep track of all your customers and find that your information is outgrowing the crude, flat-file format you started with. Or you want to ask your web site's visitors for their interests and preferences and put up a fresh web page that tallies the results.

Unlike commercial databases, MySQL and mSQL are affordable and easy to use. If you know basic C, Java, Perl, or Python, you can quickly write a program to interact with your database. In addition, you can embed queries and updates right in an HTML file so that a web page becomes its own interface to the database.

This book is all you need to make use of MySQL or mSQL. It takes you through the whole process from installation and configuration to programming interfaces and basic administration. Includes reference chapters and ample tutorial material.

Topics include:

  • Introductions to 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

Product details

  • Paperback: 502 pages
  • Publisher: O'Reilly Media; 1 edition (11 July 1999)
  • Language: French
  • ISBN-10: 1565924347
  • ISBN-13: 978-1565924345
  • Product Dimensions: 2.5 x 22.9 x 19 cm
  • Average Customer Review: 3.2 out of 5 stars  See all reviews (17 customer reviews)
  • Amazon Bestsellers Rank: 1,744,374 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.

Product Description

Amazon 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 normalisation. Then it explains the history of the freeware MySQL and mSQL packages which offer better performance than commercial relational database management system (RDBMS) packages although 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 programme 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 includes clear examples (including a student database). The book then moves from Perl on to other programming languages such as 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 the Publisher

Learn how to use MySQL and mSQL, two popular database products that support key subsets of SQL on Linux and Unix systems. Using basic C, Java, Perl, or Python, you can write a program to interact with a database, either as a stand-alone application or through a web page. This book covers the whole process, from installation to programming interfaces and basic administration. Includes ample tutorial material.

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

Most Helpful Customer Reviews
4.0 out of 5 stars God intro, not too heavy, lots of example code. 19 Jun 2003
I bought this book when I was at college just over two years ago. I did my final year project in php and mysql and this book was a great help.
If you're new to MySQL than this is a great book, it has lots of example code in PHP, perl, python, java, C and more and guides you through the basics.
I still find myself referring back to its mysql function list from time to time.
Comment | 
Was this review helpful to you?
4.0 out of 5 stars Thorough and readable 17 July 2001
Covers two DBMSes for the price of one! This could actually be the only reference required for all your database needs as it covers installation (and maybe building from source) administration, SQL and all manner of APIs to the DBMSes (for Perl, Python, C/C++, Java, PHP). Complaints? Not many - it needs updating as some of the information is now out of date, I can't see the point in covering mSQL as it is way behind MySQL in terms of features and sometimes the book strays beyond its remit. Overall, though, very good.
Comment | 
Was this review helpful to you?
By A Customer
Don't think this is the equivalent of the camel book for Perl, or the Flanagan book for Javascript, or other O'Reilly bibles. It isn't.
It is littered with errors which should have been caught at the proofing stage, and imply that the code has not been thoroughly run - I found two errors just this morning, neither of which was in the online errata. The book is mostly a collection of vague api specifications that are available (and more up to date) online. Typically the description gives you little more than the arguments and a paraphrasing of an obvious action of the routine, with zero comment on exception conditions or possible difficulties. Treatment of performance issues, locking, error-handling etc. is negligible, and there are far better books on general database design issues for web-sites.
This book is poor for all levels of user.
Comment | 
Was this review helpful to you?
1.0 out of 5 stars Useless 22 Nov 2000
By A Customer
... The book does not explain how MySQL works, how to improve performance or its treatment of locks. In short, if you need to know about MySQL then you need to use the MySQL website.
The only useful part of the book is the SQL reference, and that could be obtained from elsewhere. In fact, the whole book might be better rebadged as a guide to SQL than one which claims to be specific to MySQL; trouble is, it would then have to compete with many better books.
Comment | 
Was this review helpful to you?
By A Customer
I was dissapointed, especially as this is an O'Reilly book. Just about covers the basics of getting a MySQL or mSQL server up, a little bit on database design, whole chapters on Perl, Python and C++ API's then the whole second half is references for SQL, Perl etc. Not a useful book if you want to start writing database apps. Not a tutorial book, just a reprint of the man pages and READMEs with a bit of history. IMHO. Hope it comes in handy as a reference once I learn how to build database apps from somehwere else.
Comment | 
Was this review helpful to you?
2.0 out of 5 stars This Book is spread too thin 12 April 2000
By A Customer
This covers a little bit of MySql a little bit of mSQL a little bit of how to access using perl/using java/using c/using php..
This book should have been an appendix to a proper book. Get the New Riders MySQL instead (and check on this book in your bookstore if you really get stuck.. you might get an answer...maybe)
Comment | 
Was this review helpful to you?
4.0 out of 5 stars Very good for reference 8 Mar 2000
This book provides excellent reference and an overview of the various methods of programatically accesssing your data. The perl examples are good, but it doesn't pretend to go into great depth.
Comment | 
Was this review helpful to you?
By A Customer
There is some good material in this book but a lot of this is available online. It can be very frustrating for beginners because some simple concepts are not explained at all, for example it directs the user to load database dumps through the MySql console without explaing what that is or how to do it. I am experienced in databases but not in Unix and this sort of omission made this book very difficult to use for me. The index is absolutely useless.
Comment | 
Was this review helpful to you?
Would you like to see more reviews about this item?
Were these reviews helpful?   Let us know
Most Recent Customer Reviews
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category