How to select return value from MySQL prepared statement?

Let us create a stored procedure and select return value from MySQL prepared statement −

mysql> DELIMITER //
mysql> CREATE PROCEDURE return_value()
   -> BEGIN
   ->   SET @returnQuery= 'SELECT 98 INTO @value';
   ->   PREPARE stmt FROM @returnQuery;
   ->   EXECUTE stmt;
   -> END
   -> //
Query OK, 0 rows affected (0.20 sec)

mysql> DELIMITER ;

Call stored procedure using CALL command.

mysql> call return_value();
Query OK, 1 row affected (0.07 sec)

Display value using select statement −

mysql> select @value;

output

This will produce the following output −

+--------+
| @value |
+--------+
|     98 |
+--------+
1 row in set (0.00 sec)

Rama Giri

Published on 11-Jul-2019 12:04:25

• Related Questions & Answers
• How to use prepared statement for select query in Java with MySQL?
• Change value from 1 to Y in MySQL Select Statement?
• Storing value from a MySQL SELECT statement to a variable?
• Assign an SQL result to variable from prepared statement in MySQL?
• Change value from 1 to Y in MySQL Select Statement using CASE?
• Return maximum value from records in MySQL
• Using Prepared statement correctly with WHERE condition in case of any value in MySQL Java
• MySQL case statement inside a select statement?
• How to use NULL in MySQL SELECT statement?
• How to select distinct value from one MySQL column only?
• How to create Tab Delimited Select statement in MySQL?
• How to replace values of select return in MySQL?
• How to select unique value in MySQL?
• MySQL SELECT IF statement with OR?
• How to return table from MySQL function?