MySql存储过程之累加篇（000001累加至999999）

存储过程
CREATE  PROCEDURE `generate_orderNo`()
BEGIN
  declare newOrderNo varchar(6);
  declare oldOrderNo varchar(6);
  SELECT IFNULL(order_no, '000001') into oldOrderNo  FROM t_orders ORDER BY order_no DESC LIMIT 1 ;
  WHILE oldOrderNo+0 <999999 do
  THEN
    SELECT LPAD((oldOrderNo + 1), 6, '0') INTO newOrderNo ;
    INSERT INTO t_orders (order_no) VALUES (newOrderNo) ;
  END WHILE ;
END;

执行：
CALL generate_orderNo();