MySQL Cookbook - page 1
- Main Page
- Main Page
- Table of content
- Copyright
- Preface
- MySQL APIs Used in This Book
- Who This Book Is For
- What s in This Book
- Platform Notes
- Conventions Used in This Book
- The Companion Web Site
- Comments and Questions
- Additional Resources
- Acknowledgments
- Chapter 1. Using the mysql Client Program
- 1.1 Introduction
- 1.2 Setting Up a MySQL User Account
- 1.3 Creating a Database and a Sample Table
- 1.4 Starting and Terminating mysql
- 1.5 Specifying Connection Parameters by Using Option Files
- 1.6 Protecting Option Files
- 1.7 Mixing Command-Line and Option File Parameters
- 1.8 What to Do if mysql Cannot Be Found
- 1.9 Setting Environment Variables
- 1.10 Issuing Queries
- 1.11 Selecting a Database
- 1.12 Canceling a Partially Entered Query
- 1.13 Repeating and Editing Queries
- 1.14 Using Auto-Completion for Database and Table Names
- 1.15 Using SQL Variables in Queries
- 1.16 Telling mysql to Read Queries from a File
- 1.17 Telling mysql to Read Queries from Other Programs
- 1.18 Specifying Queries on the Command Line
- 1.19 Using Copy and Paste as a mysql Input Source
- 1.20 Preventing Query Output from Scrolling off the Screen
- 1.21 Sending Query Output to a File or to a Program
- 1.22 Selecting Tabular or Tab-Delimited Query Output Format
- 1.23 Specifying Arbitrary Output Column Delimiters
- 1.24 Producing HTML Output
- 1.25 Producing XML Output
- 1.26 Suppressing Column Headings in Query Output
- 1.27 Numbering Query Output Lines
- 1.28 Making Long Output Lines More Readable
- 1.29 Controlling mysql s Verbosity Level
- 1.30 Logging Interactive mysql Sessions
- 1.31 Creating mysql Scripts from Previously Executed Queries
- 1.32 Using mysql as a Calculator
- 1.33 Using mysql in Shell Scripts
- Chapter 2. Writing MySQL-Based Programs
- 2.1 Introduction
- 2.2 Connecting to the MySQL Server, Selecting a Database, and Disconnecting
- 2.3 Checking for Errors
- 2.4 Writing Library Files
- 2.5 Issuing Queries and Retrieving Results
- 2.6 Moving Around Within a Result Set
- 2.7 Using Prepared Statements and Placeholders in Queries
- 2.8 Including Special Characters and NULL Values in Queries
- 2.9 Handling NULL Values in Result Sets
- 2.10 Writing an Object-Oriented MySQL Interface for PHP
- 2.11 Ways of Obtaining Connection Parameters
- 2.12 Conclusion and Words of Advice
- Chapter 3. Record Selection Techniques
- 3.1 Introduction
- 3.2 Specifying Which Columns to Display
- 3.3 Avoiding Output Column Order Problems When Writing Programs
- 3.4 Giving Names to Output Columns
- 3.5 Using Column Aliases to Make Programs Easier to Write
- 3.6 Combining Columns to Construct Composite Values
- 3.7 Specifying Which Rows to Select
- 3.8 WHERE Clauses and Column Aliases
- 3.9 Displaying Comparisons to Find Out How Something Works
- 3.10 Reversing or Negating Query Conditions
- 3.11 Removing Duplicate Rows
- 3.12 Working with NULL Values
- 3.13 Negating a Condition on a Column That Contains NULL Values
- 3.14 Writing Comparisons Involving NULL in Programs
- 3.15 Mapping NULL Values to Other Values for Display
- 3.16 Sorting a Result Set
- 3.17 Selecting Records from the Beginning or End of a Result Set
- 3.18 Pulling a Section from the Middle of a Result Set
