MYSQL存储过程，实在无法，求解释？？

business124

1. 
   
2. <P> BEGIN
   
3.    
   
4.     declare Pmax int; -- 记录表中最大ID
   
5.     declare Pmin int; -- 记录表中最小ID
   
6.     declare PID smallint(6);-- 记录当前统计Pack_ID，用于与总表userservicerelation联系，统计Pack_ID的人气
   
7.    
   
8.     delete from packcollectionrank;-- 清空表
   
9.     insert into packcollectionrank(Pack_ID) select distinct Pack_ID from products ;-- 插入所有Pack_ID到统计表packcollectionrank</P>
   
10. <P>    select MAX(ID) into Pmax from packcollectionrank;
    
11.     select MIN(ID) into Pmin from packcollectionrank;</P>
    
12. <P>    while Pmin<=Pmax do-- 插入所有Pack_ID的人气，没订阅默认为0
    
13.        select Pack_ID into PID from tdxtb_packcollectionrank where ID=Pmin;</P>
    
14. <P>       set @sql1=CONCAT("UPDATE packcollectionrank SET Collection_count=(SELECT COUNT(*) FROM userservicerelation WHERE Pack_ID=",PID," AND Relation_Status=6) WHERE Pack_ID=",PID,";");  
    
15.        PREPARE rankpack1 FROM @sql1;
    
16.        EXECUTE rankpack1;   </P>
    
17. <P>       set Pmin=Pmin+1;
    
18.     end while;
    
19.     -- 插入
    
20. END
    
21. </P>

复制代码

本机执行：时间: 0.250ms

Procedure executed successfully
受影响的行: 1

换机子执行：
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'declare Pmax int;
MYSQL

1. SELECT version();

复制代码

后版本都是5.5.17
这怎么解释，求高人指点！！

  

hm3030

能把整个存储过程贴出来，还有完整的错误信息。。

business124

hm3030 发表于 2012-6-19 11:11
能把整个存储过程贴出来，还有完整的错误信息。。

已解决，对方犯了个小错误，汗~~一上午。