Mysql循环插入语句
Mysql1 向数据库中插入1000条记录写存储过程语句DROP PROCEDURE IF EXISTS proc_initData;DELIMITER $CREATE PROCEDURE proc_initData()BEGINDECLARE i INT DEFAULT 1;WHILE i<=1000 DOINSERT INTO fee...
·
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','内容');
更多推荐
已为社区贡献1条内容
所有评论(0)