存储过程

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