BEGIN
-- 需要定义接收游标数据的变量
DECLARE idp VARCHAR(255);
DECLARE brandIdp VARCHAR(255);
DECLARE namep VARCHAR(1000);
DECLARE urlp VARCHAR(1000);
DECLARE downloadUrlp VARCHAR(1000);
DECLARE sitep VARCHAR(255);
DECLARE appIdp VARCHAR(255);
DECLARE pathp VARCHAR(255);
DECLARE siteMemop VARCHAR(255);
DECLARE sizep BIGINT(255);
DECLARE errorp VARCHAR(255);
DECLARE totalsp int(10);
DECLARE checkp int(11);
DECLARE textp int(11);
DECLARE statusp TINYINT(255);
DECLARE createUserp VARCHAR(255);
DECLARE createDatep TIMESTAMP;
DECLARE updateDatep TIMESTAMP;
DECLARE updateUserp VARCHAR(255);
-- 遍历数据结束标志
DECLARE done INT DEFAULT FALSE;
DECLARE cur CURSOR FOR SELECT
brand_shuomingshu.pdfId AS id,
home_brand.id AS brandId,
brand_shuomingshu.pdfN