INSERT INTO ls_pos_history(id,emp_no, sys_org_code,mold) SELECT substring(md5(random()::varchar),2,10),emp_no,sys_org_code,'新入职' from ls_emp_info where key = 'KEY';
INSERT INTO ls_pos_history(id,emp_no, sys_org_code,mold) SELECT substring(md5(random()::varchar),2,10),emp_no,sys_org_code,'新入职' from ls_emp_info where key = 'KEY';