MySQL Functions for Encryption and Compression

Q

Where to find reference information and tutorials on MySQL database functions for Encryption and Compression? I want to know how to use COMPRESS(), ENCRYPT() and other related functions.

✍: FYIcenter.com

A

Here is a collection of reference information and tutorials on MySQL database functions for Encryption and Compression compiled by FYIcenter.com DBA team.

AES_DECRYPT() - AES Data Decryption

AES_ENCRYPT() - AES Data Encryption

COMPRESS() - Compressing Data

CRC32() - Cyclic Redundancy Check 32-Bit

MD5() - Calculating MD5 Hash

RANDOM_BYTES() - Generating Random Bytes

SHA() - Synonym for SHA1()

SHA1() - Calculating SHA-1 Hash

SHA2() - Calculating SHA-2 Hash

STATEMENT_DIGEST() - Statement Digest Hash

STATEMENT_DIGEST_TEXT() - Calculating Statement Digest

UNCOMPRESS() - Uncompressing Data

UNCOMPRESSED_LENGTH() - Uncompressed Data Length

VALIDATE_PASSWORD_STRENGTH() - Password Strength Test

⇒ AES_DECRYPT() - AES Data Decryption

⇐ JSON_VALUE() - Converting JSON Value

⇑⇑ MySQL Function References

2025-03-12, 2950🔥, 0💬

JSON_UNQUOTE() - Unquoting JSON String
How to convert a JSON (JavaScript Object Notation) quoted string into a regular character string using the JSON_UNQUOTE() function? JSON_UNQUOTE(json) is a MySQL built-in function that converts a JSON string into a regular character string, by removing the enclosing double-quotes and restoring any e... 2025-03-12, 3227🔥, 0💬

JSON_SET() - Inserting/updating JSON Child Members
How to insert or update child members of a JSON (JavaScript Object Notation) value using the JSON_SET() function? JSON_SET(json, path1, val1, path2, val2, ...) is a MySQL built-in function that inserts child members of a JSON value at given new locations, and replaces child numbers at given existing... 2025-03-12, 3131🔥, 0💬

JSON_OVERLAPS() - Checking JSON Overlaps
How to check if two JSON values have overlaps using the JSON_OVERLAPS() function? JSON_OVERLAPS(json1, json2) is a MySQL built-in function that detects overlaps of two JSON values using the following rules: If both arguments are objects, overlap means they have at least one key-value pair in common.... 2024-12-18, 2961🔥, 0💬

MySQL Functions for Encryption and Compression
Where to find reference information and tutorials on MySQL database functions for Encryption and Compression? I want to know how to use COMPRESS(), ENCRYPT() and other related functions. Here is a collection of reference information and tutorials on MySQL database functions for Encryption and Compre... 2025-03-12, 2951🔥, 0💬

JSON_TYPE() - Detecting Type of JSON Value
How to detect the type of a JSON (JavaScript Object Notation) value using the JSON_TYPE() function? JSON_TYPE(json) is a MySQL built-in function that returns the data type of a JSON (JavaScript Object Notation) value. For example: SELECT JSON_TYPE('[]'), JSON_TYPE('{}'); -- +-----------------+------... 2025-03-12, 2458🔥, 0💬

VALIDATE_PASSWORD_STRENGTH() - Password Strength Test
How to test the strength of a password using the VALIDATE_PASSWORD_STRENGTH() function? VALIDATE_PASSWORD_STRENGTH(pas sword)is a MySQL built-in function that calculates the strength of a given password. It requires validate_password plugin component to be installed. For example: SELECT VALIDATE_PAS... 2024-12-18, 2335🔥, 0💬

UNCOMPRESS() - Uncompressing Data
How to uncompress (restore) compressed data using the UNCOMPRESS() function? UNCOMPRESS(str) is a MySQL built-in function that uncompresses a given compressed byte string using the default LZ77 compression algorithm. For example: SELECT UNCOMPRESS(x'37000000789C738BF 44C4ECD2B492DD24BCECFD57123960 700... 2024-12-18, 2184🔥, 0💬

JSON_STORAGE_FREE() - Free Space in JSON Value
How to obtain the free space size in a JSON table column using the JSON_STORAGE_FREE() function? JSON_STORAGE_FREE(json) is a MySQL built-in function that returns the free space size in a JSON table column. Free space occurs when JSON table column is partially updated with less data. For example: CR... 2024-12-18, 1882🔥, 0💬

UNCOMPRESSED_LENGTH() - Uncompressed Data Length
How to calculate the original data length of a compressed byte string using the UNCOMPRESSED_LENGTH() function? UNCOMPRESSED_LENGTH(str) is a MySQL built-in function that returns the original data length of a given compressed byte string. For example: SET @bin = x'37000000789C738BF44C4ECD2B49 2DD24BC... 2024-12-18, 1817🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.