Search Results
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-formats.html
Only top-level statements are logged, not statements within stored programs such as triggers or stored procedures. The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event occurs. Typically ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-restrictions.html
Only top-level statements are logged, not statements within stored programs such as triggers or stored procedures. MySQL Enterprise Audit is subject to these general restrictions: Only SQL statements are logged. Changes made by no-SQL APIs, such as ...
https://dev.mysql.com/doc/refman/8.4/en/charset-database.html
For stored routines (procedures and functions), the database character set and collation in effect at routine creation time are used as the character set and collation of character data parameters for which the declaration includes no CHARACTER SET ...Database options are stored in the data dictionary and can be examined by checking the Information Schema SCHEMATA ...
https://dev.mysql.com/doc/refman/8.4/en/create-function.html
The CREATE FUNCTION statement is used to create stored functions and loadable functions: For information about creating stored functions, see Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”. For information about creating ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-schema.html
However, MySQL supports access to data stored in data dictionary tables through INFORMATION_SCHEMA tables and SHOW statements. Upgrading MySQL system tables requires running the full MySQL upgrade procedure. At startup, the data dictionary version ... Data dictionary tables are protected and may only be accessed in debug builds of ...
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] ...