Using options on the command line of a MySQL program?

Let us understand how to use options on the command line of a MySQL program -

Program options specified on the command line follow the following rules -

• Options are given after the command name.

• Option arguments begin with one or two dashes, and this depends on whether the option name is the short or long form.

• Many options have short and long forms. Let us take an example to understand this - -? and --help are the short and long forms of options that instruct the MySQL program to display a help message.

• Option names are case-sensitive. -v and -V are both legal, but have different meanings.

• They are the shorthand forms of the --verbose and --version options respectively.

  li>

Some options occupy a value after the option name. Let us take an example to understand this -

Example

−h localhost or −−host=localhost show the MySQL server host to a client program.

The option value provides the program with information about the host name on which the MySQL server is running.

MySQL server includes some command options that can only be specified at startup, and a set of system variables, some of which can be set at startup, runtime, or both.

Use underscores instead of dashes in system variable names. When they are referenced at runtime, they must be written using underscores, as follows -

query

SET GLOBAL general_log = ON;
SELECT @@GLOBAL.general_log;

During server startup, the syntax for system variables is the same as for command options. Therefore, dashes and underscores can be used interchangeably in variable names.

The above is the detailed content of Using options on the command line of a MySQL program?. For more information, please follow other related articles on the PHP Chinese website!