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