Documentation Home
The MySQL Test Framework, Version 2.0
Download this Manual
PDF (US Ltr) - 0.6Mb
PDF (A4) - 0.6Mb

The MySQL Test Framework, Version 2.0  /  mysqltest Language Reference

Chapter 6 mysqltest Language Reference

This chapter describes the test language implemented by mysqltest. The language allows input to contain a mix of comments, commands executed by mysqltest itself, and SQL statements that mysqltest sends to a MySQL server for execution.

Terminology notes:

  • A command is an input test that mysqltest recognizes and executes itself. A statement is an SQL statement or query that mysqltest sends to the MySQL server to be executed.

  • When mysqltest starts, it opens a connection it calls default to the MySQL server, using any connection parameters specified by the command options. (For a local server, the default user name is root. For an external server, the default user name is test or the user specified with the --user option.) You can use the connect command to open other connections, the connection command to switch between connections, and the disconnect command to close connections. However, the capability for switching connections means that the connection named default need not be the connection in use at a given time. To avoid ambiguity, this document avoids the term default connection. It uses the term current connection to mean the connection currently in use, which might be different from the connection named default.