mysql存储过程 update 出错

jing494485758

错误提示是：Procedure execution failed
1054 - Unknown column 'group_name' in 'field list'

1. begin
   
2.           declare tmpgroup_name varchar(32);
   
3.                 DECLARE flag INT DEFAULT 0;
   
4.                 declare cur1 CURSOR FOR SELECT group_name FROM tmp_name where root_id='1109091147589960828996e6a4cfc186';
   
5.                 DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET flag = 1;
   
6.                 open cur1;
   
7.                 FETCH cur1 INTO tmpgroup_name;
   
8.                 while ( flag <> 1 ) do
   
9.                         #update account_group set group_name = concat('北京',flag) where group_id='1103281001000001a7fb7f9ac8cadf7f';
   
10.                         update account_group set group_name = concat('北京_',tmpgroup_name) where root_id='1109091147589960828996e6a4cfc186';
    
11.                         FETCH cur1 INTO tmpgroup_name;
    
12.                 end while;
    
13. end

复制代码

horizonhyg

看不懂就用google翻译吧