https://dev.mysql.com/data-masking-usage.html
Before using MySQL Enterprise Data Masking and De-Identification, install it according to the instructions provided at Section 6.4.8.2, “Installing or Uninstalling MySQL Enterprise Data Masking and De-Identification”. To use MySQL Enterprise ...
https://dev.mysql.com/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 ...
https://dev.mysql.com/data-types.html
Data type descriptions use these conventions: For integer types, M indicates the maximum display width. MySQL supports SQL data types in several categories: numeric types, date and time types, string (character and byte) types, spatial types, and ...
https://dev.mysql.com/date-and-time-type-conversion.html
To some extent, you can convert a value from one temporal type to another. However, there may be some alteration of the value or loss of information. In all cases, conversion between temporal types is subject to the range of valid values for the ...
https://dev.mysql.com/datetime.html
This section describes their characteristics, how they are similar, and how they differ. MySQL recognizes DATE, DATETIME, and TIMESTAMP values in several formats, described in Section 9.1.3, “Date and Time Literals”. For the DATE and DATETIME ...
https://dev.mysql.com/declare-condition.html
It can take the following forms: mysql_error_code: An integer literal indicating a MySQL error code. DECLARE condition_name CONDITION FOR condition_value condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value } The DECLARE ...
https://dev.mysql.com/declare-handler.html
It can take the following forms: mysql_error_code: An integer literal indicating a MySQL error code, such as 1051 to specify “unknown table”: DECLARE CONTINUE HANDLER FOR 1051 BEGIN -- body of handler END; Do not use MySQL error code 0 because ...statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ...
https://dev.mysql.com/document-store-concepts.html
This section explains the concepts introduced as part of using MySQL as a document store. JSON Document Collection CRUD Operations A JSON document is a data structure composed of key-value pairs and is the fundamental structure for using MySQL as ...
https://dev.mysql.com/encryption-functions.html
mysql> SELECT UNCOMPRESSED_LENGTH(COMPRESS(REPEAT('a',30))); -> 30 VALIDATE_PASSWORD_STRENGTH(str) Given an argument representing a plaintext password, this function returns an integer to indicate how strong the password is. If you want to store ...
https://dev.mysql.com/enterprise-encryption-installation.html
MySQL Enterprise Encryption functions are located in a user-defined function (UDF) library file installed in the plugin directory (the directory named by the plugin_dir system variable). The UDF library base name is openssl_udf and the suffix is ...
