表中的某些记录插入到另外一个表

EG: 

INSERT INTO abc
      (pd_id, pd_name, pd_ename, type_id, pd_place, pd_eplace, pd_model, pd_emodel,
      pd_brand, pd_ebrand, pd_price, pd_use, pd_feature, pd_photo1, pd_photo2,
      pd_photo3, pd_photo4, pd_para, pd_epara, pd_sell, pd_indate, pd_Exist, f_num)
SELECT pd_id, pd_name, pd_ename, type_id, pd_place, pd_eplace, pd_model, pd_emodel,
      pd_brand, pd_ebrand, pd_price, pd_use, pd_feature, pd_photo1, pd_photo2,
      pd_photo3, pd_photo4, pd_para, pd_epara, pd_sell, pd_indate, pd_Exist, f_num
FROM product
WHERE (pd_indate > '2006-07-19')