PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/comp-err.html
--charset=dir_name, -C dir_name Command-Line Format --charset Type String Default Value ../share/charsets The character set directory. --debug=debug_options, -# debug_options Command-Line Format --debug=options Type String Default Value ... comp_err ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-function-reference.html
Table 6.35 MySQL Enterprise Data Masking and De-Identification Functions Name Description gen_blacklist() Perform dictionary term replacement gen_dictionary_drop() Remove dictionary from registry gen_dictionary_load() Load dictionary into registry ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-mysqld-ref.html
query-start(query, connectionid, database, user, host) query-done(status) query-start: Triggered after the query string has been received from the client. The single argument, query, is a string containing the full text of the original query. For ...
https://dev.mysql.com/doc/refman/5.7/en/error-message-elements.html
Error Message Elements When an error occurs, error information includes several elements: an error code, SQLSTATE value, and message string. SQLSTATE value: This value is a five-character string (for example, '42S02'). Message string: This string ...
https://dev.mysql.com/doc/refman/5.7/en/identifiers.html
mysql> SET sql_mode='ANSI_QUOTES'; mysql> CREATE TABLE "test" (col INT); Query OK, 0 rows affected (0.00 sec) The ANSI_QUOTES mode causes the server to interpret double-quoted strings as identifiers. Consequently, when this mode is enabled, string ... Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, and other object names are known as ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-indexes.html
For comparisons between nonbinary string columns, both columns should use the same character set. Comparison of dissimilar columns (comparing a string column to a temporal or numeric column, for example) may prevent use of indexes if values cannot ... Indexes are used to find rows with specific column values ...
https://dev.mysql.com/doc/refman/5.7/en/security-guidelines.html
To prevent password recovery using rainbow tables, do not use these functions on a plain password; instead, choose some string to be used as a salt, and use hash(hash(password)+salt) values. That does not mean the combination needs to be a random ...
https://dev.mysql.com/doc/refman/5.7/en/set-password.html
SET PASSWORD [FOR user] = password_option password_option: { 'auth_string' | PASSWORD('auth_string') } The SET PASSWORD statement assigns a password to a MySQL user account. = PASSWORD('auth_string') syntax is deprecated in MySQL 5.7 and is removed ...For information about the conditions under which this occurs for the server logs and how to control it, see Section 6.1.2.3, “Passwords and ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-installation.html
To avoid this overhead, do not install it unless you plan to use it. This section describes how to install or uninstall Version Tokens, which is implemented in a plugin library file containing a plugin and loadable functions. For general information ...
https://dev.mysql.com/doc/refman/5.7/en/xa-statements.html
gtrid and bqual must be string literals, each up to 64 bytes (not characters) long. You can use a quoted string ('ab'), hex string (X'6162', 0x6162), or bit value (b'nnnn'). To perform XA transactions in MySQL, use the following statements: XA ...