{"id":251,"date":"2019-08-27T12:24:03","date_gmt":"2019-08-27T18:24:03","guid":{"rendered":"http:\/\/www.polysyncronism.com\/wordpress\/?p=251"},"modified":"2019-08-27T12:31:22","modified_gmt":"2019-08-27T18:31:22","slug":"mariadb-list-functions-and-stored-procedures-with-parameters","status":"publish","type":"post","link":"http:\/\/www.polysyncronism.com\/wordpress\/2019\/08\/27\/mariadb-list-functions-and-stored-procedures-with-parameters\/","title":{"rendered":"MariaDB list Functions and Stored Procedures with parameters"},"content":{"rendered":"<pre class=\"lang:mysql decode:true    \"># list all routines with type and parameter list.\n# parameters are comma separated and listed by ordinal_position\nselect r.routine_schema as database_name,\n       r.specific_name as routine_name,\n       r.routine_type AS type,\n       GROUP_CONCAT(p.parameter_name ORDER BY p.ordinal_position) AS Parameters\nfrom information_schema.routines r\nleft join information_schema.parameters p\n          on p.specific_schema = r.routine_schema\n          and p.specific_name = r.specific_name\nwhere r.routine_schema not in ('sys', 'information_schema',\n                               'mysql', 'performance_schema')\n     and r.routine_schema = 'warehouse' # Your database name here\nGROUP BY r.specific_name     \norder by r.routine_schema,\n         r.specific_name,\n         p.ordinal_position;<\/pre>\n","protected":false},"excerpt":{"rendered":"<p># list all routines with type and parameter list. # parameters are comma separated and listed by ordinal_position select r.routine_schema as database_name, r.specific_name as routine_name, r.routine_type AS type, GROUP_CONCAT(p.parameter_name ORDER BY p.ordinal_position) AS Parameters from information_schema.routines r left join information_schema.parameters p on p.specific_schema = r.routine_schema and p.specific_name = r.specific_name where r.routine_schema not in (&#8216;sys&#8217;, &#8216;information_schema&#8217;, &hellip; <a href=\"http:\/\/www.polysyncronism.com\/wordpress\/2019\/08\/27\/mariadb-list-functions-and-stored-procedures-with-parameters\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;MariaDB list Functions and Stored Procedures with parameters&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27],"tags":[],"class_list":["post-251","post","type-post","status-publish","format-standard","hentry","category-mariadb"],"_links":{"self":[{"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/posts\/251","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/comments?post=251"}],"version-history":[{"count":12,"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/posts\/251\/revisions"}],"predecessor-version":[{"id":264,"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/posts\/251\/revisions\/264"}],"wp:attachment":[{"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/media?parent=251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/categories?post=251"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/tags?post=251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}