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_id
from quote
where product_id = 4
and quote_type = 1;

Leave a Reply

Your email address will not be published.