Home  >  Article  >  Database  >  存储过程,循环插入1000条记录_MySQL

存储过程,循环插入1000条记录_MySQL

WBOY
WBOYOriginal
2016-06-01 13:07:031382browse
PS::今天巴西又被虐了,做梦以为是3:1,醒来是3:0<br>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 $$
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn