CODE EXAMPLE FOR SQL

Mysql get routine parameter list

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