SELECT `name`, `param_list`, `comment` FROM `mysql`.`proc` WHERE `db`=DATABASE() AND `type` = 'PROCEDURE';

      Sql language logo
      procedure list

      SQL public snippets

      The following code will return all the columns in the "proc" table that have the value "USER_INPUT" as the column name and have a value of 1 as the column type.

      Shortcut: s_proc_list


        Add Comment

        Log in to add a comment

        Codiga - All rights reserved 2022.