MySQL and mSQL 1st Edition

by Tim King (Author), George Reese (Author), Randy Yarger (Author)

45 ratings

ISBN-13: 978-1565924345

ISBN-10: 1565924347

Why is ISBN important?

Other Sellers

from

Other Sellers

See all 5 versions

Used: Very Good | Details

Sold by ONCE-OVER

Fulfilled by Amazon

Access codes and supplements are not guaranteed with used items.

FREE delivery Tuesday, May 10

Or fastest delivery Friday, May 6. Order within 11 hrs 17 mins

There is a newer edition of this item:

Managing and Using MySQL (2nd Edition)
$38.61
(14)
In Stock.

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

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

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.

Publisher ‏ : ‎ O'Reilly Media; 1st edition (July 11, 1999)
Language ‏ : ‎ English
Paperback ‏ : ‎ 502 pages
ISBN-10 ‏ : ‎ 1565924347
ISBN-13 ‏ : ‎ 978-1565924345
Item Weight ‏ : ‎ 1.76 pounds
Dimensions ‏ : ‎ 7 x 1.04 x 9.19 inches

Best Sellers Rank: #6,310,749 in Books (See Top 100 in Books)
- #627 in MySQL Guides
- #4,384 in Database Storage & Design
- #13,944 in Computer Programming Languages

Customer Reviews:
45 ratings

About the authors

Follow authors to get new release updates, plus improved recommendations.

Tim King
Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.
Discover more of the author’s books, see similar authors, read author blogs and more
See more on the author's page
George Reese
Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.
I am the CTO of enStratus Networks (http://www.enstratus.com), the leading cloud infrastructure management vendor for enterprise clouds. Based in Minneapolis, MN, I co-founded enStratus as a spin-off from a company in the middle of moving into the cloud, Valtira. I was the primary architect of the enStratus software as well as the Open Source cloud abstraction API for Java, Dasein Cloud (http://dasein-cloud.sf.net).
My professional career began in Hollywood working on TV shows like the People's Court and ESPN Up Close, but my "Internet Career" started in 1991 developing Open Source online gaming software, specifically the Nightmare and Dead Souls mud libraries. I got involved with Java in 1995 and wrote my first book, Database Programming with JDBC and Java in 1996.
See more on the author's page

Customer reviews

5 star		17%
4 star		31%
3 star		17%
2 star		17%
1 star		17%

How customer reviews and ratings work

Top reviews from the United States

There was a problem filtering reviews right now. Please try again later.

Eric Hwang

A good primer & reference, but assumes some prior knowledge

Reviewed in the United States on December 25, 1999

Verified Purchase

After reading about half the book, I'm now more aware of what I've already done with other databases and hopefully can better utilize MySQL. If you're looking for a book to hold your hand through the entire process of creating a database application, you'd better look elsewhere. MySQL & mSQL assumes the reader is not a dummy (like some series of books are written toward) and has enough programming background to effectively apply the concepts presented.
Having a background in developing web applications in Cold Fusion, much of the concepts presented were not new to me, but sections such as the Database Design and Performance Tuning chapters were helpful in gaining a little deeper insight on how things should be done. Since MySQL uses only a subset of SQL2, I'm glad a significant portion of the book deals with MySQL's implementation of SQL. However, I'm a little disappointed that the section dealing with PHP was miniscule in comparison to the sections dealing with Perl and JDBC. All-in-all, I'd recommend the book only if you have a programming background and are looking to expand your repertoire of database skills.

13 people found this helpful

Helpful

Michael A. Alderete

Ultimately disappointing, but there are some good parts

Reviewed in the United States on April 26, 2000

Verified Purchase

Like other reviewers, I was also disappointed with this book. I believe it was the first MySQL book to be published, and like other first books on an Internet/technology topic, it feels a little rushed, in that it lacks depth.
While others have discussed the flaws (and I don't disagree with them), there are a few good things about this book:
* It's reasonably well-written and edited (if a little shallow).
* There are some good (light) examples.
* I liked the section that compared mSQL and MySQL with the other free databases, and explained what was missing in each. (In a nutshell, Postgres is more robust and full-featured, while MySQL is considerably faster.)
Ultimately, I can't recommend this book (which saddens me, O'Reilly's books are among my favorites). If you want more SQL info, go with The Practical SQL Handbook (or SQL for Smarties, if you're advanced). If you want more MySQL info, go with Paul Dubois' book.

5 people found this helpful

Helpful

G. Seaton

Reference only. Not an intro... A little overpriced..

Reviewed in the United States on April 24, 2000

Verified Purchase

I started using MySQL since I wanted a database that didn't cost alot (free on Linux) and it was the database that my hosting provider used.
I picked up this book just as a base reference to MySQL/mSQL and it has served that purpose. I've been a DBA so I wasn't looking for an intro to SQL and databases, which this book is not, as evidenced by it being in the Nutshell series.
A little overpriced for what it's useful for, but if you already know SQL and relational databases, it is a decent reference guide for both MySQL and mSQL, especially of their limitations (no stored procs, foreign keys, etc).

Helpful

Peter Samson

Reviewed in the United States on September 7, 1999

Verified Purchase

I was disappointed by this book since O'Reilly normally publishes a more organized book/concept. If you have no or minimal experience with RDBMS products then this might be an appropriate book for you. If you are familiar with RDBMS products and are looking to transition to MySQL or looking for a solid reference to MySQL, then I recommend that you look elsewhere.

One person found this helpful

Helpful

Brian Donnelly

O'Reilly Does it again!

Reviewed in the United States on December 10, 1999

Verified Purchase

This book is great for the new and maybe even helpfull for the expert. I am new to the MySQL world and after running through half this book, I can shoot with the best of them. It covers everything from setting up MySQL to Administration and maintenance. If you are getting into MySQL, go to Starbuck's, get a venti iced mocha and sit down with this book. You will not regret this purchase.

5 people found this helpful

Helpful

Joseph C.

Very disappointed.

Reviewed in the United States on February 27, 2000

I was very disappointed with this book. So were two coworkers who have looked at it. This book is not up to the traditional O'Reilly quality. (In fact, I'm annoyed enough to say that Que should have published this book...)
Only about 30% of the book is useful material. Most examples and explanations are sketchy -- almost useless. If you already knew SQL, there's very little to learn from this book. If you didn't know SQL, this book does a poor job of teaching it to you.
If the book stuck strictly to mSQL and MySQL, it would have been about ~150 pages of content. The rest (about 300 pages) is a "reference manual" for various (PHP/Perl/Java JDBC/C/Python) languages' support for MySQL/mSQL. Again, if you didn't know the concepts already, you would have a hard time learning useful stuff from this book.
Still, I have to admit to using the book every so often as a handy "at-my-fingertips" reference book. For that, I am glad that I have it. But I don't think it was worth the price I paid.

32 people found this helpful

Helpful

Christopher J. Snell

Overpriced, for what you get

Reviewed in the United States on March 27, 2000

Being a loyal O'Reilly customer, I pre-ordered this book before it was released. Big mistake.
I found this book to be, for the most part, a waste of money. First off, I think O'Reilly made a mistake when they attempted to cover both MySQL and mSQL in one text. Had they stuck with one database, the book would have been a fairly complete reference but instead, it seems to take a mostly superficial look at the two. I found the constant comparisons between mSQL and MySQL to be distracting and annoying. Secondly, I think this text focused too heavily on the configuration of the database engine itself and not enough on the building of databases and the SQL language. In my opinion, the only redeeming value that this book had was the Perl programming examples.
I bought this book having never before used SQL or MySQL. After a few hours of reading, I gave up on it and went to the online MySQL reference instead, which is actually quite decent.
I was browsing SQL books at the local bookstore the other day and thumbed through Paul DuBois' book, which seemed to be a much better reference to the database.

17 people found this helpful

Helpful

MySQL and mSQL 1st Edition

There is a newer edition of this item:

Editorial Reviews

Amazon.com Review

From Library Journal

About the Author

Product details

About the authors

Tim King

George Reese

Customer reviews

Top reviews from the United States

There was a problem filtering reviews right now. Please try again later.