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/declare-handler.html
statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... It can take the following forms: mysql_error_code: ...SQLSTATE [VALUE] sqlstate_value: A 5-character string literal indicating an SQLSTATE value, such as '42S01' to specify “unknown table”: DECLARE CONTINUE HANDLER FOR SQLSTATE '42S02' BEGIN -- body of handler END; Do not use SQLSTATE values that begin with '00' because those indicate success rather than an error ...
https://dev.mysql.com/doc/refman/8.0/en/problems-connecting.html
After a fresh installation, if you try to log on to the server as root without using a password, you might get the following error message. $> mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) It means ... If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can take to correct the ...
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/performance-schema-table-reference.html
The following table summarizes all available Performance Schema tables. For greater detail, see the individual table descriptions. Table 29.1 Performance Schema Tables Table Name Description Introduced accounts Connection statistics per client ...
https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html
check-table-functions: How to proceed when scanning data dictionary for functions used in table constraints and other expressions, and such a function causes an error. innodb_print_ddl_logs: Whether or not to print DDL logs to error log. Options ...
https://dev.mysql.com/doc/refman/8.0/en/bug-reports.html
If the problem occurs during compilation, include the exact error messages and also a few lines of context around the offending code in the file where the error occurs. If you get a parse error for an SQL statement, please check your syntax closely.
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/host-cache.html
The MySQL server maintains an in-memory host cache that contains information about clients: IP address, host name, and error information. The cache contains information about errors that occur during the client connection process. Some errors are ...The Performance Schema host_cache table exposes the contents of the host cache so that it can be examined using SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
If you specify --log-slave-updates or --slave-preserve-commit-order together with --skip-log-bin or --disable-log-bin, a warning or error message is issued. Setting this variable on the source to a value unrecognized by the replica causes the ...