generatedata_20080910_162350.sql

TestDataBuilder是一个采用Java编写的

insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10093:童美栋', '童美栋', '男', 28, null, '1986-12-26', 'CLA-1093', '重庆市,酉阳土家族苗族自治县', 822, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10070:那巴', '那巴', '男', 20, 13552413336, '1987-02-20', 'CLA-1070', '台湾省,台湾省', 893, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10080:宋昵', '宋昵', '男', 24, 15111213504, '1987-07-23', 'CLA-1080', '吉林省,永吉县', 869, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10031:楚涯蔚', '楚涯蔚', '女', 27, null, '1986-01-30', 'CLA-1031', '北京市,房山区', 837, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10077:向生振', '向生振', '女', 25, null, '1985-10-01', 'CLA-1077', '海南省,临高县', 858, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10049:甘曼间', '甘曼间', '女', 26, 14644488287, '1987-05-24', 'CLA-1049', '西藏自治区,南木林县', 831, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10030:仕柏婧', '仕柏婧', '男', 24, null, '1986-05-27', 'CLA-1030', '辽宁省,太平区', 821, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10080:衡虔孩', '衡虔孩', '女', 21, 15401874092, '1985-07-08', 'CLA-1080', '新疆维吾尔自治区,南山矿区', 841, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10079:修仕', '修仕', '女', 22, 14802959371, '1986-06-07', 'CLA-1079', '内蒙古自治区,根河市', 851, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10002:季莺流', '季莺流', '男', 29, null, '1987-04-07', 'CLA-1002', '重庆市,铜梁县', 825, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10074:旷稳蕙', '旷稳蕙', '女', 27, 13677598598, '1984-11-16', 'CLA-1074', '浙江省,桐庐县', 850, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10014:柴石', '柴石', '女', 27, 14689038506, '1986-12-19', 'CLA-1014', '浙江省,江北区', 892, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10033:海冬述', '海冬述', '男', 21, null, '1985-09-22', 'CLA-1033', '四川省,白玉县', 854, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10014:韦汪', '韦汪', '女', 28, null, '1987-04-19', 'CLA-1014', '内蒙古自治区,兴安盟', 814, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10017:单茗', '单茗', '男', 29, 14408816140, '1987-05-14', 'CLA-1017', '内蒙古自治区,昆都伦区', 893, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10023:尹[', '尹[', '男', 25, 15457041355, '1986-07-03', 'CLA-1023', '山西省,静乐县', 800, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10040:朗锟 ', '朗锟 ', '女', 23, null, '1986-04-12', 'CLA-1040', '河北省,广宗县', 804, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10041:师教古', '师教古', '男', 27, 15482172828, '1985-10-26', 'CLA-1041', '上海市,杨浦区', 822, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10054:瞿聪榀', '瞿聪榀', '男', 29, null, '1986-02-04', 'CLA-1054', '重庆市,万州区', 889, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10033:轩絮', '轩絮', '男', 23, null, '1984-11-25', 'CLA-1033', '云南省,文山县', 809, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10010:薄绒辅', '薄绒辅', '男', 21, 13885901990, '1984-10-17', 'CLA-1010', '黑龙江省,红岗区', 800, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10000:刘磊鲤', '刘磊鲤', '女', 29, 15609376754, '1986-11-10', 'CLA-1000', '湖北省,黄石市', 871, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10022:连席燊', '连席燊', '女', 25, null, '1985-10-22', 'CLA-1022', '陕西省,商南县', 808, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10060:关旷赫', '关旷赫', '男', 21, null, '1987-07-06', 'CLA-1060', '江西省,广丰县', 822, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10003:晁原', '晁原', '男', 26, null, '1986-02-01', 'CLA-1003', '上海市,青浦区', 827, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10077:凤皇迪', '凤皇迪', '女', 27, null, '1985-01-17', 'CLA-1077', '广西壮族自治区,融水苗族自治县', 892, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10058:岳霖中', '岳霖中', '男', 21, 15862898230, '1986-01-11', 'CLA-1058', '北京市,顺义区', 860, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10022:宣左', '宣左', '女', 25, 15105106542, '1985-07-10', 'CLA-1022', '台湾省,台湾省', 854, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10088:仝玩伯', '仝玩伯', '男', 26, 15437239248, '1985-04-28', 'CLA-1088', '云南省,永胜县', 852, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10039:陆姗岫', '陆姗岫', '女', 29, null, '1985-07-15', 'CLA-1039', '黑龙江省,穆棱市', 826, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10092:毕活', '毕活', '女', 24, null, '1985-07-04', 'CLA-1092', '山东省,桓台县', 873, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10058:钱田', '钱田', '女', 21, null, '1985-03-01', 'CLA-1058', '辽宁省,龙城区', 888, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10081:成足岽', '成足岽', '男', 28, null, '1984-10-29', 'CLA-1081', '江西省,万载县', 827, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10013:崔燚社', '崔燚社', '女', 27, 13887151001, '1984-10-12', 'CLA-1013', '河北省,灵寿县', 817, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10070:穆眉尚', '穆眉尚', '女', 23, null, '1986-02-26', 'CLA-1070', '江西省,章贡区', 856, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10023:裘宓', '裘宓', '女', 29, 14051846606, '1986-10-14', 'CLA-1023', '山西省,长治市', 808, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10020:彭榕璨', '彭榕璨', '男', 25, null, '1987-05-22', 'CLA-1020', '上海市,奉贤区', 869, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10088:翁润改', '翁润改', '女', 20, 14909389313, '1984-11-09', 'CLA-1088', '贵州省,三穗县', 815, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10052:戚琛', '戚琛', '女', 26, 13626534945, '1987-08-01', 'CLA-1052', '吉林省,东辽县', 826, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10084:钦四百', '钦四百', '女', 28, null, '1985-08-18', 'CLA-1084', '天津市,宁河县', 826, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10030:慕达稀', '慕达稀', '女', 24, 14421954919, '1986-11-25', 'CLA-1030', '江苏省,镇江市', 852, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10038:阮朋绪', '阮朋绪', '男', 23, 15781352880, '1986-03-10', 'CLA-1038', '西藏自治区,浪卡子县', 863, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10013:隋良唯', '隋良唯', '女', 29, 13727828884, '1986-05-27', 'CLA-1013', '湖南省,安仁县', 843, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10076:辛继', '辛继', '男', 29, null, '1987-08-06', 'CLA-1076', '山西省,长子县', 802, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10015:赵圆侣', '赵圆侣', '女', 29, 15441148164, '1985-05-26', 'CLA-1015', '海南省,琼山区', 865, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10022:柏冯策', '柏冯策', '男', 28, null, '1985-09-25', 'CLA-1022', '北京市,通州区', 899, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10070:强和', '强和', '男', 29, null, '1985-10-28', 'CLA-1070', '安徽省,淮北市', 885, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10070:符峰钢', '符峰钢', '女', 21, 14638890110, '1985-07-30', 'CLA-1070', '西藏自治区,洛扎县', 868, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10066:简珩侦', '简珩侦', '男', 27, 14247632197, '1985-07-19', 'CLA-1066', '贵州省,黔东南苗族侗族自治州', 817, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10050:龙太', '龙太', '女', 25, null, '1987-02-01', 'CLA-1050', '上海市,上海市', 814, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10091:乐核峙', '乐核峙', '男', 26, 15919818850, '1985-06-23', 'CLA-1091', '广东省,增城市', 828, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10094:蒋豪祖', '蒋豪祖', '女', 22, null, '1985-01-21', 'CLA-1094', '四川省,叙永县', 860, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10049:祖薇俦', '祖薇俦', '男', 28, null, '1987-04-18', 'CLA-1049', '湖北省,荆州市', 899, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10047:曲窕湘', '曲窕湘', '女', 23, 13266654659, '1987-02-15', 'CLA-1047', '上海市,青浦区', 827, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10065:梁侠巨', '梁侠巨', '男', 24, 13141337369, '1984-09-18', 'CLA-1065', '河北省,山海关区', 859, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10019:相沐粲', '相沐粲', '男', 25, 15311248762, '1985-10-29', 'CLA-1019', '青海省,杂多县', 883, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10063:喻豹庆', '喻豹庆', '女', 23, null, '1986-01-21', 'CLA-1063', '青海省,平安县', 831, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10023:旋浩路', '旋浩路', '女', 27, 15315060717, '1986-02-16', 'CLA-1023', '黑龙江省,南岔区', 826, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10066:霍滈继', '霍滈继', '男', 23, 13762093387, '1985-01-22', 'CLA-1066', '上海市,市辖区', 830, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10057:卓志令', '卓志令', '女', 22, null, '1986-03-10', 'CLA-1057', '江西省,临川市', 815, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10056:亓奇炟', '亓奇炟', '女', 27, null, '1985-12-04', 'CLA-1056', '安徽省,泾县', 871, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10074:蹇颢百', '蹇颢百', '女', 27, 14311505403, '1985-12-22', 'CLA-1074', '陕西省,柞水县', 804, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10060:随演', '随演', '女', 21, 15118839494, '1985-08-16', 'CLA-1060', '山东省,潍坊市', 849, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10005:曾诚微', '曾诚微', '女', 26, null, '1986-06-26', 'CLA-1005', '江西省,上饶县', 813, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10060:屈盟礼', '屈盟礼', '男', 29, null, '1985-07-01', 'CLA-1060', '安徽省,颖东区', 803, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10056:胡晓璇', '胡晓璇', '女', 27, null, '1985-09-02', 'CLA-1056', '甘肃省,碌曲县', 813, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10017:沃砾', '沃砾', '男', 27, 15478062015, '1986-08-11', 'CLA-1017', '陕西省,黄陵县', 830, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10021:户咸原', '户咸原', '男', 21, null, '1984-08-22', 'CLA-1021', '吉林省,丰满区', 804, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10055:柯司庭', '柯司庭', '男', 25, null, '1985-01-14', 'CLA-1055', '山西省,大宁县', 836, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10041:鲁绪娥', '鲁绪娥', '女', 22, 13900197272, '1986-11-22', 'CLA-1041', '宁夏回族自治区,西吉县', 862, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10005:宿四茗', '宿四茗', '女', 28, null, '1985-11-26', 'CLA-1005', '山东省,巨野县', 886, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10038:阚鳌腾', '阚鳌腾', '男', 27, null, '1984-11-10', 'CLA-1038', '贵州省,台江县', 876, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10004:丁千', '丁千', '女', 26, null, '1984-09-01', 'CLA-1004', '山西省,临汾市', 893, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10023:花娅则', '花娅则', '女', 24, 15519362256, '1985-06-13', 'CLA-1023', '新疆维吾尔自治区,和静县', 877, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10017:江鳌肖', '江鳌肖', '男', 21, 13302084705, '1985-02-06', 'CLA-1017', '湖南省,衡阳市', 856, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10081:刑繁', '刑繁', '女', 26, 13337127850, '1987-03-05', 'CLA-1081', '重庆市,垫江县', 821, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10061:杨正燥', '杨正燥', '女', 29, null, '1985-05-06', 'CLA-1061', '宁夏回族自治区,中宁县', 816, getdate())