表中生成100条记录

CREATE TABLE `str` (
  `username` varchar(100) default NULL,
  `password` varchar(50) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

#
# Dumping data for table str
#

INSERT INTO `str` VALUES ('1','1');
INSERT INTO `str` VALUES ('2','2');
INSERT INTO `str` VALUES ('3','3');
INSERT INTO `str` VALUES ('4','4');
INSERT INTO `str` VALUES ('5','5');
INSERT INTO `str` VALUES ('6','6');
INSERT INTO `str` VALUES ('7','7');
INSERT INTO `str` VALUES ('8','8');
INSERT INTO `str` VALUES ('9','9');
INSERT INTO `str` VALUES ('10','10');
INSERT INTO `str` VALUES ('11','11');
INSERT INTO `str` VALUES ('12','12');
INSERT INTO `str` VALUES ('13','13');
INSERT INTO `str` VALUES ('14','14');
INSERT INTO `str` VALUES ('15','15');
INSERT INTO `str` VALUES ('16','16');
INSERT INTO `str` VALUES ('17','17');
INSERT INTO `str` VALUES ('18','18');
INSERT INTO `str` VALUES ('19','19');
INSERT INTO `str` VALUES ('20','20');
INSERT INTO `str` VALUES ('21','21');
INSERT INTO `str` VALUES ('22','22');
INSERT INTO `str` VALUES ('23','23');
INSERT INTO `str` VALUES ('24','24');
INSERT INTO `str` VALUES ('25','25');
INSERT INTO `str` VALUES ('26','26');
INSERT INTO `str` VALUES ('27','27');
INSERT INTO `str` VALUES ('28','28');
INSERT INTO `str` VALUES ('29','29');
INSERT INTO `str` VALUES ('30','30');
INSERT INTO `str` VALUES ('31','31');
INSERT INTO `str` VALUES ('32','32');
INSERT INTO `str` VALUES ('33','33');
INSERT INTO `str` VALUES ('34','34');
INSERT INTO `str` VALUES ('35','35');
INSERT INTO `str` VALUES ('36','36');
INSERT INTO `str` VALUES ('37','37');
INSERT INTO `str` VALUES ('38','38');
INSERT INTO `str` VALUES ('39','39');
INSERT INTO `str` VALUES ('40','40');
INSERT INTO `str` VALUES ('41','41');
INSERT INTO `str` VALUES ('42','42');
INSERT INTO `str` VALUES ('43','43');
INSERT INTO `str` VALUES ('44','44');
INSERT INTO `str` VALUES ('45','45');
INSERT INTO `str` VALUES ('46','46');
INSERT INTO `str` VALUES ('47','47');
INSERT INTO `str` VALUES ('48','48');
INSERT INTO `str` VALUES ('49','49');
INSERT INTO `str` VALUES ('50','50');
INSERT INTO `str` VALUES ('51','51');
INSERT INTO `str` VALUES ('52','52');
INSERT INTO `str` VALUES ('53','53');
INSERT INTO `str` VALUES ('54','54');
INSERT INTO `str` VALUES ('55','55');
INSERT INTO `str` VALUES ('56','56');
INSERT INTO `str` VALUES ('57','57');
INSERT INTO `str` VALUES ('58','58');
INSERT INTO `str` VALUES ('59','59');
INSERT INTO `str` VALUES ('60','60');
INSERT INTO `str` VALUES ('61','61');
INSERT INTO `str` VALUES ('62','62');
INSERT INTO `str` VALUES ('63','63');
INSERT INTO `str` VALUES ('64','64');
INSERT INTO `str` VALUES ('65','65');
INSERT INTO `str` VALUES ('66','66');
INSERT INTO `str` VALUES ('67','67');
INSERT INTO `str` VALUES ('68','68');
INSERT INTO `str` VALUES ('69','69');
INSERT INTO `str` VALUES ('70','70');
INSERT INTO `str` VALUES ('71','71');
INSERT INTO `str` VALUES ('72','72');
INSERT INTO `str` VALUES ('73','73');
INSERT INTO `str` VALUES ('74','74');
INSERT INTO `str` VALUES ('75','75');
INSERT INTO `str` VALUES ('76','76');
INSERT INTO `str` VALUES ('77','77');
INSERT INTO `str` VALUES ('78','78');
INSERT INTO `str` VALUES ('79','79');
INSERT INTO `str` VALUES ('80','80');
INSERT INTO `str` VALUES ('81','81');
INSERT INTO `str` VALUES ('82','82');
INSERT INTO `str` VALUES ('83','83');
INSERT INTO `str` VALUES ('84','84');
INSERT INTO `str` VALUES ('85','85');
INSERT INTO `str` VALUES ('86','86');
INSERT INTO `str` VALUES ('87','87');
INSERT INTO `str` VALUES ('88','88');
INSERT INTO `str` VALUES ('89','89');
INSERT INTO `str` VALUES ('90','90');
INSERT INTO `str` VALUES ('91','91');
INSERT INTO `str` VALUES ('92','92');
INSERT INTO `str` VALUES ('93','93');
INSERT INTO `str` VALUES ('94','94');
INSERT INTO `str` VALUES ('95','95');
INSERT INTO `str` VALUES ('96','96');
INSERT INTO `str` VALUES ('97','97');
INSERT INTO `str` VALUES ('98','98');
INSERT INTO `str` VALUES ('99','99');
INSERT INTO `str` VALUES ('100','100');