Mysql stored procedure: copy A column of Table A to Table B _ MySQL

Mysql stored procedure: copy A column of Table A to Table B to go to bitsCN.com

Mysql stored procedure: copy A column of Table A to Table B

This is a stored procedure used to copy the value of the avalue column in Table A to the bvalue column in Table B (assume that both Table A and Table B have the same column named 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

BitsCN.com