Chapter 2. The mysql Client Program

Chapter 2. The mysql Client Program

This chapter 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. The chapter covers the following exam topics:

• Using mysql interactively and in batch mode

• mysql statement terminators and prompts

• Using the mysql input line-editing capability

• mysql output formats

• mysql internal commands

• Using server-side help

• Using the --safe-updates option to prevent dangerous data changes