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
Professional Java Native Interfaces with SWT/JFace (Programmer to Programmer)
SWT/JFace Mechanisms
Layouts
Tables
Printing
JFace Windows and Dialogs
Developing Tablet PC Applications (Charles River Media Programming)
Introduction to the VB .NET Language
Obtaining the Tablet PC SDK
Power Management for the Tablet PC
Pong Game
Tablet Fax
SQL Hacks
Hack 6. Dont Perform the Same Calculation Over and Over
Hack 8. Filter Rows and Columns
Date Handling
Hack 29. Other Ways to COUNT
Hack 58. Store Parameters in the Database
PMP Practice Questions Exam Cram 2
Answers and Explanations
Project Execution
Answers and Explanations
Answers and Explanations
Answers and Explanations
Junos Cookbook (Cookbooks (OReilly))
Configuring an IPv4 Address on an Interface
Redistributing Static Routes into IS-IS
Tracing IS-IS Protocol Traffic
Adjusting OSPF Link Costs
Viewing Information and LDP-Signaled LSPs in the Routing Tables
User Interfaces in C#: Windows Forms and Custom Controls
Creating Usable Interfaces
Custom Controls
MDI Interfaces and Workspaces
Dynamic User Interface
GDI+ Controls
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