通過(guò)以下查詢,我們只能看到特定 MySQL 數(shù)據(jù)庫(kù)中存儲(chǔ)函數(shù)的列表 –
mysql> SELECT ROUTINE_TYPE, ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA = 'query' AND ROUTINE_TYPE = 'FUNCTION'// +--------------+--------------------+ | ROUTINE_TYPE | ROUTINE_NAME | +--------------+--------------------+ | FUNCTION | factorial | | FUNCTION | Hello | +--------------+--------------------+ 2 rows in set (0.07 sec)
登錄后復(fù)制
以上就是我們?nèi)绾尾拍苤豢吹教囟?MySQL 數(shù)據(jù)庫(kù)中存儲(chǔ)函數(shù)的列表?的詳細(xì)內(nèi)容,更多請(qǐng)關(guān)注www.92cms.cn其它相關(guān)文章!