MySQL and mSQL

✍ Scribed by Tim King, George Reese, Randy Yarger

• Publisher: O'Reilly
• Year: 1999
• Tongue: English
• Leaves: 776
• Edition: 1st ed
• Category: Library

✦ Synopsis

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 non-profit 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&39;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"

✦ Table of Contents

Header......Page 1
Cover......Page 2
Title Page......Page 3
Table of Contents......Page 6
Preface......Page 17
Part I - Getting Started With MySQL and mSQL......Page 27
1 - Introduction to Relational Databases......Page 28
2 - Database Design......Page 41
3 - Installation......Page 65
4 - MySQL......Page 77
5 - mSQL......Page 122
6 - SQL According to MySQL and mSQL......Page 154
7 - Other Mid-Range Database Engines......Page 186
Part II - Database Programming......Page 196
8 - Database Application Architectures......Page 197
9 - CGI Programming......Page 206
10 - Perl......Page 238
11 - Python......Page 272
12 - PHP and Other Support for Databasedriven HTML......Page 280
13 - C and C++......Page 294
14 - Java and JDBC......Page 319
15 - SQL Reference......Page 335
16 - MySQL and mSQL System Variables......Page 407
17 - MySQL and mSQL Programs and Utilities......Page 421
18 - PHP and Lite Reference......Page 458
19 - C Reference......Page 551
20 - Python Reference......Page 596
21 - Perl Reference......Page 610
22 - JDBC Reference......Page 674