Table of Contents


book cover
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


MySQL Phrasebook. Essential Code and Commands
MySQL Phrasebook
ISBN: 0672328399
EAN: 2147483647
Year: 2003
Pages: 130

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net