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/problems.html
This section lists some common problems and error messages that you may encounter. It describes how to determine the causes of the problems and what to do to solve them.
https://dev.mysql.com/doc/refman/8.0/en/show-replica-status.html
In MySQL 8.0, all error codes and messages displayed in the Last_SQL_Errno and Last_SQL_Error columns correspond to error values listed in Server Error Message Reference. Note When the replication SQL thread receives an error, it reports the error ... SHOW {REPLICA | SLAVE} STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica ...
https://dev.mysql.com/doc/refman/8.0/en/json-table-functions.html
name type PATH string_path [on_empty] [on_error]: Columns of this type are used to extract values specified by string_path. Saving an object or array triggers the optional on error clause; this also occurs when an error takes place during coercion ... This section contains information about JSON functions that convert JSON data to tabular ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-functions.html
Return value: The masked Canada SIN as a string encoded in the utf8mb4 character set, an error if the argument is not the correct length, or NULL if str is in incorrect format or contains a multibyte character. Return value: The masked International ...Example: mysql> SELECT mask_canada_sin('046-454-286'), mask_canada_sin('abcdefijk'); +--------------------------------+------------------------------+ | mask_canada_sin('046-454-286') | mask_canada_sin('abcdefijk') | +--------------------------------+------------------------------+ | XXX-XXX-XXX | XXXXXXXXX | +--------------------------------+------------------------------+ mysql> SELECT mask_canada_sin('909'); ERROR 1123 (HY000): Can't initialize function 'mask_canada_sin'; Argument 0 is too ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-repair.html
Symptoms of corrupted tables include queries that abort unexpectedly and observable errors such as these: Can't find file tbl_name.MYI (Errcode: nnn) Unexpected end of file Record file is crashed Got error nnn from table handler To get more ...This ... The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html
To see the associations between error codes, SQLSTATE values, and messages, see Server Error Message Reference. Example: <STATUS>1051</STATUS> <STATUS_CODE> An unsigned integer representing the command status: 0 for success, 1 if an error occurred.
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
For example, you might change the port that memcached listens on, reduce the maximum number of simultaneous connections, change the maximum memory size for a key-value pair, or enable debugging messages for the error log. When specifying a file name ... InnoDB Startup Options InnoDB System Variables System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-convenience-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/mysql-cluster-logs-cluster-log.html
[Occurred during startphase start_phase.] [ Initiated by signal.] [Caused by error error_code: 'error_message(error_classification). In the event of arbitration failure, an error_message and an arbitration state_code are provided; definitions for ...
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
An error occurs if the table exists, if there is no default database, or if the database does not exist. IF NOT EXISTS Prevents an error from occurring if the table exists. For a unique index, an error occurs regardless of SQL mode because reducing ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...