存储过程

BEGIN
/*定义变量 */
DECLARE p varchar(10);
DECLARE  no_more_products INT DEFAULT 0;  
DECLARE a,w DECIMAL(10,2); 
DECLARE cur_product CURSOR FOR SELECT platform,winloss,amount FROM bet_log_fix;
DECLARE  CONTINUE HANDLER FOR NOT FOUND  SET  no_more_products = 1;
OPEN cur_product;
FETCH  NEXT FROM  cur_product INTO p,a,w;
#SELECT platform;

REPEAT  
		INSERT INTO test(`test`,`winloss`,`amount`) values(p,w,a);
		FETCH  NEXT FROM  cur_product INTO p,w,a;
		UNTIL  no_more_products = 1 
END REPEAT;


CLOSE cur_product;


END

详见  http://blog.csdn.net/rdarda/article/details/7881648

          http://blog.sina.com.cn/s/blog_52d20fbf0100ofd5.html

          http://www.cnblogs.com/Gavinzhao/archive/2010/07/14/1777644.html