借助CALL语句,我们可以调用MySQL存储过程。为了让它理解,我们正在调用 allrecords() 存储过程 -
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)