Mysql get routine parameter list

SELECT * 
FROM information_schema.parameters 
WHERE SPECIFIC_NAME = 'your_procedure';

SELECT param_list FROM mysql.proc WHERE db='your_database' AND name='your_procedure';

Similar codes

14 votes304 views4 answers
Sql compiler
SQL
1 vote274 views1 answer
Sql into vs insert into
SQL
1 vote275 views1 answer
Alphabetical order mysql
SQL
0 vote230 views1 answer
Plsql trigger insert update
SQL
0 vote260 views2 answers
What is 1=2 in sql
SQL
0 vote289 views3 answers
Join
SQL
12 votes257 views1 answer
Env var for setting password for root user mysql docker hub
SQL
1 vote250 views1 answer
Delete triger pl pg sql
SQL
1 vote275 views1 answer
Deleting database in sql
SQL
0 vote271 views3 answers
Average salary in sql
SQL