How do we call MySQL stored procedures?

With the help of the CALL statement, we can call MySQL stored procedures. To make it understand, we are calling 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)

The above is the detailed content of How do we call MySQL stored procedures?. For more information, please follow other related articles on the PHP Chinese website!