List of Figures

Chapter 1: Quickstart to MySQL

Figure 1.1: Your machine has both the MySQL client and the MySQL server on it.

Figure 1.2: Your machine has the MySQL client. The MySQL server exists on another machine to which you connect.

Figure 1.3: In this case, your terminal can be any machine capable of connecting to another, as it doesn't even run the lightweight MySQL client on it.

Chapter 2: Data Types and Table Types

Figure 2.1: Date stores in static format

Figure 2.2: Data stored in dynamic format

Chapter 3: Advanced SQL

Figure 3.1: TABLE1

Figure 3.2: Powers of 10

Figure 3.3: Powers of 2

Figure 3.4: Step 1, Drawing up the columns

Figure 3.5: Step 2, Filling in the values

Figure 3.6: Step 3, Converting decimal to binary

Figure 3.7: Bitwise AND operation: 9&7

Figure 3.8: Bitwise OR operation: 9|7

Figure 3.9: Converting the binary number 11110000 to decimal

Chapter 4:   Indexes and Query Optimization

Figure 4.1: The index records point to the associated customer table records.

Chapter 7: Understanding Relational Databases

Figure 7.1: The hierarchical database model

Figure 7.2: The network database model

Figure 7.3: A one-to-one relationship

Figure 7.4: A one-to-many relationship

Figure 7.5: A many-to-many relationship

Figure 7.6: Setting foreign keys

Chapter 9:   Database Design

Figure 9.1: A many-to-many relationship

Figure 9.2: A one-to-many relationship

Figure 9.3: A one-to-one relationship

Figure 9.4: Creating the student-course intersection entity

Figure 9.5: Creating the brother intersection entity

Figure 9.6: Poet's Circle entity-relationship diagram

Figure 9.7: Poet's Circle entity-relationship diagram, with the many-to-many relationships removed

Chapter 10: Basic Administration

Figure 10.1: Using winmysqladmin to update the my.ini configuration file

Figure 10.2: Starting MySQL as a service in Windows 2000

Chapter 12: Database Replication

Figure 12.1: One master, one slave

Figure 12.2: One master, many slaves

Figure 12.3: Master/slave circular relationship

Figure 12.4: Master/slave "daisy chain"

Chapter 14: Database Security

Figure 14.1: Precedence for MySQL permission tables

Chapter 16: Multiple Drives

Figure 16.1: RAID 0

Figure 16.2: RAID 1

Figure 16.3: RAID 3

Figure 16.4: RAID 4

Figure 16.5: RAID 5

Figure 16.6: RAID 10

Figure 16.7: RAID 0+1