insert into SteriliPurposeConsumeMgt (sterilizationPurposeId, consumptionPattern) select hp.id, '全部消耗' from HttpOption hp where hp.id in (select sterilizationPurposeId from SteriliPurposeDisposableGoods) and hp.id not in (select sterilizationPurposeId from SteriliPurposeConsumeMgt);