The MySQL statement to store a stored procedure 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

The correct statement to store a stored procedure in a MySQL database is "CREATE PROCEDURE". This statement is used to create a new stored procedure in the database. "ALTER PROCEDURE" is used to modify an existing stored procedure, "DROP PROCEDURE" is used to delete a stored procedure from the database, and "CLOSE PROCEDURE" is not a valid MySQL statement.

The MySQL Statement to Store a Stored Procedure in the Database