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.



MySQL(c) Essential Skills
MySQL: Essential Skills
ISBN: 0072255137
EAN: 2147483647
Year: 2006
Pages: 109

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net