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

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

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

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

CALL alter_view_counts()