摘要： DELIMITER $$ DROP PROCEDURE IF EXISTS updatePic $$ CREATE PROCEDURE updatePic()BEGIN DECLARE cover_pic VARCHAR(500); DECLARE collect_id BIGINT(20); DECLARE cur1 CURSOR FOR SELECT collect_id FROM collect WHERE IFNULL(cover_pic,'')=''; DECLARE CONTINUE HANDLER FOR SQLSTATE '02000&# 阅读全文