Mysql循环插入语句

Mysql

1 向数据库中插入1000条记录

写存储过程语句

DROP PROCEDURE IF EXISTS proc_initData;

DELIMITER $

CREATE PROCEDURE proc_initData()

BEGIN

DECLARE i INT DEFAULT 1;

WHILE i<=1000 DO

INSERT INTO feed(user_id,identity,content) VALUES('1','1','哈哈');

SET i = i+1;

END WHILE;

END $

CALL proc_initData();

​​

普通的插入语句

INSERT INTO feed(user_id,identity,content) VALUES

('100','2','内容'),

('101','2','内容'),

('102','2','内容'),

('103','2','内容');

​​