mysql存储过程 long mysql存储过程输出日志

delimiter || 
  
 
  

    CREATE procedure next 
  
 
  

    (in in_id            INT, 
  
 
  

     in in_table_code      VARCHAR(255), 
  
 
  

     in in_site_code     VARCHAR(20), 
  
 
  

     in in_goods_code    VARCHAR(40), 
  
 
  

     out out_min_id     INT, 
  
 
  

     out out_price DOUBLE, 
  
 
  

     out out_comment_total INT 
   
  

    ) 
  
 
  

    begin 
  
 
  

    select  min(id) from price_history 
  
 
  

    where id>in_id and table_code=in_table_code and site_code=in_site_code 
  
 
  

        and goods_code=in_goods_code into out_min_id; 
  
 
   
  

    select comment_total from price_history where id=out_min_id into out_comment_total; 
   
  

    end|| 
  
 
  

    delimiter ; 
  
 
   
   
   
  

    call next(1,'01','360BUY','595936',@out_min_id,@p,@c); 
  
 
  

    select @out_min_id,@p,@c;