insert into employee_master (`personal_number`, `first_name_of_employee_english`, `father_name`,`fathers_name_hindi`,`phone_number_residence_mob`,`permanent_address`,`permanent_address_hindi`,`present_address_english`,`caste`,`gender`,`merit_of_recruitment`,`unit_name`,`sub_unit_name`, `rank`, `home_state_name`, `joining_date`, `joining_designation`, `login_id`, `cadre`, `date_of_birth`) VALUES ('170950017', 'ROBIN YADAV', 'BRAHAM PAL SINGH YADAV','czge iky flag ;kno','7060970730','HOUSE NO 100 WARD NO 13, SHANKAR NAGAR, KHEKRA, BAGHPAT, UTTAR PRADESH-250101','gkml u- 100 o‚MZ u- 13] \'kadj uxj] [ksdjk] ckxir] mÙkj çns\'k&250101','HOUSE NO 100 WARD NO 13, SHANKAR NAGAR, KHEKRA, BAGHPAT, UTTAR PRADESH-250101','BACKWAR','Male','1','602','60206', '1008','','2017-03-15','1008','60206', 'COM', '1987-05-31')insert into new_posting_detail (`emp_id`, `key_id`, `personal_number`, `present_address`, `present_address_hindi`, `present_phone_residence_mobile`, `present_phone_office`, `present_range`, `present_state_name`, `present_district_name`, `present_rank`, `present_designation`, `proficiency_of_employee`, `present_grad`, `date_of_selection_grad`, `s_selection_grad_date`, `s_selection_grad`, `higher_selection_grad_date`, `higher_selection_grad`, `transfer_posting_flag`, `transfer_order_date`, `order_no`, `release_date`, `type_of_joining`, `joining_unit`, `joining_sub_unit`, `transfer_reason`, `posting_date`, `posting_time`, `pormotion_date`, `alloted_to`, `first_name_of_employee_english`, `middle_name_of_employee_english`, `last_name_of_employee_english`, `zone_name`, `archive_date`, `nature_of_job`, `joining_date`, `trans_date`, `cader`, `ipo_no`) VALUES ('0', NULL, '170950017', 'HOUSE NO 100 WARD NO 13, SHANKAR NAGAR, KHEKRA, BAGHPAT, UTTAR PRADESH-250101', NULL, '7060970730', '7060970730', NULL, 'UTTAR PRADESH', 'DEORIA', '1008', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Def', '602', '60206', NULL, NULL, NULL, NULL, '0', 'ROBIN YADAV', '', '', NULL, '', NULL, '2017-03-15', '', 'COM', '')