Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-masking.html
Note MySQL Enterprise Data Masking and De-Identification is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition provides data masking and de-identification capabilities: Transformation of existing data ...
https://dev.mysql.com/doc/refman/8.4/en/database-use.html
Once you know how to enter SQL statements, you are ready to access a database. Suppose that you have several pets in your home (your menagerie) and you would like to keep track of various types of information about them. You can do so by creating ...
https://dev.mysql.com/doc/refman/8.4/en/ddl-rewriter-options.html
This section describes the command options that control operation of the ddl_rewriter plugin. If values specified at startup time are incorrect, the ddl_rewriter plugin may fail to initialize properly and the server does not load it. To control ...
https://dev.mysql.com/doc/refman/8.4/en/ddl-rewriter.html
MySQL 8.4 includes a ddl_rewriter plugin that modifies CREATE TABLE statements received by the server before it parses and executes them. The plugin removes ENCRYPTION, DATA DIRECTORY, and INDEX DIRECTORY clauses, which may be helpful when ...
https://dev.mysql.com/doc/refman/8.4/en/deallocate-prepare.html
{DEALLOCATE | DROP} PREPARE stmt_name To deallocate a prepared statement produced with PREPARE, use a DEALLOCATE PREPARE statement that refers to the prepared statement name. Attempting to execute a prepared statement after deallocating it 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/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 ...