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)

Updated on: 22-Jun-2020

189 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements