PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/is-null-optimization.html
MySQL can perform the same optimization on col_name IS NULL that it can use for col_name = constant_value. For example, MySQL can use indexes and ranges to search for NULL with IS NULL. This optimization does not occur in cases when the column ...
https://dev.mysql.com/doc/refman/5.7/en/json-functions.html
For discussion of the JSON data type and additional examples showing how to use these functions, see Section 11.5, “The JSON Data Type”. The functions described in this section perform operations on JSON values. For functions that take a JSON ...
https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html
row *************************** id: 1 select_type: SIMPLE table: jemp partitions: NULL type: range possible_keys: i key: i key_len: 5 ref: NULL rows: 2 filtered: 100.00 Extra: Using where 1 row in set, 1 warning (0.00 sec) mysql> SHOW WARNINGS\G ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-functions-general-purpose.html
The following example shows how to set up a shared key named SharedKey that is owned by the DBA, and a get_shared_key() stored function that provides access to the current key value. MySQL Server supports a keyring service that enables internal ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-metadata.html
To see whether a keyring plugin is loaded, check the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 5.5.2, “Obtaining Server Plugin Information”). For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-plugin-installation.html
Verify plugin installation by examining the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 5.5.2, “Obtaining Server Plugin Information”). Keyring service consumers require that a keyring plugin be installed.
https://dev.mysql.com/doc/refman/5.7/en/keyring-system-variables.html
The default file name is keyring_encrypted, located in a directory that is platform specific and depends on the value of the INSTALL_LAYOUT CMake option, as shown in the following table. The password value cannot be displayed at runtime with SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/ldml-rules.html
The following table shows the correspondence between abbreviated syntax rules and the equivalent nonabbreviated rules. This is a subset of the syntax described in the LDML specification available at http://www.unicode.org/reports/tr35/, which should ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld-compiling.html
The following example shows how a program could be compiled from the command line, assuming that you are using gcc, use the GNU C compiler: gcc mysql_test.c -o mysql_test \ `/usr/local/mysql/bin/mysql_config --include --libmysqld-libs` Immediately ... In precompiled binary MySQL distributions that include libmysqld, the embedded server library, MySQL builds the library using the appropriate vendor compiler if there is ...
https://dev.mysql.com/doc/refman/5.7/en/manual-info.html
Note When you enter a command or statement shown in an example, do not type the prompt shown in the example. In some areas different systems may be distinguished from each other to show that commands should be executed in two different environments.