为MySQL填充亿级数据

创建数据库

CREATE DATABASE Student;

创建数据表

DROP TABLE IF EXISTS `Student`;
CREATE TABLE `Student` (
`s_id` int(20) NOT NULL AUTO_INCREMENT,
`s_name` VARCHAR(20) NOT NULL DEFAULT '',
`s_birth` VARCHAR(20) NOT NULL DEFAULT '',
`s_sex` VARCHAR(10) NOT NULL DEFAULT '',
PRIMARY KEY (`s_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

在创建表之后，可以通过如下命令查看创建的表语句：
SHOW CREATE TABLE Student;

插入初始化数据

INSERT INTO Student VALUES (NULL, "赵雷", "1990-01-01", "男");
INSERT INTO Student VALUES (NULL, "钱电", "1990-12-21", "男");
INSERT INTO Student VALUES (NULL, "孙风", "1990-05-20", "男");
INSERT INTO Student VALUES (NULL, "李云", "1990-08-06", "男");
INSERT INTO Student VALUES (NULL, "周梅", "1991-12-01", "女");
INSERT INTO Student VALUES (NULL, "吴兰", "1992-03-01", "女");
INSERT INTO Student VALUES (NULL, "郑竹", "1989-07-01", "女");
INSERT INTO Student VALUES (NULL, "王菊", "1990-01-20", "女");

创建复制语句

INSERT INTO Student SELECT null, s_name, s_birth, s_sex FROM Student;
多次执行后即可，每次使用该语句都会使数据量翻倍。