https://dev.mysql.com/clone-plugin-remote.html
The clone plugin supports the following syntax for cloning remote data; that is, cloning data from a remote MySQL server instance (the donor) and transferring it to the MySQL instance where the cloning operation was initiated (the recipient). CLONE ...
https://dev.mysql.com/command-line-options.html
(However, the leading dashes cannot be given as underscores.) The MySQL server has certain command options that may be specified only at startup, and a set of system variables, some of which may be set at startup, at runtime, or both. For example, ... Program options specified on the command line follow these rules: Options are given after the command ...
https://dev.mysql.com/comparison-operators.html
Examples: If you compare a DATETIME to two DATE values, convert the DATE values to DATETIME values. For DATE and DATETIME columns that are declared as NOT NULL, you can find the special date '0000-00-00' by using a statement like this: SELECT * FROM ... Table 12.3 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/comparisons-using-subqueries.html
WHERE 'a' = (SELECT column1 FROM t1) MySQL also permits this construct: non_subquery_operand LIKE (subquery) At one time the only legal place for a subquery was on the right side of a comparison, and you might still find some old DBMSs that insist ... The most common use of a subquery is in the form: non_subquery_operand comparison_operator (subquery) Where comparison_operator is one of these operators: = > < >= <= <> != <=> For example: ...
https://dev.mysql.com/compilation-problems.html
Each time you run CMake, you must run make again to recompile. If you do reconfigure, take note of the following: If CMake is run after it has previously been run, it may use information that was gathered during its previous invocation. When CMake ...
https://dev.mysql.com/compiling-for-debugging.html
If you have some very specific problem, you can always try to debug MySQL. To do this you must configure MySQL with the -DWITH_DEBUG=1 option. You can check whether MySQL was compiled with debugging by doing: mysqld --help. If the --debug flag is ...
https://dev.mysql.com/condition-pushdown-optimization.html
For example, in a my.cnf file, use these lines: [mysqld] optimizer_switch=engine_condition_pushdown=off At runtime, disable condition pushdown like this: SET optimizer_switch='engine_condition_pushdown=off';Limitations. This optimization improves ...
https://dev.mysql.com/connecting-disconnecting.html
To connect to the server, you will usually need to provide a MySQL user name when you invoke mysql and, most likely, a password. If the server runs on a machine other than the one where you log in, you will also need to specify a host name. Contact ...
https://dev.mysql.com/connecting-using-uri-or-key-value-pairs.html
connect-timeout: An integer value used to configure the number of seconds that clients, such as MySQL Shell, wait until they stop trying to connect to an unresponsive MySQL server. connection-attributes: Controls the key-value pairs that application ... This section describes use of URI-like connection strings or key-value pairs to specify how to establish connections to the MySQL server, for clients such as MySQL ...
https://dev.mysql.com/connecting.html
It is possible to specify connection parameters without entering them on the command line each time you invoke a client program: Specify the connection parameters in the [client] section of an option file. This section describes use of command-line ...
