Cover image for MySQL and mSQL
MySQL and mSQL
Yarger, Randy Jay.
Personal Author:
First edition.
Publication Information:
Sebastopol, CA : O'Reilly, 1999.
Physical Description:
xv, 487 pages : illustrations ; 24 cm
General Note:
"Databases for moderate-sized organizations & web sites"--Cover.

Includes index.
Format :


Call Number
Material Type
Home Location
Item Holds
QA76.73.S67 Y37 1999 Adult Non-Fiction Central Closed Stacks

On Order



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

Author Notes

Tim King has been working with computers since the early 1980s, when he programmed games on his Commodore 64 computer and founded a computer club in his high school. He earned a bachelor's degree in computer science from the University of Minnesota Institute of Technology in 1991. While there, he taught Unix and vi classes and was the leader of a rag-tag group of vi devotees called the "VI Zombies." Presently, Tim is a software consultant in San Francisco, CA, specializing in database and web technologies. His favorite activity is snowboarding, but he also enjoys photography and reading. You can reach him at

George Reese has taken an unusual path into business software development. After earning a B.A. in philosophy from Bates College in Lewiston, Maine, George went off to Hollywood where he worked on television shows such as "The People's Court" and ESPN's "Up Close". The L.A. riots convinced him to return to Maine where he finally became involved with software development and the Internet. George has since specialized in the development of Internet-oriented Java enterprise systems and the strategic role of technology in business processes. He is the author of Database Programming with JDBC and Java, 2nd Edition and the world's first JDBC driver, the mSQL-JDBC driver for mSQL. He currently lives in Minneapolis, Minnesota with his wife Monique and three cats, Misty, Gypsy, and Tia. He makes a living as the National Practice Director of Technology Strategy for digital@jwt in Minneapolis.

Reviews 1

Library Journal Review

Using a database is the ony way to assure that a web siteÄeven a small web siteÄwill 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. (c) Copyright 2010. Library Journals LLC, a wholly owned subsidiary of Media Source, Inc. No redistribution permitted.

Table of Contents

Prefacep. ix
I. Getting Started with MySQL and mSQLp. 1
1. Introduction to Relational Databasesp. 3
What Is a Database?p. 4
What Is a Relational Database?p. 5
Applications and Databasesp. 6
MySQL and mSQLp. 7
2. Database Designp. 13
Database Designp. 13
Normalizationp. 16
A Logical Data Modeling Methodologyp. 25
Physical Database Designp. 26
3. Installationp. 30
MySQLp. 30
mSQLp. 37
4. MySQLp. 39
Designp. 39
Installing MySQLp. 41
Running MySQLp. 41
Database Administrationp. 42
MySQL Utilitiesp. 58
Performance Tuningp. 62
5. mSQLp. 68
Designp. 68
mSQL Versionsp. 70
Installing mSQLp. 72
Running mSQLp. 73
Database Administrationp. 77
mSQL Utilitiesp. 84
6. SQL According to MySQL and mSQLp. 90
SQL Basicsp. 90
Creating and Dropping Tablesp. 93
SQL Datatypesp. 94
Indicesp. 100
Sequences and Auto-Incrementingp. 101
Managing Datap. 103
Queriesp. 105
Extended Functionalityp. 109
7. Other Mid-Range Database Enginesp. 113
What Is "Free"?p. 113
What MySQL and mSQL Lackp. 114
PostgreSQLp. 117
GNU SQLp. 118
Beaglep. 119
Making Comparisonsp. 119
II. Database Programmingp. 121
8 Database Application Architecturesp. 123
The Client/Server Architecturep. 123
Data Processingp. 124
Object/Relational Modelingp. 125
The Three-tier Architecturep. 127
9. CGI Programmingp. 130
What Is CGI?p. 130
HTML Formsp. 131
The CGI Specificationp. 136
Important Considerations for CGI Scriptsp. 143
CGI and Databasesp. 152
10. Perlp. 154
DBIp. 154
An Example DBI Applicationp. 161
Msql.pmp. 165
MysqlPerlp. 174
11. Pythonp. 181
Basic Connectivityp. 181
Dynamic Connectivityp. 184
12. PHP and Other Support for Database-driven HTMLp. 187
Alternatives for Dynamic Content on the Webp. 187
W3-mSQLp. 189
PHPp. 193
Embedded Perlp. 195
13. C and C++p. 197
The Two APIsp. 197
Object-oriented Database Access in C++p. 203
14. Java and JDBCp. 216
What Is JDBC?p. 216
Simple Database Accessp. 221
Dynamic Database Accessp. 224
A Guest Book Servletp. 227
III. Referencep. 229
15. SQL Referencep. 231
MySQL SQLp. 231
mSQL SQLp. 269
16. MySQL and mSQL System Variablesp. 275
MySQL System Variablesp. 275
mSQL System Variablesp. 280
17. MySQL and mSQL Programs and Utilitiesp. 284
MySQL Utilitiesp. 284
mSQL Utilitiesp. 299
18. PHP and Lite Referencep. 303
PHPp. 303
Litep. 334
19. C Referencep. 345
MySQL C APIp. 345
mSQL C APIp. 361
20. Python Referencep. 368
Module: MySQLp. 368
Module: mSQLp. 372
21. Perl Referencep. 375
Installationp. 375 APIp. 377 APIp. 396 APIp. 412
22. JDBC Referencep. 416
Indexp. 469