Collections:
RAND() - Random Value Generator
How to generate a random value using the RAND() function?
✍: FYIcenter.com
RAND(s) is a MySQL built-in function that returns the random value. For example:
SELECT RAND(), RAND(), RAND(3.14); -- +--------------------+--------------------+--------------------+ -- | RAND() | RAND() | RAND(3.14) | -- +--------------------+--------------------+--------------------+ -- | 0.5206212648382609 | 0.5714487923043303 | 0.9057697559760601 | -- +--------------------+--------------------+--------------------+
Reference information of the RAND() function:
RAND(s): v Returns a random floating-point value v in the range 0 <= v < 1.0 Arguments, return value and availability: s: Optional. The seed value used in the random generation algorithm v: Return value. The random value Available since MySQL 4.0.
⇒ ROUND() - Rounding to Decimal Place
⇐ RADIANS() - Degrees to Radians
2023-11-14, 256🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...