mysql delimiter $$mysql create procedure p3()- modifies sql data- begin- set @i=0;- set @max=100;- while @i@max do- insert into user values (@i);- set @i = @i + 1;- end while;- end $$
mysql> delimiter $$ mysql> create procedure p3() -> modifies sql data -> begin -> set @i=0; -> set @max=100; -> while @i insert into user values (@i); -> set @i = @i + 1; -> end while; -> end $$
【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！