56,912
社区成员




delimiter //
create procedure tt()
begin
declare id integer;
set id=1;
while(id <300)
do
set id=id+1;
set @ee= concat("insert into url(urladdr) values('
')"," ");
prepare v_flag from @ee; <--v_flag放在前面,后面是语句
EXECUTE v_flag;
DEALLOCATE PREPARE v_flag;
end while;
end;
//