<< < 51 52 53 54 55 56   ∑:1328  Sort:Date

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, 461🔥, 0💬

SYSTEM_USER() - Synonym for USER()
What's the difference between SYSTEM_USER() and USER() functions? SYSTEM_USER() is a synonym for the USER() function. Related MySQL functions: USER() - Login Name of Current User SESSION_USER() - Synonym for USER() SYSTEM_USER() - Synonym for USER() CURRENT_USER() - Authentication Name of Current Us...
2025-01-07, 460🔥, 0💬

IS_FREE_LOCK() - Checking Lock Status
How to check the status of a user defined lock using the IS_FREE_LOCK() function? IS_FREE_LOCK(lock) is a MySQL built-in function that returns 1 if a given user lock is free, 0 otherwise. For example: SELECT GET_LOCK('MyLock', 60), IS_FREE_LOCK('MyLock'); -- +------------------------+---- -----------...
2023-12-20, 460🔥, 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, 459🔥, 0💬

USER() - Login Name of Current User
How to obtain the login name of the current user using the USER() function? USER() is a MySQL built-in function that returns the login name of the current user. Login name is defined as the combination of user name and the client IP address where you logged in from. For example: SELECT USER(); -- +-...
2025-01-07, 450🔥, 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, 439🔥, 0💬

BIN() - Converting Integer to Binary String
How to convert an integer to a binary string using the BIN() function? BIN(int) is a MySQL built-in function that converts an integer to binary string. For example: SELECT BIN(1), BIN(2), BIN(4), BIN(8), BIN(16), BIN(1024); -- +--------+--------+--------+-- ------+---------+------------- +-- | BIN(1)...
2024-11-23, 417🔥, 0💬

SESSION_USER() - Synonym for USER()
What's the difference between SESSION_USER() and USER() functions? SESSION_USER() is a synonym for the USER() function. Related MySQL functions: USER() - Login Name of Current User SESSION_USER() - Synonym for USER() SYSTEM_USER() - Synonym for USER() CURRENT_USER() - Authentication Name of Current ...
2025-01-07, 393🔥, 0💬

<< < 51 52 53 54 55 56   ∑:1328  Sort:Date