Table of Contents

Visual Quickstart Guide MySQL, Second Edition
By Larry Ullman
...............................................
Publisher: Peachpit Press
Pub Date: May 10, 2006
Print ISBN-10: 0-321-37573-4
Print ISBN-13: 978-0-321-37573-5
Pages: 480

Table of Contents  | Index

		Copyright
		A lifetime supply of thanks to:
		Chapter I.  Introduction
			What Is MySQL?
			MySQL Versions
			Primary MySQL Resources
			Technical Requirements
			About This Book
			Is This Book for You?
			Companion Web Site
			Questions, Comments, or Suggestions?
		Chapter 1.  Installing MySQL
			General Installation Steps
			Installing MySQL on Windows
			Configuring MySQL on Windows
			Installing MySQL on Macintosh
			Installing MySQL on Linux
			Basic Configuration Options
			Upgrading MySQL
		Chapter 2.  Running MySQL
			Running MySQL on Windows and Windows NT
			Running MySQL on Mac OS X
			Running MySQL on Linux and Unix
			Using Mysqladmin
			Setting the Root User Password
			Using the Mysql Client
			Users and Privileges
		Chapter 3.  Database Design
			Normalization
			Understanding Keys
			Understanding Relationships
			First Normal Form
			Second Normal Form
			Third Normal Form
		Chapter 4.  Creating a MySQL Database
			MySQL Data Types
			Extra Column Characteristics
			Introduction to Indexes
			Finalizing a Table's Design
			Choosing a Storage Engine
			Character Sets and Collations
			Creating Databases
			Creating Tables
			Modifying Tables
		Chapter 5.  Basic SQL
			Using Values in Queries
			Inserting Data
			Selecting Data
			Using Conditionals
			Using LIKE and NOT LIKE
			Performing Joins
			Sorting Query Results
			Limiting Query Results
			Updating Data
			Deleting Data
		Chapter 6.  MySQL Functions
			Text Functions
			Concatenation and Aliases
			Numeric Functions
		Chapter 7.  MySQL and PHP
			Connecting to MySQL and Selecting a Database
			Executing Simple Queries
			Retrieving Query Results
			Using mysqli_insert_id()
			Error Handling
			Security Considerations
		Chapter 8.  MySQL and Perl
			Installing Perl with MySQL Support on Windows
			Installing Perl Support for MySQL on Unix and Mac OS X
			Testing Perl and MySQL
			Connecting to MySQL
			Retrieving Query Results
			Executing Simple Queries
			Retrieving the Insert ID
			Error Handling
			Security Considerations
			Using Prepared Statements
		Chapter 9.  MySQL and Java
			Installing Java Support for MySQL
			Connecting to the Database
			Executing Simple Queries
			Retrieving Query Results
			Retrieving the Insert ID
			Using Prepared Statements
		Chapter 10.  Advanced SQL and MySQL
			Performing Transactions
			Full-Text Searching
			Regular Expressions
			User-Defined Variables
			Introducing Unions
		Chapter 11.  MySQL 5 Features
			Stored Routines
			Using OUT Parameters
			Triggers
			Views
		Chapter 12.  Techniques for Programming
			Storing and Retrieving Binary Data
			Making Query Result Pages
			Using Transactions with Perl
		Chapter 13.  MySQL Administration
			The MySQL Administrator
			Backing Up Databases
			Importing Data
			MySQL Logging
			Database Maintenance
			Improving Performance
			Using Batch Files
		Appendix A.  Troubleshooting
			Installation
			Starting MySQL
			Accessing MySQL
			mysql.sock Problems
			Queries That Return Strange Results
			Authentication Protocol Problems
			Resetting the Root Password
		Appendix B.  SQL and MySQL References
			Basic SQL
			ALTER Commands
			SQL Clauses
			MySQL Privileges
			MySQL Data Types
			MySQL Functions
			Other References
		Appendix C.  Resources
			MySQL-Specific
			Third-Party MySQL Applications
			SQL
			PHP
			Perl
			Java
			Other
		Index