Skip to main content

Posts

Showing posts with the label Statement Terminators

The mysql Client

The mysql Client           This section discusses mysql, a general-purpose client program for issuing queries and retrieving their results. It can be used interactively or in batch mode to read queries from a file. Using mysql Interactively      The mysql client program enables the sending of queries to the MySQL server with any results being displayed in the same interface. It can be used interactively or it can read query input from a file in batch mode: • Interactive mode is useful for day-to-day usage, for quick one-time queries, and for testing how queries work. • Batch mode is useful for running queries that have been prewritten and stored in a file. It's especially valuable for issuing a complex series of queries that's difficult to enter manually, or queries that need to be run automatically by a job scheduler without user intervention. MySQL statements such as the version query, shown below as executed within the mysql client, can also be run from the s