mysql数据库存过实例

create procedure bb_test_updatedb()
begin
declare test_i int default 0;
declare test_char varchar(255) default 'test';

InsertDB: while(test_i<50) do
set test_char= convert(test_i,char);
update bb_test_ssid SET VHMName = concat('vhm300',test_char) WHERE ID = test_i;
set test_i=test_i+1;
end while InsertDB;

commit;
end

 

CREATE PROCEDURE bb_test_updateDB()
begin
declare test_k int default 1;
declare var_char varchar(255);
updateDB: while(test_k<20) do
set var_char=(select substring(VHMEmail,1,12) from bb_test_ssid where id=test_k);
select var_char;
update bb_test_ssid set VHMName=var_char where id=test_k;
commit;
set test_k=test_k+1;
select test_k;
end while updateDB;
end;