List of Figures

Module 1: Installing MySQL

Figure 1-1: The default view of the WinMySQLAdmin tool before MyODBC has been installed

Figure 1-2: The my.ini tab has buttons to safely edit and resave the my.ini file.

Figure 1-3: The Databases tab showing the columns_priv table information of the mysql database

Figure 1-4: The help listing of MYSQL commands and shortcuts in Windows

Figure 1-5: The help listing of MySQL commands and shortcuts in Linux

Module 2: Defining a Database

Figure 2-1: Allowing MySQL to fill some column data

Module 3: Manipulating the Database

Figure 3-1: DataFile2.txt showing different formats for field termination

Figure 3-2: Results of loading DataFile2.txt into the cust_names table

Module 4: Basic Reporting

Figure 4-1: Using the SELECT command with the LIMIT option

Figure 4-2: Using the LIMIT option with offset and count specifications

Figure 4-3: Using the AS option of the SELECT command

Module 5: Advanced Reporting

Figure 5-1: Using CASEWHEN for comparing values

Figure 5-2: Using CASEWHEN for evaluating conditions

Figure 5-3: Using CASEWHEN without ELSE

Figure 5-4: Basic examples of the CONCAT function

Figure 5-5: Examples of the CONCAT_WS function

Figure 5-6: Examples of the SUBSTRING function

Figure 5-7: Examples of SUBSTRING_INDEX

Figure 5-8: Examples of the INSTR, REPLACE, and LENGTH functions

Figure 5-9: Examples of the LIKE function

Figure 5-10: Examples of the STRCMP function

Figure 5-11: Examples of the LPAD, RPAD, UPPER, and LOWER functions

Figure 5-12: Examples of the TRIM, LTRIM, and RTRIM functions

Figure 5-13: Examples of the DATE_FORMAT function

Figure 5-14: Examples of the IFNULL and NULLIF functions

Figure 5-15: Using grouping and nongrouping columns

Figure 5-16: Reversing the order of GROUP BY fields changes the results.

Figure 5-17: Examples of the GROUP BY HAVING clause

Figure 5-18: A Cartesian join

Figure 5-19: Results from simple joins

Figure 5-20: Using an INNER JOIN function

Figure 5-21: Specifying the table name only when necessary

Figure 5-22: Using RIGHT and LEFT JOIN on noncorresponding tables

Module 6: GUIs for Data Handling and Administration

Figure 6-1: The MySQL Administrator opening window

Figure 6-2: The Connections category of the Options dialog box

Figure 6-3: The Connect to MySQL Server Instance dialog box with details displayed

Figure 6-4: The Service Control display with the Start/Stop Service tab selected

Figure 6-5: The Service Control display with the Configure Service tab selected

Figure 6-6: The Startup Variables display with the General Parameters tab selected

Figure 6-7: The User Administration display with the User Information tab selected

Figure 6-8: The Server Connections display with the Threads tab selected

Figure 6-9: The Health display with the Connection Health tab selected

Figure 6-10: The Server Logs display with the Error Log tab selected

Figure 6-11: The Backup display with the Backup Project tab selected

Figure 6-12: The Restore window with General tab displayed

Figure 6-13: The Catalogs display with the Schema Tables tab selected

Figure 6-14: The main Control Center window with a minimized Console Manager window

Figure 6-15: MySQLCC when the MDI option is not selected

Figure 6-16: The Console Manager window in MDI mode with main Control Center window

Figure 6-17: The SQL Query Editor window

Figure 6-18: The Console Manager with the server level selected in the tree pane

Figure 6-19: The Console Manager with the databases level selected in the tree pane

Figure 6-20: The Console Manager with the tables level selected in the tree pane

Figure 6-21: The Console Manager with a specific table selected in the tree pane

Figure 6-22: The Query window displaying all rows in a table

Figure 6-23: The window for editing a table

Module 7: Interfacing with Programs

Figure 7-1: Fetching results from queries

Module 8: Basic Administration and Backups

Figure 8-1: Using BACKUP TABLE

Figure 8-2: Renamed backup files reflecting their backup date

Figure 8-3: Running the mysqldump script from the OS command line

Figure 8-4: Results of using mysqldump to back up the duck_cust table

Figure 8-5: Using the --opt option with mysqldump

Appendix C: PHP Installation and Basic Syntax

Figure C-1: If PHP is installed, youll see a page of information similar to this.