第五章——数据清洗与校验（案例七：数据一致性处理）

于 2022-11-12 15:56:17 发布
阅读量246 收藏
点赞数
文章标签： 数据库 mysql 前端
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_57368654/article/details/127820748
版权

1.数据准备

准备一张名为Personnel_Information的数据表，该表中主要记录了500名职员的性别、身高、体重及健康值,在MySQL中输入以下代码：

create table `personnel_information` (
	`USERID` int (11),
	`GENDER` varchar (765),
	`HEIGHT` varchar (765),
	`WEIGHT` varchar (765),
	`INDEX` varchar (765)
); 
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000001','Female','174','96','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000002','Male','189','87','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000003','Female','185','110','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000004','Female','195','104','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000005','Male','149','61','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000006','Male','189','104','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000007','Male','147','92','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000008','Male','154','111','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000009','Male','174','90','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000010','Female','169','103','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000011','Male','195','81','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000012','Female','159','80','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000013','Female','192','101','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000014','Male','155','51','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000015','Male','191','79','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000016','Female','153','107','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000017','Female','157','110','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000018','Male','140','129','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000019','Male','144','145','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000020','Male','172','139','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000021','Male','157','110','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000022','Female','153','149','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000023','Female','169','97','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000024','Male','185','139','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000025','Female','172','67','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000026','Female','151','64','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000027','Male','190','95','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000028','Male','187','62','1');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000029','Female','163','159','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000030','Male','179','152','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000031','Male','153','121','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000032','Male','178','52','1');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000033','Female','195','65','1');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000034','Female','160','131','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000035','Female','157','153','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000036','Female','189','132','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000037','Female','197','114','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000038','Male','144','80','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000039','Female','171','152','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000040','Female','185','81','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000041','Female','175','120','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000042','Female','149','108','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000043','Male','157','56','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000044','Male','161','118','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000045','Female','182','126','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000046','Male','185','76','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000047','Female','188','122','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000048','Male','181','111','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000049','Male','161','72','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000050','Male','140','152','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000051','Female','168','135','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000052','Female','176','54','1');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000053','Male','163','110','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000054','Male','172','105','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000055','Male','196','116','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000056','Female','187','89','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000057','Male','172','92','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000058','Male','178','127','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000059','Female','164','70','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000060','Male','143','88','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000061','Female','191','54','0');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000062','Female','141','143','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000063','Male','193','54','0');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000064','Male','190','83','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000065','Male','175','135','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000066','Female','179','158','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000067','Female','172','96','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000068','Female','168','59','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000069','Female','164','82','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000070','Female','194','136','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000071','Female','153','51','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000072','Male','178','117','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000073','Male','141','80','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000074','Male','180','75','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000075','Female','185','100','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000076','Female','197','154','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000077','Male','165','104','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000078','Female','168','90','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000079','Female','176','122','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000080','Male','181','51','0');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000081','Male','164','75','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000082','Female','166','140','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000083','Female','190','105','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000084','Male','186','118','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000085','Male','168','123','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000086','Male','198','50','0');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000087','Female','175','141','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000088','Male','145','117','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000089','Female','159','104','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000090','Female','185','140','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000091','Female','178','154','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000092','Female','183','96','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000093','Female','194','111','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000094','Male','177','61','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000095','Male','197','119','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000096','Female','170','156','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000097','Male','142','69','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000098','Male','160','139','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000099','Male','195','69','1');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000100','Female','190','50','0');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000101','Male','199','156','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000102','Male','154','105','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000103','Male','161','155','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000104','Female','198','145','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000105','Female','192','140','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000106','Male','195','126','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000107','Male','166','160','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000108','Male','159','154','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000109','Female','181','106','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000110','Male','149','66','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000111','Female','150','70','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000112','Female','146','157','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000113','Male','190','135','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000114','Female','192','90','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000115','Female','177','96','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000116','Male','148','60','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000117','Female','165','57','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000118','Female','146','104','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000119','Male','144','108','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000120','Female','176','156','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000121','Female','168','87','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000122','Male','187','122','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000123','Male','187','138','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000124','Female','184','160','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000125','Female','158','149','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000126','Male','158','96','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000127','Male','194','115','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000128','Female','145','79','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000129','Male','182','151','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000130','Male','154','54','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000131','Female','168','139','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000132','Female','187','70','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000133','Female','158','153','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000134','Female','167','110','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000135','Female','171','155','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000136','Female','183','150','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000137','Female','190','156','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000138','Male','194','108','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000139','Male','171','147','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000140','Male','159','124','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000141','Female','169','54','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000142','Female','167','85','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000143','Male','180','149','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000144','Male','163','123','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000145','Male','140','79','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000146','Male','197','125','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000147','Male','194','106','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000148','Female','140','146','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000149','Male','195','98','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000150','Female','168','115','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000151','Female','196','50','0');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000152','Male','140','52','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000153','Female','150','60','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000154','Female','168','140','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000155','Female','155','111','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000156','Female','179','103','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000157','Female','182','84','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000158','Male','168','160','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000159','Female','187','102','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000160','Male','181','105','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000161','Male','199','99','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000162','Female','184','76','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000163','Male','192','101','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000164','Female','182','143','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000165','Female','172','111','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000166','Male','181','78','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000167','Male','176','109','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000168','Female','156','106','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000169','Female','151','67','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000170','Female','188','80','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000171','Male','187','136','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000172','Male','174','138','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000173','Male','167','151','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000174','Female','196','131','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000175','Male','197','149','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000176','Female','185','119','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000177','Female','170','102','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000178','Female','181','94','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000179','Female','166','126','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000180','Male','188','100','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000181','Female','162','74','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000182','Male','177','117','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000183','Male','162','97','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000184','Male','180','73','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000185','Female','192','108','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000186','Male','165','80','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000187','Female','167','135','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000188','Female','182','84','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000189','Female','161','134','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000190','Male','158','95','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000191','Male','141','85','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000192','Male','154','100','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000193','Male','165','105','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000194','Female','142','137','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000195','Male','141','94','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000196','Male','145','108','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000197','Male','157','74','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000198','Female','177','117','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000199','Female','166','144','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000200','Male','193','151','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000201','Male','184','57','1');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000202','Male','179','93','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000203','Female','156','89','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000204','Male','182','104','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000205','Male','145','160','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000206','Female','150','87','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000207','Male','145','99','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000208','Female','196','122','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000209','Male','191','96','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000210','Female','148','67','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000211','Female','150','84','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000212','Male','148','155','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000213','Female','153','146','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000214','Female','196','159','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000215','Female','185','52','0');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000216','Female','171','131','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000217','Female','143','118','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000218','Female','142','86','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000219','Female','141','126','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000220','Male','159','109','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000221','Female','173','82','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000222','Male','183','138','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000223','Female','152','90','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000224','Male','178','140','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000225','Male','188','54','0');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000226','Female','155','144','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000227','Male','166','70','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000228','Male','188','123','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000229','Female','171','120','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000230','Male','179','130','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000231','Female','186','137','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000232','Female','153','78','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000233','Female','184','86','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000234','Female','177','81','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000235','Male','145','78','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000236','Male','170','81','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000237','Male','181','141','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000238','Male','165','155','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000239','Female','174','65','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000240','Female','146','110','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000241','Male','178','85','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000242','Male','166','61','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000243','Male','191','62','1');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000244','Female','177','155','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000245','Female','183','50','0');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000246','Male','151','114','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000247','Male','182','98','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000248','Female','142','159','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000249','Female','188','90','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000250','Male','161','89','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000251','Male','153','70','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000252','Male','140','143','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000253','Male','169','141','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000254','Female','162','159','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000255','Male','183','147','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000256','Female','162','58','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000257','Female','172','109','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000258','Female','150','119','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000259','Female','169','145','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000260','Female','184','132','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000261','Male','159','104','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000262','Male','163','131','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000263','Male','156','137','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000264','Female','157','52','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000265','Male','147','84','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000266','Male','141','86','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000267','Male','173','139','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000268','Male','154','145','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000269','Male','168','148','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000270','Male','168','50','1');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000271','Male','145','130','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000272','Male','152','103','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000273','Female','187','121','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000274','Female','163','57','0');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000275','Male','178','83','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000276','Female','187','94','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000277','Female','179','114','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000278','Male','190','80','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000279','Male','172','75','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000280','Male','188','57','1');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000281','Male','193','65','1');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000282','Female','147','126','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000283','Female','147','94','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000284','Male','166','107','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000285','Female','192','139','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000286','Male','181','139','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000287','Male','150','74','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000288','Male','178','160','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000289','Female','156','52','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000290','Male','149','100','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000291','Male','156','74','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000292','Male','183','105','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000293','Female','162','68','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000294','Female','165','83','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000295','Female','168','143','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000296','Male','160','156','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000297','Female','169','88','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000298','Female','140','76','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000299','Female','187','92','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000300','Male','151','82','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000301','Female','186','140','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000302','Male','182','108','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000303','Male','188','81','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000304','Male','179','110','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000305','Female','156','126','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000306','Male','188','114','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000307','Male','183','153','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000308','Male','144','88','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000309','Male','196','69','1');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000310','Male','171','141','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000311','Male','171','147','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000312','Female','180','156','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000313','Male','191','146','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000314','Female','179','67','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000315','Female','180','60','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000316','Female','154','132','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000317','Male','188','99','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000318','Male','142','135','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000319','Male','170','95','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000320','Male','152','141','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000321','Female','190','118','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000322','Female','181','111','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000323','Male','153','104','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000324','Male','187','140','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000325','Female','144','66','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000326','Female','148','54','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000327','Female','199','92','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000328','Female','167','85','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000329','Female','164','71','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000330','Female','185','102','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000331','Female','164','160','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000332','Male','142','71','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000333','Male','165','68','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000334','Female','172','62','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000335','Female','157','56','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000336','Male','155','57','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000337','Female','167','153','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000338','Female','164','126','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000339','Female','189','125','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000340','Female','161','145','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000341','Female','155','71','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000342','Female','171','118','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000343','Female','154','92','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000344','Male','179','83','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000345','Male','170','115','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000346','Female','184','106','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000347','Female','191','68','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000348','Male','162','58','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000349','Male','178','138','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000350','Female','157','60','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000351','Male','184','83','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000352','Male','197','88','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000353','Female','160','51','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000354','Male','184','153','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000355','Male','190','50','0');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000356','Male','174','90','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000357','Female','189','124','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000358','Female','186','143','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000359','Female','180','58','1');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000360','Female','186','148','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000361','Female','193','61','1');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000362','Male','161','103','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000363','Female','151','158','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000364','Female','195','147','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000365','Female','184','152','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000366','Male','141','80','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000367','Female','185','94','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000368','Female','186','127','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000369','Male','142','131','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000370','Female','147','67','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000371','Male','151','62','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000372','Female','160','124','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000373','Male','185','60','1');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000374','Female','163','63','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000375','Male','174','95','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000376','Female','150','144','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000377','Male','142','91','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000378','Male','178','142','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000379','Female','154','96','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000380','Male','176','87','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000381','Male','159','120','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000382','Male','191','62','1');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000383','Male','177','117','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000384','Male','151','154','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000385','Female','182','149','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000386','Female','197','72','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000387','Male','146','138','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000388','Female','160','83','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000389','Female','157','66','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000390','Female','150','50','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000391','Female','167','58','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000392','Female','180','70','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000393','Female','183','76','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000394','Female','183','87','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000395','Female','152','154','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000396','Female','164','71','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000397','Male','187','96','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000398','Male','169','136','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000399','Female','149','61','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000400','Male','163','137','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000401','Female','195','104','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000402','Male','174','107','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000403','Male','182','70','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000404','Male','169','110','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000405','Male','193','130','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000406','Male','148','141','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000407','Male','186','68','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000408','Male','165','143','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000409','Female','146','123','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000410','Female','166','133','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000411','Male','179','56','1');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000412','Female','177','101','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000413','Male','181','154','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000414','Female','161','154','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000415','Female','157','103','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000416','Female','169','98','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000417','Female','152','114','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000418','Female','162','64','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000419','Male','162','130','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000420','Female','177','61','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000421','Female','195','61','1');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000422','Male','140','146','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000423','Female','186','146','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000424','Female','178','107','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000425','Male','174','54','1');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000426','Female','180','59','1');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000427','Male','188','141','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000428','Female','187','130','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000429','Female','153','77','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000430','Female','165','95','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000431','Female','178','79','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000432','Female','163','154','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000433','Female','150','97','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000434','Male','179','127','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000435','Male','165','62','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000436','Male','168','158','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000437','Female','153','133','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000438','Male','184','157','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000439','Male','188','65','1');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000440','Female','166','153','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000441','Female','172','116','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000442','Male','182','73','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000443','Male','143','149','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000444','Male','152','146','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000445','Female','186','128','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000446','Male','159','140','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000447','Male','146','70','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000448','Female','176','121','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000449','Female','146','101','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000450','Male','159','145','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000451','Male','162','157','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000452','Female','172','90','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000453','Female','169','121','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000454','Male','182','50','0');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000455','Female','183','79','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000456','Male','176','77','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000457','Female','188','128','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000458','Female','175','83','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000459','Male','154','81','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000460','Female','184','147','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000461','Male','179','123','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000462','Male','152','132','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000463','Male','179','56','1');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000464','Female','145','141','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000465','Female','181','80','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000466','Male','158','127','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000467','Female','188','99','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000468','Male','145','142','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000469','Male','161','115','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000470','Male','198','109','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000471','Male','147','142','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000472','Male','154','112','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000473','Female','178','65','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000474','Male','195','153','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000475','Female','167','79','3');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000476','Male','183','131','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000477','Female','164','142','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000478','Male','167','64','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000479','Female','151','55','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000480','Female','147','107','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000481','Female','155','115','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000482','Female','172','108','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000483','Female','142','86','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000484','Male','146','85','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000485','Female','188','115','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000486','Male','173','111','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000487','Female','160','109','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000488','Male','187','80','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000489','Male','198','136','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000490','Female','179','150','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000491','Female','164','59','2');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000492','Female','146','147','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000493','Female','198','50','0');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000494','Female','170','53','1');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000495','Male','152','98','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000496','Female','150','153','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000497','Female','184','121','4');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000498','Female','141','136','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000499','Male','150','95','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000500','Male','173','131','5');
insert into `personnel_information` (`USERID`, `GENDER`, `HEIGHT`, `WEIGHT`, `INDEX`) values('00000000501','Male','166','130','5');

2.新建一个转换并按照下述新建好步骤然后用跳连接

 3.配置表输入控件

双击“表输入”控件，进入“表输入”配置界面；单击【新建】按钮，配置数据库连接，配置完成后单击【确认】按钮。

 在SQL框中编写查询数据表interpolation_data的SQL语句，然后单击【预览】按钮，查看数据表Personnel_Information的数据是否成功从MySQL数据库中抽取到表输入流中。

 

 4.配置“值映射”控件

双击“值映射”控件，进入“值映射”配置界面；在“使用的字段名”处的下拉框选择字段GENDER；在“字段值”框中，添加源值和目标值，这里是将Male替换成数字0，将Female替换成数字1。

 

5. 配置”插入/更新”控件

双击“插入/更新”控件，进入“插入/更新”界面；单击【新建】按钮，配置数据库连接，配置完成后单击【确认】按钮。

 单击目标表右侧的【浏览】按钮，选择目标表Personnel_ Information_New。单击【获取字段】按钮，用来指定查询数据所需要的关键字，这里选择的是Personnel_ Information_New数据表中的USERID字段和输入流里面的USERID字段；单击【获取和更新字段】按钮，用来指定需要更新的字段。

 6.保存并运行，成功后截图如下

 7.查看数据表Personnel_ Information_New中的数据

 由于转换data _consistency的运行只是单次的，若是后续需要进行将原始数据进行转换、插入操作，则需要运行该转换，这样工作效率很低，因此，通过Kettle工具创建一个作业，对转换data _consistency设置定时器，使得转换data _consistency程序定时自动执行数据同步的操作。

8.打开Kettle工具，创建作业并添加“Start”控件、“转换”控件以及作业跳连接线。

9. 配置“Start”控件

双击“Start”控件，进入“作业定时调度”界面；勾选“重复”处的复选框；单击“类型”处的下拉框，选择“时间间隔”定时，并设置以秒计算的间隔是5，以分钟计算的间隔是0。

10. 配置“转换”控件

双击“转换”控件，进入“转换”界面；单击【浏览】按钮，选择添加转换至作业中。

 11.保存并运行，成功后截图如下

 从控制台的日志输出可以看出，作业每隔5秒会执行一次转换实现数据同步并且在执行过程中会记录处理的数据量以及当前时间段处理的数据条数。

非子鱼
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
kettle 数据过滤,验证
10-30
个人总结的kettle的脚本，包含身份证15位转18位，以及各种数据正则验证
kettle实例--数据检验-数据一致性处理
fxxhmn的博客
10-11 1485
单击【新建】按钮，配置数据库连接，配置完成后单击【确认】按钮。单击【获取字段】按钮，用来指定查询数据所需要的关键字，这里选择的是Personnel_ Information_New数据表中的USERID字段和输入流里面的USERID字段；1.使用Kettle工具，创建一个转换data _consistency，并添加“表输入”控件、“值映射”控件、“插入/更新”控件以及Hop跳连接线。2.双击“表输入”控件，进入“表输入”配置界面；单击【新建】按钮，配置数据库连接，配置完成后单击【确认】按钮。
数据一致性处理
展望未来
03-25 2965
数据一致性处理 当多个进程同时操作同一个数据，会产生资源争抢，数据一致性的问题。 高并发情况下，涉及到写操作时，不可能直接操作数据库，大并发的连接会导致mysql请求会阻塞，比如大量的insert update 请求到，会直接导致无数的行锁和表锁，甚至最后堆积很多，从来触发too many connections 错误。 web服务器 nginx和apac...
5.4.1数据一致性处理
qq_56616859的博客
11-12 617
数据一致性是指在对一个副本数据进行更新的同时，必须确保也能够更新到其他的副本，否则不同的副本之间的数据将不再一致。例如，当你在某银行已存有5000元，接着又存了1000元，然后跑到另外一个地方游山玩水，需要在当地的银行把这6000元取出来，但是存钱的银行并没有及时将你存钱的信息传给当地的银行，所以当地银行还不知道你已经存了1000元进去，当地银行的工作人员告诉你说账户余额就只有5000元，这时候你的同一个账户的余额在不同地点就出现了不一致。
数据一致性解决方案
HappyRocking的专栏
09-21 1587
Consistency，Availability和Partition Tolerance（ CAP定理）：分区、一致性、可用性，三者不能同时满足。所以退而求其次，达到最终一致性，而不是实时一致性。 1、定时同步。可以是增量的，按照时间来。 2、用消息日志的方式来异步执行。消息日志可以存储到本地文本、数据库或消息队列，再通过业务规则自动或人工发起重试。消息日志方案的核心是保证服务
EasyValidate优雅地校验提交数据完整性
08-26
主要介绍了EasyValidate优雅地校验提交数据完整性，小编觉得挺不错的，现在分享给大家，也给大家做个参考。一起跟随小编过来看看吧
项目实战——钉钉报警校验ElasticSearch和Hive数据仓库内的数据质量（Java版本）
10-24
此篇文章主要选取关键性指标，数据校验数据源Hive和目标ES内的数据是否一致； 因为你不知道将Hive的数据导入到了ElasticSearch后，数据量是否准确，所以需要钉钉报警校验ElasticSearch和Hive数据仓库内的数据质量，...
数据通信与计算机网络实验：CRC校验.docx
10-29
数据通信与计算机网络
c# 数据标注与数据校验
12-16
数据标注（Data Annotation）是类或类成员添加上下文信息的一种方式，在 C# 通常用特性（Attribute）类来描述。它的用途主要可以分为下面这三类： 验证 Validation：向数据添加验证规则 显示 Display：指定数据...
简单处理数据库数据一致性
斌斌(Java)
04-04 782
今天看到下面这种连接数据库的写法，简单有用，特共享此段代码（如下）： Code: try   {       Connection conn = DriverManager.getConnection(               "jdbc:mysql://localhost:3306/bbs", "bbs", "bbs");  
kettle数据清洗
09-18
利用kettle工具进行数据清洗，按照条件去除不需要的内容
Kettle通过Java脚本清洗数据的demo
03-29
这个是Kettle一个转换的脚本，可以通过这个demo结合java代码来进行数据清洗。
《在kettle中实现数据验证和检查》示例代码
09-17
《在kettle中实现数据验证和检查》示例代码,学习数据验证和检查的最佳示例。
大数据 Excel 通过 Kettle 进行数据清洗
12-05
大数据Excel通过Kettle 穿插javascript进行数据清洗 在将数据导入Excel里
在kettle中实现数据验证和检查
weixin_34037173的博客
11-12 2881
在kettle中实现数据验证和检查             在ETL项目，输入数据通常不能保证一致性。在kettle中有一些步骤能够实现数据验证或检查。验证步骤能够在一些计算的基础上验证行货字段；过滤步骤实现数据过滤；javascript步骤能够实现更复杂的计算。         通常以某种方式查看那些数据是有缺陷的也是实用的，由于大多数ETL是无人值守执行的，所以通常ETL程序...
Kettle实例-数据检验-数据规范化处理
fxxhmn的博客
10-11 4269
单击【增加检验】按钮，弹出“输入检验的名称”窗口，在该窗口中添加检验名称date_verify用于校验如期，添加后单击【确定】按钮关闭“输入检验的名称”窗口。6.单击【增加检验】按钮，弹出“输入检验的名称”窗口，在该窗口中添加检验名称price_verify用于校验产品单价，添加后单击【确定】按钮关闭“输入检验的名称”窗口。5.单击【增加检验】按钮，弹出“输入检验的名称”窗口，在该窗口中添加检验名称name_verify用于校验商品名称，添加后单击【确定】按钮关闭“输入检验的名称”窗口。
kettle案例——数据清洗与校验（完全去重）
weixin_56944252的博客
11-11 463
数据清洗与校验
第五章kettle（数据规范化处理）
m0_69235938的博客
10-08 903
数据规范化处理
Kettle：综合案例--构建DVD租赁商店数据仓库
blessings_的博客
11-04 2137
目录 1.加载日期数据至日期维度表 2.加载时间数据至时间维度表 3.加载员工数据至员工维度表 1.加载日期数据至日期维度表 （1）创建转换 使用Kettle工具，创建一个转换，并添加生成记录控件、增加序列控件、JavaScript代码控件、表输出控件以及Hop跳连接线，具体如图所示 （2）配置生成记录控件 双击“生成记录”控件，进入“生成记录”配置界面，在“限制”处添加生成的日期，默认为10，这里改为3650，即生成10年的日期（10*365）；在“字段”框添加字段language（语
mysql集群数据一致性校验
最新发布
06-10
MySQL集群中数据一致性校验可以通过以下几种方式来实现： 1. 数据库复制监控：使用MySQL自带的复制监控工具来监控数据复制的状态，确保数据在主库和从库之间的同步。 2. 数据库主从切换：在主库出现故障时，将从库...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值