Table of Contents [+/-]
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
named 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
.”