mysqlcursorsql
求高手指点 语法哪里有问题啊
delimiter $$
create
/*[definer = { user | current_user }]*/
procedure x_similarity.covarianceengine()
/*language sql
| [not] deterministic
| { contains sql | no sql | reads sql data | modifies sql data }
| sql security { definer | invoker }
| comment 'string'*/
begin
/* 定义变量一 /
declare done, done2 int default 0;
declare stockno_a varchar(6);
declare coefficient double(16,14);
/ 定义光标 */
declare _cur cursor for
select distinct stock_no from history_day;
declare continue handler for sqlstate '02000' set done = 1;#错误定义，标记循环结束 /* 打开光标 */ open _cur; /* 循环执行 */ repeat fetch _cur into stockno_a; if not done then begin /* 定义变量一 */ declare stockno_b varchar(6); /* 定义光标 */ declare _curinner cursor for select distinct stock_no from history_day; open _curinner; repeat fetch _curinner into stockno_b; if not done2 then select ( avg(a. close * b. close) - avg(a. close) * avg(b. close) ) / sqrt( ( avg(a. close * a. close) - avg(a. close) * avg(a. close) ) * ( avg(b. close * b. close) - avg(b. close) * avg(b. close) ) ) into coefficient from history_day a, history_day b where a.date = b.date and a.date >= '2015-08-05' and a.date 0.5 or coefficient
delimiter ;
错误代码： 1064
you have an error in your sql syntax; check the manual that corresponds to your mysql server version for the right syntax to use near 'end if;
until done end repeat;
close _cur;
end' at line 65