MySQL Phrasebook - page 1
- 1
- 2
- MySQL Phrasebook: Essential Code and Commands
- 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
- 1
- 2
