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, 253🔥, 0💬
Popular Posts:
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...