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