3 Aggregate Functions with GROUP BY
Day 11: MySQL Table Locks and Assorted Keys
Table 11.1 Composite Partial Keys

- 306 -
Day 13: How to Use MyODBC
Table 13.1 Connection Object’s Properties and Methods
Table 13.2 Command Object’s Properties and Methods
Table 13.3 Resultset Object’s Methods and Properties
Day 15: MySQL and PHP
Table 15.1 MySQL Functions
Day 16: MySQL and Time
Table 16.1 Date and Time Data Types
Table 16.2 TIMESTAMP Display Formats
Table 16.3 DATE_FORMAT and TIME_FORMAT Output Formats
Table 16.4 Values for expression and type When Adding and Subtracting Time
Day 20: Optimizing MySQL
Table 20.1 MySQL System Variables
Day 21: Putting It All Together
Table 21.1 The Customers Table
Table 21.2 The Ads Table
Table 21.3 The Products Table
Table 21.4 The Orders Table
Table 21.5 Summary of the Meet_A_Geek User Privileges
Appendix B: Current MySQL Functions
Table B.1 Time/Date Types
Table B.2 Format Symbols

List of Tables
Day 3: Designing Your First Database
Table 3.1 The Products Object
Table 3.2 The Completed Business Objects
Day 5: Making Your Data Normal
Table 5.1 Schema for Customers Database
Table 5.2 Eliminating Data Repetition in a Database
Table 5.3 First Normal Form
Table 5.4 Eliminating Partial Dependencies—Second Normal Form
Table 5.5 Eliminating Non-Key Data for Third Normal Form
Day 7: MySQL Data Types
Table 7.1 Numeric Storage
Table 7.2 Numeric Types
Table 7.3 String Types
Table 7.4 Column Modifiers
Day 8: Populating the Database
Table 8.1 mysqlimport Options
Table 8.2 mysqldump Options
Table 8.3 mysqlimport Options
Day 9: Querying the Database
Table 9.1 Reserved Words
Table 9.2 Results of Concatenation
Table 9.3 Aggregate Functions with GROUP BY
Day 11: MySQL Table Locks and Assorted Keys
Table 11.1 Composite Partial Keys
Day 13: How to Use MyODBC
Table 13.1 Connection Object’s Properties and Methods
Table 13.2 Command Object’s Properties and Methods
Table 13.3 Resultset Object’s Methods and Properties
Day 15: MySQL and PHP
Table 15.1 MySQL Functions
Day 16: MySQL and Time
Table 16.1 Date and Time Data Types
Table 16.2 TIMESTAMP Display Formats

- 307 -
Table 16.3 DATE_FORMAT and TIME_FORMAT Output Formats
Table 16.4 Values for expression and type When Adding and Subtracting Time
Day 20: Optimizing MySQL
Table 20.1 MySQL System Variables
Day 21: Putting It All Together
Table 21.1 The Customers Table
Table 21.2 The Ads Table
Table 21.3 The Products Table
Table 21.4 The Orders Table
Table 21.5 Summary of the Meet_A_Geek User Privileges
Appendix B: Current MySQL Functions
Table B.1 Time/Date Types
Table B.2 Format Symbols

List of Sidebars
Day 9: Querying the Database
ANSI-92 Compliance


- 308 -