The answer to this question can be found in the Appendix C directory located on the CD-

ROM that accompanies this book.

List of Figures

Day 1: What Is MySQL?

Figure 1.1 The anatomy of a database.

Day 2: Getting Started

Figure 2.1 New MySQL Windows installation.

Figure 2.2 MySQLManager.

Figure 2.3 mysqld running as a background process.

Figure 2.4 The MySQL monitor.

Figure 2.5 Viewing existing databases in the MySQL monitor.

Figure 2.6 Results of the USE command.

Figure 2.7 Viewing the structure of a database.

Figure 2.8 Listing the columns of a selected database.

Day 3: Designing Your First Database

Figure 3.1 The database design process.

Figure 3.2 A one-to-one relationship.

Figure 3.3 Key fields in a one-to-one relationship.

Figure 3.4 A one-to-one relationship in a database.

Figure 3.5 A one-to-many relationship.

Figure 3.6 Here is one customer who has multiple orders.

Figure 3.7 A many-to-many relationship.

Figure 3.8 A many-to-many relationship becomes two one-to-many relationships. This is done to ease

maintenance and add flexibility, and to obey the rules of normalization.

Figure 3.9 Meet-A-Geek application form.

Figure 3.10 Meet-A-Geek customer questionnaire.

Figure 3.11 The Customers object.

Figure 3.12 The final Meet_A_Geek database model.

Day 4: Creating Your First Database

Figure 4.1 Results of a successful database creation.

Figure 4.2 Using the new database.

Figure 4.3 Dropping a database.

Figure 4.4 Creating a database using mysqladmin.

Figure 4.5 Dropping a database using mysqladmin.

Figure 4.6 Adding a host to the host table.

Day 6: Adding Tables, Columns, and Indexes to Your Database

Figure 6.1 Starting MySQL with an active database.

Figure 6.2 Creating a new table for the Meet_A_Geek database.

Day 8: Populating the Database

Figure 8.1 The Northwind database.

Figure 8.2 The Northwind query objects.

Figure 8.3 The query selection.

Figure 8.4 The query results.

Figure 8.5 The Export Query dialog box.

Figure 8.6 The Export Text Wizard.

Figure 8.7 Choose your delimiter.

Figure 8.8 Choosing the path and filename.

Figure 8.9 The finished import file.

Figure 8.10 A Telnet session.

Figure 8.11 Output from DESCRIBE Orders.

Day 10: Letting MySQL Do the Work—Intrinsic Functions

Figure 10.1 The anatomy of a function.

Day 11: MySQL Table Locks and Assorted Keys

Figure 11.1 Processing without locks.

Figure 11.2 Safer processing with locks.

Figure 11.3 Using a key to access the state column of a Customers table.

Day 12: How to Get the Data—Database Interfaces

Figure 12.1 Process flow for interfaces and drivers.