How can we invoke MySQL stored procedure?

With the help of the CALL statement, we can invoke the MySQL stored procedure. To make it understand we are invoking the allrecords() stored procedure −

mysql> CALL allrecords();
+------+---------+------------+------------+
| id   | Name    | Address    | Subject    |
+------+---------+------------+------------+
| 100  | Aarav   | Delhi      | Computers  |
| 101  | YashPal | Amritsar   | History    |
| 105  | Gaurav  | Jaipur     | Literature |
| 110  | Rahul   | Chandigarh | History    |
+------+---------+------------+------------+
4 rows in set (0.00 sec)
Query OK, 0 rows affected (0.01 sec)

Priya Pallavi

Published on 21-Feb-2018 07:35:46

• Related Questions & Answers
• How can we alter a MySQL stored procedure?
• How can we drop a MySQL stored procedure?
• What is stored procedure and how can we create MySQL stored procedures?
• How can we perform START transactions inside MySQL stored procedure?
• How can we perform COMMIT transactions inside MySQL stored procedure?
• How can we write MySQL handler in a stored procedure?
• How can a MySQL stored procedure call another MySQL stored procedure inside it?
• How can we create MySQL stored procedure to calculate the factorial?
• How can we perform ROLLBACK transactions inside a MySQL stored procedure?
• How can we handle a result set inside MySQL stored procedure?
• How can we see the source code of a particular MySQL stored procedure?
• How can we use prepared statements in a stored procedure?
• How can user variables be used in MySQL stored procedure?
• How Can MySQL CASE statement be used in stored procedure?
• How can I create MySQL stored procedure with IN parameter?