请问，可以这么写吗？

insert into playercreateinfo_item (race,class,itemid,amount) values (select race,class from playercreateinfo_item where itemid='6948','23162','4');