Home  >  Article  >  Database  >  How do we call MySQL stored procedures?

How do we call MySQL stored procedures?

WBOY
WBOYforward
2023-08-29 22:09:061406browse

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!

Statement:
This article is reproduced at:tutorialspoint.com. If there is any infringement, please contact admin@php.cn delete