Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-function-loadable.html
CREATE [AGGREGATE] FUNCTION [IF NOT EXISTS] function_name RETURNS {STRING|INTEGER|REAL|DECIMAL} SONAME shared_library_name This statement loads the loadable function named function_name. (CREATE FUNCTION is also used to created stored functions; ...
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
For example, if a function specifies an ENUM or SET value in the RETURNS clause, but the RETURN statement returns an integer, the value returned from the function is the string for the corresponding ENUM member of set of SET members. By default, a ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
The size and sign of fixed precision types such as INTEGER and DECIMAL must be the same. Typically, you leave this variable enabled during normal operation to enforce referential integrity. MySQL supports foreign keys, which permit ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-ndb-comment-options.html
Syntax for these options is shown here: COMMENT 'NDB_COLUMN=speclist' speclist := spec[,spec] spec := BLOB_INLINE_SIZE=value | MAX_BLOB_PART_SIZE[={0|1}] BLOB_INLINE_SIZE specifies the number of bytes to be stored inline by the column; its expected ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-usage.html
gen_range() returns a random integer selected from a given range: mysql> SELECT gen_range(1, 10); +------------------+ | gen_range(1, 10) | +------------------+ | 6 | +------------------+ gen_rnd_canada_sin() returns a random Canadian Social ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-variables.html
The MySQL Enterprise Data Masking and De-Identification components support the following system variables. Variables are unavailable unless the appropriate MySQL Enterprise Data Masking and De-Identification components are installed (see Section ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-components-vs-plugin.html
Previously, MySQL enabled masking and de-identification capabilities using a server-side plugin, but transitioned to use the component infrastructure as an alternative implementation. The following table briefly compares MySQL Enterprise Data ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-installation.html
This section describes how to install or uninstall MySQL Enterprise Data Masking and De-Identification, which is implemented as a plugin library file containing a plugin and several loadable functions. For general information about installing or ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-usage.html
Before using MySQL Enterprise Data Masking and De-Identification, install it according to the instructions provided at Section 8.5.3.1, “MySQL Enterprise Data Masking and De-Identification Plugin Installation”. To use MySQL Enterprise Data ...
https://dev.mysql.com/doc/refman/8.4/en/data-size.html
For example, use the smaller integer types if possible to get smaller tables. Design your tables to minimize their space on the disk. This can result in huge improvements by reducing the amount of data written to and read from disk. Smaller tables ...