测mysql

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