mysql用函数求1-100的质数和

create function zhishuhe()
returns INT
BEGIN
	declare sum int default 0;
	declare number int default 2;
	declare temp int;
	while number<101 DO
		set temp=2;
		label:while temp<number DO
			if number%temp=0 THEN
				leave label;
			end if;
			set temp=temp+1;
		end while;
		if number=temp THEN
			set sum = sum+number;
		end if;
		set number = number+1;
	end while;
	return sum;
end;

运行函数 select zhishuhe();
删除函数 drop function if EXISTS zhishuhe;