PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/ddl-rewriter-installation.html
To install the ddl_rewriter plugin, use the INSTALL PLUGIN statement, adjusting the .so suffix for your platform as necessary: INSTALL PLUGIN ddl_rewriter SONAME 'ddl_rewriter.so'; To verify plugin installation, examine the Information Schema ...
https://dev.mysql.com/doc/refman/8.0/en/declare-cursor.html
For information available through SHOW statements, it is possible in many cases to obtain equivalent information by using a cursor with an INFORMATION_SCHEMA table. DECLARE cursor_name CURSOR FOR select_statement This statement declares a cursor ...
https://dev.mysql.com/doc/refman/8.0/en/describe.html
The DESCRIBE and EXPLAIN statements are synonyms, used either to obtain information about table structure or query execution plans. For more information, see Section 15.7.7.5, “SHOW COLUMNS Statement”, and Section 15.8.2, “EXPLAIN ...
https://dev.mysql.com/doc/refman/8.0/en/do.html
For example, DO id FROM t1 is invalid because it references a table. In most respects, DO is shorthand for SELECT expr, ..., but has the advantage that it is slightly faster when you do not care about the result. DO is useful primarily with ...
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. If system-installed SRSs are dropped, the SRS definitions may be recreated for MySQL upgrades. DROP SPATIAL REFERENCE SYSTEM [IF EXISTS] srid srid: 32-bit unsigned ...
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: ...