Menu
I can't seem to find the syntax for editing an already-created stored procedure in MySQL.
279
To modify an existing stored routine (procedure or function), double-click the node of the routine to modify, or right-click this node and choose the Alter Routine command from the context menu. Either of the commands opens the SQL Editor. Routine properties can be viewed in the Properties window.
Use SQL Server Management Studio Expand Databases, expand the database in which the procedure belongs, and then expand Programmability. Expand Stored Procedures, right-click the procedure to modify, and then select Modify. Modify the text of the stored procedure. To test the syntax, on the Query menu, select Parse.
To write Update stored procedure, follow the same procedure, simply write UPDATE sql statement inside the stored procedure. Notice the above stored procedure code, this is almost similar to the Insert stored procedure.
Create a simple stored procedure. DELIMITER ; To create the MySQL Stored Procedure, open the MySQL workbench Connect to the MySQL Database copy-paste the code in the query editor window click on Execute. You can view the procedure under stored procedures.
You can change certain attributes using the ALTER PROCEDURE syntax
To change the procedure body you will have to drop and recreate the entire procedure, in this case SHOW CREATE PROCEDURE may be useful
119
Mysql do not allow to alter stored procedure but SP can be drop and recreate SP options are available in Mysql like below query
DROP PROCEDURE IF EXISTS foo;
delimiter //
create PROCEDURE foo (args)
begin
bla bla
end//
delimiter ;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
