Table of Contents

MySQL® Phrasebook: Essential Code and Commands
By Zak Greant, Chris Newman
...............................................
Publisher: Sams
Pub Date: March 16, 2006
Print ISBN-10: 0-672-32839-9
Print ISBN-13: 978-0-672-32839-8
Pages: 192

Table of Contents  | Index

		Copyright
		About the Authors
		Acknowledgments
		We Want to Hear from You!
		Introduction
			Omissions: What This Book Doesn't Cover
			Conventions Used in This Book
			The MySQL Phrasebook Website
		Chapter 1.  Maps of MySQL
			The MySQL RDBMS
			The LAMP Platform
			MySQL Table Terminology
			Sample Tables
		Chapter 2.  Creating and Managing Databases, Tables, and Indexes
			Quick Guide: Databases, Tables, Columns, and Indexes
			Creating and Managing Databases
			Creating and Managing Tables
			Creating and Managing Columns
			Creating and Managing Indexes
			See Also
		Chapter 3.  Storing Data
			Adding Data to a Table
			Adding Many Rows in One Query Using INSERT
			Assigning Unique Row Numbers with auto_increment
			Inserting the Current Date and Time (Using a MySQL Function)
			Loading SQL Commands from a File
			Inserting Data from Another Table
			Importing Data from Text Files
			Inserting Data Rapidly
			See Also
		Chapter 4.  Retrieving Data: Simple Queries
			Limiting the Number of Rows Returned
			Sorting Result Sets
			Ignoring Duplicate Rows
			Finding Text That Matches a Pattern
			Finding the Smallest, Largest, or Average Value in a Column
			Date and Time Manipulation
			Storing Exact Floating Point Numbers
			Dealing with NULL
			Sending Query Results to a File
			Writing a BLOB to a File
		Chapter 5.  Manipulating Data
			Safety Tips
			Testing Queries Inside of a Transaction
			An Overview of Updating Column Values
			Updating Columns with Formulas
			Deleting Rows
			Deleting Rows from Multiple Tables
			Addred See Also
		Chapter 6.  User Management and Security
			Creating Users
			Deleting Users
			Renaming a User
			Using Wildcards
			Finding Users of a Given Database or Table
			Setting Passwords
			Tailoring User Permissions
			Allowing Other Users to Grant Privileges
			Viewing a User's Privileges
			Removing User Access
			Disabling Network Access
			Disabling User Authentication
			Using SSL-Secured Connection
			Addred See Also
		Chapter 7.  The mysql Command-line Client
			Connecting to a MySQL Server
			Using the Client in Batch Mode
			Basic mysql Command-line Client Navigation
			Erasing the Current Line or Query
			Setting Connection Defaults with an Option File
			Getting Help Within mysql
			Editing Complex Commands with a Text Editor
			Database, Table, and Column Name Completion
			Using the Command-line History
			Other Useful Tools
		Chapter 8.  MySQL APIs
			The C Language API
			The Perl API
			The PHP API
			See Also
		Chapter 9.  Advanced Queries
			Joins
			Subqueries
			Combining Queries with UNION
			Addred See Also
		Chapter 10.  Troubleshooting and Emergencies
			Backing Up
			Restoring from a Backup
			Corrupted Table Data
			Server Crash
			Common Errors
			Getting Help
		Appendix A.  A Brief MySQL Tutorial
			Getting Started
			Creating a Database
			Creating Tables
			Populating Tables with Data
			Exploring Table Creation
			Adding Indexes to Existing Tables
			Finding Information About Tables
			Creating Users
			Summary
		Index