MySQL program option modifiers

Some options are "Boolean values" that control behaviors that can be turned on or off.

Example

Mysql client supports the -- column-names option, which is used to indicate whether to display a column name at the beginning of the query results.

By default, this option is enabled. But sometimes, it may be necessary to disable this feature. This could be when sending the output of mysql to another program that only wants to see the data and not the initial header row.

To disable a column name, options can be specified in any of the forms mentioned below −

Query

--disable-column-names
(or)
--skip-column-names
(or)
--column-names=0

--disable prefix, --skip prefix and =0 suffix are all has the same effect. They turn that option off.

The "enabled" form of this option can be specified in any of the ways mentioned below -

Query

--column-names
(or)
--enable-column-names
(or)
--column-names=1

The values ​​ON, TRUE, OFF and FALSE are recognized as Boolean options . These values ​​are not case sensitive.

If an option is prefixed with --loose, the program will not exit with an error if it does not recognize the option. Instead, it only issues a warning. The following example demonstrates the same -

shell> mysql --loose-no-such-option

Output

mysql: WARNING: unknown option '--loose-no-such-option'

When a user runs a program from multiple MySQL installations on the same machine and the options are listed in the options file , you can use the --loose prefix.

The above is the detailed content of MySQL program option modifiers. For more information, please follow other related articles on the PHP Chinese website!