Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-masking-components-installation.html
$> mysql -u root -p -D mysql < [path/]masking_functions_install.sql Enter password: (enter root password here) Install Using a Dedicated Schema To set up MySQL Enterprise Data Masking and De-Identification: Create a database to store the ...
https://dev.mysql.com/doc/refman/8.4/en/declare-local-variable.html
type [DEFAULT value] This statement declares local variables within stored programs. Local variables are treated like stored routine parameters with respect to data type and overflow checking. To provide a default value for a variable, include a ...
https://dev.mysql.com/doc/refman/8.4/en/drop-function.html
The DROP FUNCTION statement is used to drop stored functions and loadable functions: For information about dropping stored functions, see Section 15.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”. For information about dropping loadable ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
These tables are set up automatically in all install, upgrade, and build-from-source procedures. The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so ...
https://dev.mysql.com/doc/refman/8.4/en/lock-tables.html
LIKE, CREATE VIEW, DROP VIEW, and DDL statements on stored functions and procedures and events. LOCK TABLES and UNLOCK TABLES cannot be used within stored programs. LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-schema.html
If the ndb_apply_status table does not exist on the replica, ndb_restore re-creates it. This information is captured in an NDB online backup, but (by design) it is not restored by ndb_restore. In some cases, it can be helpful to restore this ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-tips.html
This section surveys techniques that enable you to use mysqldump to solve specific problems: How to make a copy a database How to copy a database from one server to another How to dump stored programs (stored procedures and functions, triggers, and ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations.html
The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or plugins. This section discusses current restrictions and limitations on MySQL partitioning support. For a list of ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-tables.html
Query results can be saved in tables for further analysis, or assigned to variables and thus used in stored procedures. The replication tables store errors on a per-thread basis without loss of information. This is similar to the information ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids.html
A general procedure for setting up and starting GTID-based replication (see Section 19.1.3.4, “Setting Up Replication Using GTIDs”). Stored functions that you can use to work with GTIDs (see Section 19.1.3.8, “Stored Function Examples to ...