sql语句块

 

 

批量插入数据

begin
declare i int;
set i=1;
while i<1001 do
insert INTO accountbank(`Id`,`Name`,`memberId`,`customerId`,`createTime`) values('1992222'+i,'19911110000'+i,'100'+i,400222000+i,'2018-08-21 00:00:00');
set i=i+1;
end while;

end