MySQL Cookbook > Using the mysql Client Program > Specifying Queries on the Command Line

Table of Contents

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

This Book

MySQL Cookbook

Search

Preface

Ch. 1. Using the mysql Client Program

Introduction

Setting Up a MySQL User Account

Creating a Database and a Sample Table

Starting and Terminating mysql

Specifying Connection Parameters by Using Option Files

Protecting Option Files

Mixing Command-Line and Option File Parameters

What to Do if mysql Cannot Be Found

Setting Environment Variables

Issuing Queries

Selecting a Database

Canceling a Partially Entered Query

Repeating and Editing Queries

Using Auto-Completion for Database and Table Names

Using SQL Variables in Queries

Telling mysql to Read Queries from a File

Telling mysql to Read Queries from Other Programs

Specifying Queries on the Command Line

Using Copy and Paste as a mysql Input Source

Preventing Query Output from Scrolling off the Screen

Sending Query Output to a File or to a Program

Selecting Tabular or Tab-Delimited Query Output Format

Specifying Arbitrary Output Column Delimiters

Producing HTML Output

Producing XML Output

Suppressing Column Headings in Query Output

Numbering Query Output Lines

Making Long Output Lines More Readable

Controlling mysql's Verbosity Level

Logging Interactive mysql Sessions

Creating mysql Scripts from Previously Executed Queries

Using mysql as a Calculator

Using mysql in Shell Scripts

Ch. 2. Writing MySQL-Based Programs

Ch. 3. Record Selection Techniques

Ch. 4. Working with Strings

Ch. 5. Working with Dates and Times

Ch. 6. Sorting Query Results

Ch. 7. Generating Summaries

Ch. 8. Modifying Tables with ALTER TABLE

Ch. 9. Obtaining and Using Metadata

Ch. 10. Importing and Exporting Data

Ch. 11. Generating and Using Sequences

Ch. 12. Using Multiple Tables

Ch. 13. Statistical Techniques

Ch. 14. Handling Duplicates

Ch. 15. Performing Transactions

Ch. 16. Introduction to MySQL on the Web

Ch. 17. Incorporating Query Resultsinto Web Pages

Ch. 18. Processing Web Input with MySQL

Ch. 19. Using MySQL-Based Web Session Management

Appx. A. Obtaining MySQL Software

Appx. B. JSP and Tomcat Primer

Appx. C. References

Colophon

Index

1.18. Specifying Queries on the Command Line

1.18.1. Problem

You want to specify a query directly on the command line for mysql to execute.

1.18.2. Solution

mysql can read a query from its argument list. Use the -e (or --execute) option to specify a query on the command line.

You are currently reading a PREVIEW of this book.

Get instant access to over
$1 million worth of books and videos.

Start a Free Trial