这个sql语句为什么执行了两次insert into E2JK_JKY (id,JGH,xm) select 5b62f9be3dba72b4022222222201112
这个sql语句为什么执行了两次
insert into E2JK_JKY (id,JGH,xm) select '5b62f9be3dba72b4022222222201112',jgh,XM from E2JK_RY where JGH ='101067'
这条sql语句为什么会执行两次
[解决办法]
try
insert into E2JK_JKY (id,JGH,xm) select distinct '5b62f9be3dba72b4022222222201112',jgh,XM from E2JK_RY where JGH ='101067'