存储过程:复制表A的某列到表B中去
 
这是一个存储过程,用于将tableA表中avalue列的值复制到tableB表中的bvalue列(假设tableA和tableB中都有相同的列,名为id)
 
[sql] 
create procedure copy_field()  
begin  
    declare tid int default 0;  
    declare tvalue int default 0;  
  
    declare b int default 0;  
    declare cur cursor for select a.id, a.avalue from tableA as a join tableB as b where a.id=b.id;  
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET b = 1;  
  
    open cur;   
    set b = 0;  
    repeat  
        FETCH cur INTO tid, tvalue;  
        update tableB set bvalue=tvalue where id=tid;  
        until b>0  
    end repeat;  
    close cur;  
end