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/out-of-range-and-overflow.html
If strict SQL mode is enabled, an error occurs and the column remains unchanged. If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead. When an ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-usage.html
If a rule cannot be loaded due to some error, calling flush_rewrite_rules() produces an error: mysql> CALL query_rewrite.flush_rewrite_rules(); ERROR 1644 (45000): Loading of some rule(s) failed. When this occurs, the plugin writes an error message ... To enable or disable the plugin, enable or disable the rewriter_enabled system ...
https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html
If the argument size exceeds 511 bytes, an ER_INVALID_BITWISE_AGGREGATE_OPERANDS_SIZE error occurs. If the argument size exceeds 511 bytes, an ER_INVALID_BITWISE_AGGREGATE_OPERANDS_SIZE error occurs. If the argument size exceeds 511 bytes, an ...
https://dev.mysql.com/doc/refman/8.0/en/change-master-to.html
The presence of such characters in these values causes the statement to fail with an error. CHANGE MASTER TO causes the previous values for MASTER_HOST, MASTER_PORT, MASTER_LOG_FILE, and MASTER_LOG_POS to be written to the error log, along with ...] ...
https://dev.mysql.com/doc/refman/8.0/en/create-user.html
As of MySQL 8.0.22, CREATE USER fails with an error if any account to be created is named as the DEFINER attribute for any stored object. (That is, the statement fails if creating an account would cause the account to adopt a currently orphaned ...
https://dev.mysql.com/doc/refman/8.0/en/data-directory-initialization.html
Note The server writes any messages (including any initial password) to its standard error output. This may be redirected to the error log, so look there if you do not see the messages on your screen. For information about the error log, including ... After MySQL is installed, the data directory must be initialized, including the tables in the mysql system schema: For some MySQL installation methods, data directory initialization is automatic, as described in Section 2.9, “Postinstallation Setup and ...
https://dev.mysql.com/doc/refman/8.0/en/gis-general-property-functions.html
If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. If any geometry argument is a syntactically well-formed geometry in an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error ...
https://dev.mysql.com/doc/refman/8.0/en/gis-point-property-functions.html
If any geometry argument is a valid geometry but not a Point object, an ER_UNEXPECTED_GEOMETRY_TYPE error occurs. If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. If any geometry argument is ... A Point consists of X and Y coordinates, which may be obtained using the ST_X() and ST_Y() functions, ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-system-variables.html
If an attempted runtime assignment to keyring_encrypted_file_data results in an error, the variable value remains unchanged. If an attempted runtime assignment to keyring_file_data results in an error, the variable value remains unchanged. If an ...
https://dev.mysql.com/doc/refman/8.0/en/lock-tables.html
With auto-reconnect disabled, if the connection drops, an error occurs for the next statement issued. The client can detect the error and take appropriate action such as reacquiring the locks or redoing the transaction. For example, if you attempt a ... LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ...