这不是你想要的吗？

is this not what you want?

insert into YourTable
select distinct itemcode, 10 from YourTable