generatedata_20080910_162350.sql

来自「TestDataBuilder是一个采用Java编写的」· SQL 代码 · 共 312 行 · 第 1/4 页

insert into class (id, master, classRome, code) values ('CLA-1056', null, 'sVUDQvSwnrBvNepleAvhJI', 'WH10056')
insert into class (id, master, classRome, code) values ('CLA-1057', null, 'fqbDXzAoLpMVHRActxZDaZlOhiYdSAJ', 'WH10057')
insert into class (id, master, classRome, code) values ('CLA-1058', null, 'dEixTXMQVsDVBJNqpsGRAbD', 'WH10058')
insert into class (id, master, classRome, code) values ('CLA-1059', null, 'jtHuYvasYbTWblooUMvplnMSMIl', 'WH10059')
insert into class (id, master, classRome, code) values ('CLA-1060', null, 'PeknZcPuXNLXXDrkZJjHfK', 'WH10060')
insert into class (id, master, classRome, code) values ('CLA-1061', null, 'ONipHfDimsHgDOacyKfyFAaJ', 'WH10061')
insert into class (id, master, classRome, code) values ('CLA-1062', null, 'CftmiuUbWacZDIrHElorfJxCY', 'WH10062')
insert into class (id, master, classRome, code) values ('CLA-1063', null, 'pbhWNSRdTHpwswMvSPwQ', 'WH10063')
insert into class (id, master, classRome, code) values ('CLA-1064', null, 'LaxSukawoxIIKrxyksGXKAUiPiTMrvjAeTU', 'WH10064')
insert into class (id, master, classRome, code) values ('CLA-1065', null, 'CbxspBhlfgGbZgQFjPrHRW', 'WH10065')
insert into class (id, master, classRome, code) values ('CLA-1066', null, 'WxcCezONzqvcUKfYiPoMFRHkRbmY', 'WH10066')
insert into class (id, master, classRome, code) values ('CLA-1067', null, 'GmutJAxdwfWGlekLAxxNaEPBIPz', 'WH10067')
insert into class (id, master, classRome, code) values ('CLA-1068', null, 'eNGrXMnalOFVctqNBXymvwIMbvuTi', 'WH10068')
insert into class (id, master, classRome, code) values ('CLA-1069', null, 'xZMFKBKNwcEsCIFKMzzND', 'WH10069')
insert into class (id, master, classRome, code) values ('CLA-1070', null, 'bPxxWZEtPtdhZCoEeroRhZwTBFUBZHFvlwrLwd', 'WH10070')
insert into class (id, master, classRome, code) values ('CLA-1071', null, 'tYiBXyRUCCAiDorarOJZEXusEiOjCvWPBFG', 'WH10071')
insert into class (id, master, classRome, code) values ('CLA-1072', null, 'TzBETzgUWOkwkYbpmIZARozCJoOxTzlZYhCySxO', 'WH10072')
insert into class (id, master, classRome, code) values ('CLA-1073', null, 'HnlreVhPsTeJjqboqCummRK', 'WH10073')
insert into class (id, master, classRome, code) values ('CLA-1074', null, 'raBWWqXLDDVSMwVAoEelhVUuJ', 'WH10074')
insert into class (id, master, classRome, code) values ('CLA-1075', null, 'nIebQvIfAxizudXtogawNnijnuOg', 'WH10075')
insert into class (id, master, classRome, code) values ('CLA-1076', null, 'szlYcjLkFwAAoTKDjpOwqukzMK', 'WH10076')
insert into class (id, master, classRome, code) values ('CLA-1077', null, 'AAzbgFakKaGCXTbJZAHWgdTgCIPiWv', 'WH10077')
insert into class (id, master, classRome, code) values ('CLA-1078', null, 'pZyKnjXRFUYSfjRvXIsQaDQawyykxTBuNV', 'WH10078')
insert into class (id, master, classRome, code) values ('CLA-1079', null, 'qOupbjNfHspsbmZStqrvhQIdCoOFRAdEnJE', 'WH10079')
insert into class (id, master, classRome, code) values ('CLA-1080', null, 'zRxUIBmtetziftPywjgYfmmRvYtfJWSjVevvoX', 'WH10080')
insert into class (id, master, classRome, code) values ('CLA-1081', null, 'DXWyTVCteTQmUUzDosfSitJBsfVM', 'WH10081')
insert into class (id, master, classRome, code) values ('CLA-1082', null, 'UaSzuUNmFiNzsDVXbMCW', 'WH10082')
insert into class (id, master, classRome, code) values ('CLA-1083', null, 'jMAciRtFLlythtPdZqFBtqoadZcKdKDlDdsKQ', 'WH10083')
insert into class (id, master, classRome, code) values ('CLA-1084', null, 'IqVCKkvvrwmJBwutzOXWxUsygafdiqxUVMXtEp', 'WH10084')
insert into class (id, master, classRome, code) values ('CLA-1085', null, 'ObQeXZDZzoGAlsvXsHTazapHJTWsWdAN', 'WH10085')
insert into class (id, master, classRome, code) values ('CLA-1086', null, 'eHQkYyPnCqGacfBuGcbnze', 'WH10086')
insert into class (id, master, classRome, code) values ('CLA-1087', null, 'iltTTWsNauywTalgFTraFsZGHdKkiJ', 'WH10087')
insert into class (id, master, classRome, code) values ('CLA-1088', null, 'sDrvzhdHYpFrFSdotcijAAEjjYLhTVDlgfFK', 'WH10088')
insert into class (id, master, classRome, code) values ('CLA-1089', null, 'VVmBvfigfakASrkbgEeBwIVhltGgND', 'WH10089')
insert into class (id, master, classRome, code) values ('CLA-1090', null, 'wHwVMdJWFYwbbQroyqQVUp', 'WH10090')
insert into class (id, master, classRome, code) values ('CLA-1091', null, 'hsBIwHpKfqCgjuxkZgqlupOuTZmQFV', 'WH10091')
insert into class (id, master, classRome, code) values ('CLA-1092', null, 'lelaNDnUIMKwzocCRzyuNLg', 'WH10092')
insert into class (id, master, classRome, code) values ('CLA-1093', null, 'wVVsGYgRvVuSwPLmKQOnWqNEGMs', 'WH10093')
insert into class (id, master, classRome, code) values ('CLA-1094', null, 'UbfOYwwvGzKxMahsGsjgsZnSS', 'WH10094')
insert into class (id, master, classRome, code) values ('CLA-1095', null, 'sckmwjUaLldwmcSpohNPA', 'WH10095')
insert into class (id, master, classRome, code) values ('CLA-1096', null, 'RUXKfdLwiOHpHjgGDyNniZgubQMizIF', 'WH10096')
insert into class (id, master, classRome, code) values ('CLA-1097', null, 'TGbtDXKQsuskRUSdhqcMJDsEnhey', 'WH10097')
insert into class (id, master, classRome, code) values ('CLA-1098', null, 'oWkrSOMpkbroryZnXgGh', 'WH10098')
insert into class (id, master, classRome, code) values ('CLA-1099', null, 'gAKuvzLNAtHifRYeLNujcNJSzbA', 'WH10099')
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10042:田逵葵', '田逵葵', '男', 29, 13788295581, '1985-10-03', 'CLA-1042', '山西省,灵丘县', 854, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10076:韶烁淮', '韶烁淮', '女', 25, null, '1985-04-01', 'CLA-1076', '广东省,江城区', 893, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10010:向慎逸', '向慎逸', '女', 22, 15968376227, '1985-03-10', 'CLA-1010', '甘肃省,漳县', 870, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10042:阿龙作', '阿龙作', '女', 20, null, '1987-07-24', 'CLA-1042', '广西壮族自治区,乐业县', 835, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10060:率辉上', '率辉上', '男', 26, 14363496915, '1985-09-27', 'CLA-1060', '内蒙古自治区,武川县', 863, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10082:顾上旦', '顾上旦', '女', 22, null, '1986-01-29', 'CLA-1082', '西藏自治区,亚东县', 876, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10056:旦添首', '旦添首', '男', 23, null, '1986-12-29', 'CLA-1056', '浙江省,衢州市', 817, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10037:郑早', '郑早', '女', 20, null, '1984-11-20', 'CLA-1037', '湖北省,孝南区', 824, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10066:扬璞帆', '扬璞帆', '男', 23, 14831556472, '1986-10-01', 'CLA-1066', '重庆市,奉节县', 823, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10008:毕晋', '毕晋', '男', 26, null, '1986-08-01', 'CLA-1008', '安徽省,铜陵市', 837, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10005:项开演', '项开演', '男', 27, null, '1987-01-04', 'CLA-1005', '海南省,万宁市', 805, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10030:孟务霖', '孟务霖', '女', 20, null, '1984-11-10', 'CLA-1030', '内蒙古自治区,市辖区', 844, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10053:旦斓', '旦斓', '女', 27, null, '1987-06-01', 'CLA-1053', '浙江省,舟山市', 803, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10000:朱竑武', '朱竑武', '男', 24, null, '1987-07-22', 'CLA-1000', '云南省,兰坪白族普米族自治县', 861, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10094:虞盛迓', '虞盛迓', '男', 21, null, '1986-12-28', 'CLA-1094', '辽宁省,新城子区', 870, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10054:荀伏', '荀伏', '女', 20, 13511701970, '1986-05-25', 'CLA-1054', '台湾省,台湾省', 842, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10020:简秉左', '简秉左', '女', 21, null, '1985-08-16', 'CLA-1020', '内蒙古自治区,科尔沁右翼前旗', 813, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10076:鄢苏', '鄢苏', '女', 28, 15370542226, '1984-10-26', 'CLA-1076', '辽宁省,营口市', 899, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10030:习芝翠', '习芝翠', '女', 25, 15080464630, '1987-06-16', 'CLA-1030', '广东省,丰顺县', 843, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10048:利助昇', '利助昇', '男', 28, 15830074723, '1986-03-18', 'CLA-1048', '山东省,即墨市', 859, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10084:仕炳', '仕炳', '女', 22, null, '1986-07-25', 'CLA-1084', '西藏自治区,噶尔县', 880, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10018:迟王程', '迟王程', '女', 28, null, '1985-06-24', 'CLA-1018', '浙江省,舟山市', 843, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10032:郑恭虎', '郑恭虎', '男', 23, 14265922231, '1987-06-29', 'CLA-1032', '河北省,宁晋县', 892, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10090:柳鸽远', '柳鸽远', '男', 28, 15461254434, '1985-01-01', 'CLA-1090', '甘肃省,静宁县', 878, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10068:安敏', '安敏', '女', 29, 13255983248, '1985-04-21', 'CLA-1068', '浙江省,兰溪市', 852, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10012:刁灿', '刁灿', '女', 27, null, '1985-08-09', 'CLA-1012', '湖北省,南漳县', 831, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10028:房居绳', '房居绳', '女', 24, null, '1984-11-27', 'CLA-1028', '浙江省,安吉县', 808, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10059:雷邵格', '雷邵格', '女', 24, 15821411027, '1985-07-12', 'CLA-1059', '安徽省,庐江县', 869, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10046:萨渊璋', '萨渊璋', '女', 20, 15251493618, '1986-12-18', 'CLA-1046', '北京市,西城区', 826, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10044:乾宸芝', '乾宸芝', '女', 24, 15925550034, '1985-02-18', 'CLA-1044', '广西壮族自治区,永福县', 894, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10009:余前瞬', '余前瞬', '男', 23, 15817393257, '1987-02-19', 'CLA-1009', '甘肃省,临夏市', 810, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10090:江交学', '江交学', '女', 27, 14393487735, '1987-06-14', 'CLA-1090', '广东省,廉江市', 896, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10069:成娟淮', '成娟淮', '男', 26, 13354078384, '1987-06-21', 'CLA-1069', '青海省,河南蒙古族自治县', 821, getdate())
insert into student (no, name, sex, age, tel, birthday, classId, homeAddress, count, createTime) values ('BD-WH10004:成如村', '成如村', '女', 27, 13733889511, '1985-01-09', 'CLA-1004', '吉林省,梅河口市', 869, getdate())