- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Create a MySQL stored procedure that generates five random numbers?
With the help of the following query we can create a stored procedure to generate five random numbers −
mysql> DELIMITER // mysql> DROP PROCEDURE IF EXISTS RandomNumbers; -> CREATE PROCEDURE RandomNumbers() -> BEGIN -> SET @i = 0; -> REPEAT -> SELECT RAND() AS 'Random Number'; -> SET @i = @i + 1; -> UNTIL @i >=5 END REPEAT; -> END -> // Query OK, 0 rows affected (0.16 sec) Query OK, 0 rows affected (0.16 sec)
Now, invoke the procedure to get the result −
mysql> DELIMITER ; mysql> CALL RandomNumbers(); +---------------------+ | Random Number | +---------------------+ | 0.25968261739209536 | +---------------------+ 1 row in set (0.00 sec) +--------------------+ | Random Number | +--------------------+ | 0.1659662734400167 | +--------------------+ 1 row in set (0.01 sec) +---------------------+ | Random Number | +---------------------+ | 0.05078354575744229 | +---------------------+ 1 row in set (0.01 sec) +--------------------+ | Random Number | +--------------------+ | 0.7560189392008064 | +--------------------+ 1 row in set (0.04 sec) +------------------+ | Random Number | +------------------+ | 0.62774408946535 | +------------------+ 1 row in set (0.04 sec) Query OK, 0 rows affected (0.05 sec)
Updated on 22-Jun-2020 08:14:24
- Related Questions & Answers
- How to generate 5 random numbers in MySQL stored procedure?
- MySQL Stored Procedure to create a table?
- Create a stored procedure with delimiter in MySQL
- How can I create a MySQL stored procedure that returns multiple values from a MySQL table?
- How can a MySQL stored procedure call another MySQL stored procedure inside it?
- Create a MySQL stored procedure that counts the number of rows gets affected by MySQL query?
- MySQL stored procedure to execute SHOW CREATE TABLE?
- Create variables in MySQL stored procedure with DECLARE keyword
- What is STORED PROCEDURE in a DB2? How will you create a new stored procedure?
- What is stored procedure and how can we create MySQL stored procedures?
- Create a table inside a MySQL stored procedure and insert a record on calling the procedure
- MySQL stored procedure return value?
- MySQL stored-procedure: out parameter?
- How to create MongoDB stored procedure?
- Set conditions in a MySQL stored procedure
Advertisements