MySQL中把一个查询结果插入到另外一个表中

insert into best_quote( quote_id, product_id, quote_type, quote_price, quote_amount, quote_time, company_id )select quote_id, product_id, quote_type, quote_price, quote_amount, quote_time, company_idfrom quotewhere product_id = 4and quote_type = 1;