MySQL Phrasebook
MySQL Phrasebook
ISBN: 0672328399
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 130
Pages: 130
Authors: Zak Greant, Chris Newman
- 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
MySQL Phrasebook
ISBN: 0672328399
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 130
Pages: 130
Authors: Zak Greant, Chris Newman