首页 > 数据库开发 > mysql存储过程:复制表A的某列到表B中去

mysql存储过程:复制表A的某列到表B中去

这是一个存储过程,用于将tableA表中avalue列的值复制到tableB表中的bvalue列(假设tableA和tableB中都有相同的列,名为id)

源码:

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


本文固定链接: http://www.devba.com/index.php/archives/614.html | 开发吧

报歉!评论已关闭.