-- 存储过程作用去除以.cn结尾的url后面的参数
create PROCEDURE g_sp()
begin
declare done int default FALSE;
declare tid int;
declare gurl varchar(255);
-- 声明游标
declare cur cursor for select id,url from t_crawler_config;
-- 指定游标循环结束时的返回值
declare continue handler for not found set done = TRUE;
-- 打开游标
open cur;
-- while 循环
while done != 1 do
fetch cur into tid,gurl;
if done != 1 and LOCATE('.cn/',gurl)!=0 then
set gurl=substring(gurl,1,LOCATE('.cn/',gurl)+3);
update t_crawler_config set url=gurl where id=tid;
end if;
end while;
-- 关闭游标
close cur;
end
--调用存储过程语句
call g_sp();