Chapter 1. Using the mysql Client Program


    Section 1.0.  Introduction

    Recipe 1.1.  Setting Up a MySQL User Account

    Recipe 1.2.  Creating a Database and a Sample Table

    Recipe 1.3.  Starting and Stopping mysql

    Recipe 1.4.  Specifying Connection Parameters Using Option Files

    Recipe 1.5.  Protecting Option Files from Other Users

    Recipe 1.6.  Mixing Command-Line and Option File Parameters

    Recipe 1.7.  What to Do if mysql Cannot Be Found

    Recipe 1.8.  Issuing SQL Statements

    Recipe 1.9.  Canceling a Partially Entered Statement

    Recipe 1.10.  Repeating and Editing SQL Statements

    Recipe 1.11.  Using Auto-Completion for Database and Table Names

    Recipe 1.12.  Telling mysql to Read Statements from a File

    Recipe 1.13.  Telling mysql to Read Statements from Other Programs

    Recipe 1.14.  Entering an SQL One-Liner

    Recipe 1.15.  Using Copy and Paste as a mysql Input Source

    Recipe 1.16.  Preventing Query Output from Scrolling off the Screen

    Recipe 1.17.  Sending Query Output to a File or to a Program

    Recipe 1.18.  Selecting Tabular or Tab-Delimited Query Output Format

    Recipe 1.19.  Specifying Arbitrary Output Column Delimiters

    Recipe 1.20.  Producing HTML or XML Output

    Recipe 1.21.  Suppressing Column Headings in Query Output

    Recipe 1.22.  Making Long Output Lines More Readable

    Recipe 1.23.  Controlling mysql's Verbosity Level

    Recipe 1.24.  Logging Interactive mysql Sessions

    Recipe 1.25.  Creating mysql Scripts from Previously Executed Statements

    Recipe 1.26.  Using User-Defined Variables in SQL Statements

    Recipe 1.27.  Numbering Query Output Lines

    Recipe 1.28.  Using mysql as a Calculator

    Recipe 1.29.  Using mysql in Shell Scripts




MySQL Cookbook
MySQL Cookbook
ISBN: 059652708X
EAN: 2147483647
Year: 2004
Pages: 375
Authors: Paul DuBois

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