select name from mysql.proc where db='數(shù)據(jù)庫名';

select routine_name from information_schema.routines where routine_schema='數(shù)據(jù)庫名';

show procedure status where db='數(shù)據(jù)庫名';
SHOW CREATE PROCEDURE 數(shù)據(jù)庫.存儲過程名;

CREATE DEFINER=`root`@`%` PROCEDURE `alter_view_counts`()
BEGIN
 #聲明結束標識
 DECLARE end_flag int DEFAULT 0; 
 DECLARE albumId bigint; 
 #聲明游標 album_curosr
 DECLARE album_curosr CURSOR FOR SELECT album_id FROM album; 
 #設置終止標志
 DECLARE CONTINUE HANDLER FOR NOT FOUND SET end_flag=1; 
 #打開游標
 OPEN album_curosr; 
 #遍歷游標
 REPEAT
 #獲取當前游標指針記錄，取出值賦給自定義的變量
 FETCH album_curosr INTO albumId;
  #利用取到的值進行數(shù)據(jù)庫的操作
  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;
 # 根據(jù) end_flag 判斷是否結束
 UNTIL end_flag END REPEAT; 
 #關閉游標
 close album_curosr; 
END

CALL alter_view_counts()