The MySQL statement to change a stored procedure already stored in the database is:
A)CREATE PROCEDURE.
B)ALTER PROCEDURE.
C)DROP PROCEDURE.
D)CLOSE PROCEDURE.
E)None of the above.

Question

Quizplus · Accepted Answer

To change a stored procedure already stored in the database, we use the ALTER PROCEDURE statement. This allows us to modify the code of the stored procedure without having to drop and recreate it. The other options listed are not applicable in this scenario.

The MySQL Statement to Change a Stored Procedure Already Stored