PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
[USING charset_name]) CHAR() interprets each argument N as an integer and returns a string consisting of the characters given by the code values of those integers. mysql> SELECT FORMAT(12332.123456, 4); -> '12,332.1235' mysql> SELECT ...For ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-reference.html
These audit log functions are available: audit_log_encryption_password_get([keyring_id]) This function fetches an audit log encryption password from the MySQL keyring, which must be enabled or an error occurs. Return value: The password string for ...Unless those objects are installed, the audit_log plugin operates in legacy mode (deprecated in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-usage.html
If the firewall is enabled, the server passes to it each incoming statement that does not immediately fail with a syntax error. Based on whether the firewall accepts the statement, the server executes it or returns an error to the client. If the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html
It can contain any of the ASCII characters having character codes 32, 35, 38, 40-91, 93, 95, and 97-126; in other words, it can use any printable ASCII characters except for !, ', ", $, %, \, and ^. --core-file Command-Line Format --core-file Write ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/8.0/en/revoke.html
With neither of these modifications, REVOKE either succeeds for all named users and roles, or rolls back and has no effect if any error occurs; the statement is written to the binary log only if it succeeds for all named users and roles. Otherwise, ...[IGNORE UNKNOWN USER] REVOKE [IF EXISTS] ALL [PRIVILEGES], GRANT OPTION FROM user_or_role [, user_or_role] ...
https://dev.mysql.com/doc/refman/8.0/en/xml-functions.html
No warnings or errors are issued by the server if a variable has the wrong type or has previously not been assigned a value. This also means the user is fully responsible for any typographical errors, since no warnings are given if (for example) ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
For a unique index, an error occurs regardless of SQL mode because reducing the index length might enable insertion of nonunique entries that do not meet the specified uniqueness requirement. An error occurs if a key part definition contains ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-what-is-new.html
Instead, use ndb_perror to obtain error message information from NDB error codes. Beginning with this release, MySQL NDB Cluster is being developed in parallel with the standard MySQL 8.0 server under a new unified release model with the following ... The following sections describe changes in the implementation of MySQL NDB Cluster in NDB Cluster 8.0 through 8.0.44, as compared to earlier release ...
https://dev.mysql.com/doc/refman/8.0/en/handler-scope.html
A specific handler is for a MySQL error code, SQLSTATE value, or condition name. For example, there might be a specific MySQL error code handler in an outer block, and a general SQLWARNING handler in an inner block. Or there might be handlers for a ...The condition raised by the statement goes unhandled and terminates the procedure with an error: mysql> CALL p4(); ERROR 1051 (42S02): Unknown table ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-mixed.html
The warning is shown both in the client (in the output of SHOW WARNINGS) and through the mysqld error log. However, only the first statement that generated the warning for each client session is written to the error log to prevent flooding the log.