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/mysqlpump.html
If --add-drop-database is used with --all-databases or with --databases where the list of schemas to be dumped includes mysql, the dump file contains a DROP DATABASE `mysql` statement that causes an error when the dump file is reloaded. If the file ... mysqlpump Invocation Syntax mysqlpump Option Summary mysqlpump Option Descriptions mysqlpump Object Selection mysqlpump Parallel Processing mysqlpump Restrictions The mysqlpump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.0/en/declare-condition.html
DECLARE condition_name CONDITION FOR condition_value condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value } The DECLARE ... It can take the following forms: mysql_error_code: An integer literal indicating a MySQL error code. Do not ...CONDITION statement declares a named error condition, associating a name with a condition that needs specific ...
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html
For additional connection-related information, check the Connection_errors_xxx status variables and the host_cache table. All Com_stmt_xxx variables are increased even if a prepared statement argument is unknown or an error occurred during execution. Connection_errors_xxx These variables provide information about errors that occur during the client connection ...
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/performance-schema-system-variables.html
performance_schema_error_size Command-Line Format --performance-schema-error-size=# System Variable performance_schema_error_size Scope Global Dynamic No SET_VAR Hint Applies No Type Integer Default Value number of server error codes Minimum Value 0 ...Although the value can be set anywhere from 0 to its maximum, the intended use is to set it to either its default (to instrument all errors) or 0 (to instrument no ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-functions.html
Return value: The masked Social Security number as a string, or an error if the argument is not the correct length. For example, gen_rnd_us_phone() returns a US phone number that uses the 555 area code, which is not assigned to phone numbers in ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-status-by-coordinator-table.html
All error codes and messages displayed in the LAST_ERROR_NUMBER and LAST_ERROR_MESSAGE columns correspond to error values listed in Server Error Message Reference. LAST_ERROR_NUMBER, LAST_ERROR_MESSAGE The error number and error message of the most ... For a multithreaded replica, the replica uses multiple worker threads and a coordinator thread to manage them, and this table shows the status of the coordinator ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html
In this case, the server writes the SELECT statement to the log along with the expected error code. If this is not the case, an error is generated and the function does not run, unless log_bin_trust_function_creators=1 is specified to override this ... The binary log contains information about SQL statements that modify database ...
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-usage.html
A token mismatch between the server and client token lists occurs and the server returns an error in reply to the statement. The client-side logic for detecting version token errors and selecting a new server can be implemented different ways: The ... Before using Version Tokens, install it according to the instructions provided at Section 7.6.6.2, “Installing or Uninstalling Version ...
https://dev.mysql.com/doc/refman/8.0/en/gis-polygon-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 ...