Procedure Creation Example

MariaDB [stress]> DELIMITER ;;
MariaDB [stress]> CREATE PROCEDURE ABC()
    -> BEGIN
    -> WHILE 1
    -> DO
    -> SELECT COUNT(*) FROM stresstable;
    -> DO SLEEP(1);
    -> END WHILE;
    -> END;;

MariaDB [stress]> DELIMITER ;
MariaDB [stress]> CALL ABC();

Procedure Listing

$ SHOW PROCEDURE STATUS;

OR

$ SELECT ROUTINE_SCHEMA,ROUTINE_NAME FROM information_schema.routines where routine_type = 'PROCEDURE';

DELETE PROCEDURE

DROP PROCEDURE{DATABASE_NAME}.{PROCEDURE_NAME};