mysql---为测试数据库填充大量数据

一、创建一个数据库bigdata

二、创建表

CREATE TABLE `single_table` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(50) DEFAULT NULL,
`post` TEXT,
PRIMARY KEY (`id`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8;

三、填充数据存储过程

DELIMITER $$

USE `bigdata`$$

DROP PROCEDURE IF EXISTS `insert_single_table`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `insert_single_table`(IN item INTEGER)
BEGIN
DECLARE counter INT;
SET counter = item;
WHILE counter >= 1 DO
INSERT INTO single_table VALUES(counter,CONCAT('mysqlsystems.com',counter),REPEAT('bla',counter%10));
SET counter = counter - 1;
END WHILE;
END$$

DELIMITER ;

四、插入数据

CALL `insert_single_table`(5000)