List of Tables

Chapter 1: Quickstart to MySQL

Table 1.1: The Product Table

Table 1.2: The Invoice Table

Table 1.3: Sales Reps

Table 1.4: AND/OR Truth Table

Table 1.5: The Customer Table

Table 1.6: The Sales Table

Chapter 2: Data Types and Table Types

Table 2.1: Numeric Types

Table 2.2: String Types

Table 2.3: Date Types

Table 2.3: TIMESTAMP Types

Table 2.5: MySQL Option

Table 2.6: Compressed Table Options

Chapter 3: Advanced SQL

Table 3.1: Logical Operators

Table 3.2: Arithmetic Operators

Table 3.3: Comparison Operators

Table 3.4: Wildcard Characters

Table 3.5: Regular Expressions (REGEXP, RLIKE)

Table 3.6: Bit OPerators

Chapter 4: Indexes and Query Optimization

Table 4.1: Boolesn Search Operators

Table 4.2: What the EXPLAIN Columns Mean

Table 4.3: What Descriptions in the extra EXPLAIN Column Mean

Table 4.4: The Different Join Type

Table 4.5: Meanings of the Columns Returned by SHOW INDEX

Chapter 7: Understanding Relational Databases

Table 7.1: The Product Table

Table 7.2: The Invoice Table

Table 7.3: The Custpmer Table

Table 7.4: The Lecturer Table

Table 7.5: The Course Table

Table 7.6: The Lecturer Table

Table 7.7: The Course Table

Table 7.8: The Student View

Table 7.9: The Student Table

Table 7.10: The Student Grade View

Table 7.11: The Student Table

Table 7.12: The Course Table

Table 7.13: The Grade Table

Chapter 8: Database Normalization

Table 8.1: Plant Data Displayed As a Tabular Report

Table 8.2: Trying to Create a Table with the Plant Data

Table 8.3: Each Record Stands Alone

Table 8.4: A Data Anomaly

Table 8.5: Removing the Fields Not Dependent on the Entire Key

Table 8.6: Creating a New Table with Plant Data

Table 8.7: Creating a New Table with Location Data

Table 8.8: Another Anomaly

Table 8.9: Plant Data After Removing the Soil Description

Table 8.10: Creating a New Table with the Soil Description

Table 8.11: 1st Normal Form

Table 8.12: The Plant Location Table with Partial Dependencies Removed

Table 8.13: Table Resulting from Fields Dependent on Plant Code

Table 8.14: Table Resulting from Fields Dependent on Location Code

Table 8.15: The Plant Location Table Remains Unchanged

Table 8.16: The Plant Table with Soil Description Removed

Table 8.17: The New Soil Table

Table 8.18: The Location Table Is Unchanged

Table 8.19: A Table Containing Data about the Student, Course, and Instructor Relationship

Table 8.20: Using Student and Course as the Key

Table 8.21: More Data Anomalies

Table 8.22: Student Instructor Table after Removing Course

Table 8.23: Resulting Instructor Course Table

Table 8.24: Using Student and Instructor as the Key

Table 8.25: Removing Course

Table 8.26: Creating a New Table with Course

Table 8.27: Student Course Instructor Data, with Several Instructors per Course

Table 8.28: Three Attributes as Key

Table 8.29: Creating a Table for the Student to Instructor Relationship

Table 8.30: Creating a Table for the Student to Course Relationship

Table 8.31: The Sales Rep Example

Table 8.32: Looking at a Larger Set of Data

Table 8.33: Creating a Table with Sales Rep and Product

Table 8.34: Creating a Table with Sales Rep and Company

Table 8.35: Creating a Table with Company and Product

Table 8.36: Customer Table

Chapter 9: Database Design

Table 9.1: Poet Table

Table 9.2: Poem Table

Table 9.3: Poem-Publication Table

Table 9.4: Publication Table

Table 9.5: Sale-Publication Table

Table 9.6: Sale Table

Table 9.7: Customer Table

Chapter 10: Basic Administration

Table 10.1: The MySQL Executables

Table 10.2: Precedence of the Configuration files on Unix

Table 10.3: Precedence of the Configuration files in Windows (continued)

Table 10.4: CHECK TABLE Options

Table 10.5: The mysqlcheck Options That Apply to Table Checking

Table 10.6: myisamchk Checking Options

Table 10.7: Available REPAIR TABLE Options

Table 10.8: Repairing Tables with myisamchk

Table 10.9: Mysqlcheck Options

Table 10.10: General myisamchk Options

Table 10.11: myisamchk Check Options

Table 10.12: myisamchk Repair Options

Table 10.13: Other myisamchk Options

Chapter 11: Database Backups

Table 11.1: mysqldump Options

Table 11.2: mysqlimport Options

Table 11.3: mysqlhotcopy Options

Table 11.4: mysqlbinlog Options

Chapter 12: Database Replication

Table 12.1: Master Configuration File Options

Table 12.2: Slave Configuration File Options

Chapter 13: Configuring and Optimizing MySQL

Table 13.1: The mysqld Options

Table 13.2: The mysqld Variables

Table 13.3: The MySQL Status Values

Table 13.4: Nonstandard Variables

Table 13.5: Options for run-all-tests

Table 13.6: Thecrash-meOptions

Chapter 14: Database Security

Table 14.1: The MySQL Tables

Table 14.2: What the Columns Mean

Table 14.3: Privileges

Table 14.4: Database and Table Names

Table 14.5: SSL Grant Options

Chapter 15: Installing MySQL

Table 15.1: Directories of a Binary Installation

Table 15.2: Directories of a Source Installation

Table 15.3: Executable files

Table 15.4: Red Hat Package Manager files

Table 15.5: mysqld_multi Options

Appendix A: MySQL Syntax Reference

Table A.1: Privileges

Table A.2: Variables You Set in a Nonstandard Way (continued)

Appendix B: MySQL Function and Operator Reference

Table B.1: Regular Expression Characters

Table B.2: Date Format Specifiers

Appendix F: Java API

Table F.1: Connection Properties

Table F.2: SQL Types and the Equivalent Set Methods

Table F.3: SQL Types and Equivalent Get Methods

Table F.4: SQL Types and the Equivalent Update Methods

Appendix G: C API

Table G.1: MYSQL Field Types

Table G.2: Flags

Table G.3: Macros

Appendix H: ODBC and .NET

Table H.1: Connection Options

Table H.2: Attribute and Associated value_pointer Contents

Table H.3: The SQLDiagField diagnostic_identifier Argument

Table H.4: The SQLGetEnvAttr attribute Argument

Table H.5: The SQLGetStmt attribute Argument

Table H.6: The operation Argument