Flylib.com
List of Figures
Previous page
Table of content
Next page
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.
Previous page
Table of content
Next page
MySQL: Essential Skills
ISBN: 0072255137
EAN: 2147483647
Year: 2006
Pages: 109
Authors:
John Horn
,
Michael Grey
,
LLC Interstate Software
BUY ON AMAZON
C++ How to Program (5th Edition)
Introduction
Self-Review Exercises
Processing Unexpected Exceptions
Summary
G.1. ATM Case Study Implementation
Introduction to 80x86 Assembly Language and Computer Architecture
Representing Data in a Computer
Procedures
The Assembly Process
Floating-Point Arithmetic
Appendix B Useful MS-DOS Commands
Junos Cookbook (Cookbooks (OReilly))
Keeping a Record of Configuration Changes
Configuring the Router by Copying Text from a Terminal Window
Clearing the Routers Logfiles
Using Counters to Determine Whether a Router Is Under Attack
Summarizing Routes in OSPF
Special Edition Using FileMaker 8
FileMaker Extra: Indexing in FileMaker
Getting Started with Calculations
FileMaker Extra: Incorporating Reports into the Workflow
Exporting to Fixed-Width Formats
Troubleshooting
Quartz Job Scheduling Framework: Building Open Source Enterprise Applications
What Is Job Scheduling?
Why job Scheduling Is Important
Cron Triggers and More
Running Quartz with JobStoreTX
Using the RMI Registry
VBScript in a Nutshell, 2nd Edition
The Form-Based Development Environment
Section B.6. Logical and TriState Constants
Section B.9. Variable Type Constants
Section C.3. Comparison Operators
Section C.4. Logical and Bitwise Operators
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies