Introduction to query commands for MySQL stored procedures

select name from mysql.proc where db='database name';

select routine_name from information_schema.routines where routine_schema='database name';

show procedure status where db='database name';
SHOW CREATE PROCEDURE database.Stored procedure name;

CREATE DEFINER=`root`@`%` PROCEDURE `alter_view_counts`()
BEGIN
 #Declare end flag DECLARE end_flag int DEFAULT 0; 
 DECLARE albumId bigint; 
 #Declare cursor album_curosr
 DECLARE album_curosr CURSOR FOR SELECT album_id FROM album; 
 #Set the termination flag DECLARE CONTINUE HANDLER FOR NOT FOUND SET end_flag=1; 
 #Open the cursor OPEN album_curosr; 
 #Traverse the cursor REPEAT
 #Get the current cursor pointer record and assign the value to the custom variable FETCH album_curosr INTO albumId;
  #Use the obtained value to perform database operations UPDATE album SET album.views_count= (SELECT SUM(light_chat.views_count) FROM `light_chat` WHERE light_chat.album_id = albumId) WHERE album.album_id = albumId;
 # Determine whether to end UNTIL end_flag END REPEAT according to end_flag; 
 #Close the cursorclose album_curosr; 
END

CALL alter_view_counts()