Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- List all procedures in current database SHOW PROCEDURE STATUS WHERE Db = DATABASE(); -- Show procedure definition SHOW CREATE PROCEDURE GetCustomerOrders; -- Drop and recreate to modify DROP PROCEDURE IF EXISTS GetCustomerOrders; -- Grant execute permission GRANT EXECUTE ON PROCEDURE GetCustomerOrders TO 'app_user'@'localhost';
Result
Open