MySQL and mSQL

Randy Jay Yarger, George Reese, Tim King

510 pages, parution le 09/08/1999

Ajouter à une liste

Indisponible

Résumé

MySQL and mSQL are popular and robust database products for Linux and UNIX systems that support key subsets of SQL. 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 visitors to your Web site 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: W3-mSQL, Lite, and mSQLPerl

Table of contents

Preface
Part I: Getting Started with MySQL and mSQL: Chapter 1: Introduction to Relational Databases
Chapter 2: Database Design
Chapter 3: Installation
Chapter 4: MySQL
Chapter 5: mSQL
Chapter 6: SQL According to MySQL and mSQL
Chapter 7: Other Mid-Range Database Engines
Part II: Database Programming: Chapter 8: Database Application Architectures
Chapter 9: CGI Programming
Chapter 10: Perl
Chapter 11: Python
Chapter 12: PHP and Other Support for Database-driven HTML
Chapter 13: C and C++
Chapter 14: Java and JDBC
Part III: Reference: Chapter 15: SQL Reference
Chapter 16: MySQL and mSQL System Variables
Chapter 17: MySQL and mSQL Programs and Utilities
Chapter 18: PHP and Lite Reference
Chapter 19: C Reference
Chapter 20: Python Reference
Chapter 21: Perl Reference
Chapter 22: JDBC Reference
Index

L'auteur - George Reese

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. He is the
author of Database Programming with JDBC and Java 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
his living as a senior architect for Imaginet, LLC.