CREATE TABLE `t1` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(200) DEFAULT NULL,
`pass` varchar(200) DEFAULT NULL,
`phone` varchar(45) DEFAULT NULL,
`address` varchar(500) DEFAULT NULL,
`beizhu` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1426075 DEFAULT CHARSET=gb2312
----------------
CREATE DEFINER=`root`@`%` PROCEDURE `myin1`()
BEGIN
DECLARE v1 INT DEFAULT 1;
WHILE v1 < 100000 DO
insert into t1() values(null,'敖士伟','ikmbikmb','15827219298','湖北省武汉市江岸区后湖华庭5号楼3单元2-1','这是个BENMARK测试');
SET v1 = v1 + 1;
END WHILE;
END