How to create and call stored procedures in MySQL

To create and call stored procedures in MySQL, the following steps can be used:

1. Create a stored procedure:

DELIMITER //
CREATE PROCEDURE my_procedure()
BEGIN
    -- 在这里编写存储过程的代码
END //
DELIMITER ;

1. Call a stored procedure.

CALL my_procedure();

When creating a stored procedure, begin by changing the statement terminator to // using DELIMITER, then use the CREATE PROCEDURE statement to define the name and parameters (if any) of the stored procedure, and write the code for the stored procedure between BEGIN and END. Finally, reset the statement terminator to ; using DELIMITER.

When calling a stored procedure, use the CALL statement followed by the name of the stored procedure and its parameters (if any) to execute the stored procedure.