mysql get routine parameter list

Solutions on MaxInterview for mysql get routine parameter list by the best coders in the world

showing results for - "mysql get routine parameter list"
Gianluca
12 Jan 2019
1SELECT * 
2FROM information_schema.parameters 
3WHERE SPECIFIC_NAME = 'your_procedure';
4
Anaïs
01 Jul 2020
1SELECT param_list FROM mysql.proc WHERE db='your_database' AND name='your_procedure';
2
similar questions
queries leading to this page
mysql get routine parameter list