mysql数据库一个快速简单造百万数据的方法

提供一张表：

CREATE TABLE `actor` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lastname` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `firstnam` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `sex` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `lastname_firstname_name` (`lastname`,`firstnam`,`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=786412 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

提供一条插入语句，并执行

INSERT INTO `test`.`actor`( `name`, `lastname`, `firstnam`, `sex`) VALUES ( 'ff', 'ff', 'ff', 'ff');

然后执行下面语句，点个十几下就有很多数据了，因为是成倍增长的，1,2,4,8,16,32…百万数据点个二十多下就行了

INSERT INTO `test`.`actor`(`name`, `lastname`, `firstnam`, `sex`) select name,lastname,firstnam,sex from test.actor

又快又简单吧