创建存储过程
delimiter $$
create procedure insert_lotcontrol()begin
declare i bigint(20) default 0;
/*把autocommit设置成0*/
set autocommit= 0;
repeat
set i=i+1;
INSERT INTO `lotcontrol` (`id`, `is_sell`, `is_visible`, `lotno`, `end_bet_date`, `storeid`)
VALUES (NULL, 'false', 'false', 'J00009', '', CONCAT('ds',i));
until i=5 end repeat;
commit;
end $$
删除存储过程
drop insert_lotcontrol;
调用存储过程
call insert_lotcontrol;