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

    SELECT `name`, `param_list`, `comment` FROM `mysql`.`proc` WHERE `db`=DATABASE() AND `type` = 'PROCEDURE';
    Codiga Logo
    Codiga Hub
    • Rulesets
    • Explore
    • Cookbooks
    • Playground
    soc-2 icon

    We are SOC-2 Compliance Certified

    G2 high performer medal

    Codiga – All rights reserved 2022.