Collections:
RANDOM_BYTES() - Generating Random Bytes
How to generates random bytes using the RANDOM_BYTES() function?
✍: FYIcenter.com
RANDOM_BYTES(len) is a MySQL built-in function that generates random bytes of a given length. For example:
SELECT HEX(RANDOM_BYTES(16)), HEX(RANDOM_BYTES(16)); -- +----------------------------------+----------------------------------+ -- | HEX(RANDOM_BYTES(16)) | HEX(RANDOM_BYTES(16)) | -- +----------------------------------+----------------------------------+ -- | A81DAEC87FC92E7C630ED06A8AA04842 | 5ECF237CF5C416561665EBD68968B109 | -- +----------------------------------+----------------------------------+
Reference information of the RANDOM_BYTES() function:
RANDOM_BYTES(len): bin generates random bytes of a given length. Arguments, return value and availability: len: Required. The number of bytes to be generated. bin: Return value. The generated byte string. Available since MySQL 4.1.
⇐ MD5() - Calculating MD5 Hash
2023-12-14, 193🔥, 0💬
Popular Posts:
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...