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/drop-spatial-reference-system.html
If the SRID value is used by some column in an existing table, an error occurs. DROP SPATIAL REFERENCE SYSTEM [IF EXISTS] srid srid: 32-bit unsigned integer This statement removes a spatial reference system (SRS) definition from the data dictionary. Example: DROP SPATIAL REFERENCE SYSTEM 4120; If no SRS definition with the SRID value exists, an error occurs unless IF EXISTS is ...
https://dev.mysql.com/doc/refman/8.0/en/drop-user.html
It removes privilege rows for the account from all grant tables. The DROP USER statement removes one or more MySQL accounts and their privileges. Roles named in the mandatory_roles system variable value cannot be dropped. To use DROP USER, you must ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-usage.html
Key string values can be created at runtime and stored into a variable or table using SET, SELECT, or INSERT. To use MySQL Enterprise Encryption in applications, invoke the functions that are appropriate for the operations you wish to perform. In ...
https://dev.mysql.com/doc/refman/8.0/en/error-creating-innodb.html
Initialization Problems If something goes wrong when InnoDB attempts to initialize its tablespace or its log files, delete all files created by InnoDB: all ibdata files and all redo log files (#ib_redoN files in MySQL 8.0.30 and higher or ib_logfile ... The troubleshooting steps for InnoDB I/O problems depend on when the problem occurs: during startup of the MySQL server, or during normal operations when a DML or DDL statement fails due to problems at the file system ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-event-fields.html
Error events intended for the error log contain a set of fields, each of which consists of a key/value pair. An event field may be classified as core, optional, or user-defined: A core field is set up automatically for error events. However, its ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-priority-based-filtering.html
The log_error_verbosity system variable controls verbosity based on which priorities to permit for messages written to the log, as shown in the following table. The log_filter_internal log filter component implements a simple form of log filtering ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-rule-based-filtering.html
The log_filter_dragnet log filter component enables log filtering based on user-defined rules. To enable the log_filter_dragnet filter, first load the filter component, then modify the log_error_services value. The following example enables ...
https://dev.mysql.com/doc/refman/8.0/en/error-message-elements.html
It is MySQL-specific and is not portable to other database systems. Error codes are stable across General Availability (GA) releases of a given MySQL series. This section discusses how error messages originate within MySQL and the elements they ...
https://dev.mysql.com/doc/refman/8.0/en/example-user-variables.html
You can employ MySQL user variables to remember results without having to store them in temporary variables in the client.
https://dev.mysql.com/doc/refman/8.0/en/explain-for-connection.html
connection_id is the connection identifier, as obtained from the INFORMATION_SCHEMA PROCESSLIST table or the SHOW PROCESSLIST statement. To obtain the execution plan for an explainable statement executing in a named connection, use this statement: ...