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
OpenSSH: A Survival Guide for Secure Shell Handling (Version 1.0)
Step 3.4 Use PuTTYs Tools to Transfer Files from the Windows Command Line
Step 4.2 Passphrase Considerations
Step 4.7 Using Public Key Authentication for Automated File Transfers
Step 6.1 Port Forwarding
Step 6.3 X11 Forwarding
SQL Tips & Techniques (Miscellaneous)
Working with Functions, Parameters, and Data Types
Working with Comparison Predicates and Grouped Queries
Writing External Applications to Query and Manipulate Database Data
Working with Data BLOBs and Text
Working with SQL Database Data Across the Internet
Image Processing with LabVIEW and IMAQ Vision
Some Definitions
Charge-Coupled Devices
Frame Grabbing
Spatial Image Filtering
Pixel Value Analysis
The CISSP and CAP Prep Guide: Platinum Edition
Operations Security
Legal, Regulations, Compliance, and Investigations
Physical (Environmental) Security
Appendix C The Information System Security Architecture Professional (ISSAP) Certification
Appendix E The Information System Security Management Professional (ISSMP) Certification
Cisco Voice Gateways and Gatekeepers
Analog Trunks
Connecting to an IP WAN
Review Questions
IP-to-IP Gateway Overview
Twisted Network Programming Essentials
Building Simple Clients and Servers
Working with POST Data from HTML Forms
Installing SOAP Libraries
Calling SOAP Web Services
Running a Basic NNTP Server
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