---

MySQL Phrasebook

ISBN: 0672328399
EAN: 2147483647

Year: 2003
Pages: 130

Authors: Zak Greant, Chris Newman

BUY ON AMAZON

• MySQL Phrasebook: Essential Code and Commands
• Table of Contents
• 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
• SYMBOL
• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W