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/performance-schema-error-summary-tables.html
row *************************** ERROR_NUMBER: 1064 ERROR_NAME: ER_PARSE_ERROR SQL_STATE: 42000 SUM_ERROR_RAISED: 1 SUM_ERROR_HANDLED: 0 FIRST_SEEN: 2016-06-28 07:34:02 LAST_SEEN: 2016-06-28 07:34:02 *************************** 2. The Performance ...
https://dev.mysql.com/doc/refman/8.0/en/show-procedure-code.html
SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have been built with debugging support. A similar statement, SHOW FUNCTION CODE, displays information about stored functions (see Section ...
https://dev.mysql.com/doc/refman/8.0/en/show-function-code.html
SHOW FUNCTION CODE func_name This statement is similar to SHOW PROCEDURE CODE but for stored functions.
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
Setting the SQL Mode The default SQL mode in MySQL 8.0 includes these modes: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, and NO_ENGINE_SUBSTITUTION. A simple description of this mode is “give ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/doc/refman/8.0/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. These elements have the following characteristics: Error code: This value is numeric. The set of error codes ... This section discusses how error messages originate within MySQL and the elements they ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-configuration.html
In MySQL 8.0, error logging uses the MySQL component architecture described at Section 7.5, “MySQL Components”. The error log subsystem consists of components that perform log event filtering and writing, as well as a system variable that ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
If, when creating tables with a large number of partitions (but less than the maximum), you encounter an error message such as Got error ... However, this is dependent on the operating system, and may not be possible or advisable on all platforms; ... This section discusses current restrictions and limitations on MySQL partitioning ...
https://dev.mysql.com/doc/refman/8.0/en/error-interfaces.html
Error messages can originate on the server side or the client side, and each error message includes an error code, SQLSTATE value, and message string, as described in Section B.1, “Error Message Sources and Elements”. For error checking from ...
https://dev.mysql.com/doc/refman/8.0/en/function-resolution.html
This occurs even when the function name is used in nonexpression context: mysql> CREATE TABLE count(i INT); ERROR 1064 (42000): You have an error in your SQL syntax ... The name can be used in function calls with or without following whitespace, but ... MySQL supports built-in (native) functions, loadable functions, and stored ...
https://dev.mysql.com/doc/refman/8.0/en/index-hints.html
With statement-based binary logging, having different modes for the source and replicas might lead to replication errors. Index hints give the optimizer information about how to choose indexes during query processing. Index hints, described here, ...