借助CALL語句,我們可以調(diào)用MySQL存儲(chǔ)過程。為了讓它理解,我們正在調(diào)用 allrecords() 存儲(chǔ)過程 –
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)
登錄后復(fù)制
以上就是我們?nèi)绾握{(diào)用MySQL存儲(chǔ)過程?的詳細(xì)內(nèi)容,更多請(qǐng)關(guān)注www.92cms.cn其它相關(guān)文章!