Search Results
https://dev.mysql.com/doc/refman/8.4/en/declare-cursor.html
DECLARE cursor_name CURSOR FOR select_statement This statement declares a cursor and associates it with a SELECT statement that retrieves the rows to be traversed by the cursor. The number of columns retrieved by the SELECT statement must match the ...
https://dev.mysql.com/doc/refman/8.4/en/deploy-mysql-nonlinux-docker.html
Warning The MySQL Docker images provided by Oracle are built specifically for Linux platforms. Other platforms are not supported, and users running the MySQL Docker images from Oracle on them are doing so at their own risk. This section discusses ...
https://dev.mysql.com/doc/refman/8.4/en/derived-condition-pushdown-optimization.html
When a derived table cannot be merged into the outer query (for example, if the derived table uses aggregation), pushing the outer WHERE condition down to the derived table should decrease the number of rows that need to be processed and thus speed ...
https://dev.mysql.com/doc/refman/8.4/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.6, “SHOW COLUMNS Statement”, and Section 15.8.2, “EXPLAIN ...
https://dev.mysql.com/doc/refman/8.4/en/drop-resource-group.html
DROP RESOURCE GROUP group_name [FORCE] DROP RESOURCE GROUP is used for resource group management (see Section 7.1.16, “Resource Groups”). The FORCE modifier determines statement behavior if the resource group has any threads assigned to it: If ...
https://dev.mysql.com/doc/refman/8.4/en/drop-role.html
DROP ROLE removes one or more roles (named collections of privileges). To use this statement, you must have the global DROP ROLE or CREATE USER privilege. When the read_only system variable is enabled, DROP ROLE additionally requires the ...
https://dev.mysql.com/doc/refman/8.4/en/drop-trigger.html
DROP TRIGGER [IF EXISTS] [schema_name.]trigger_name This statement drops a trigger. If the schema is omitted, the trigger is dropped from the default schema. DROP TRIGGER requires the TRIGGER privilege for the table associated with the trigger. Use ...
https://dev.mysql.com/doc/refman/8.4/en/enterprise-encryption-function-reference.html
MySQL Enterprise Encryption functions are provided by the MySQL component_enterprise_encryption component.
https://dev.mysql.com/doc/refman/8.4/en/enterprise-encryption-usage.html
To use MySQL Enterprise Encryption in applications, invoke the functions that are appropriate for the operations you wish to perform. MySQL Enterprise Encryption functions are provided by a MySQL component component_enterprise_encryption. For ...
https://dev.mysql.com/doc/refman/8.4/en/error-access-denied.html
Often the problem is related to the MySQL accounts that the server permits client programs to use when connecting. See Section 8.2, “Access Control and Account Management”, and Section 8.2.22, “Troubleshooting Problems Connecting to MySQL”.