select count(0) from product_detection

select count(0) from product_detection_latest

create table tmp like product_detection;

insert into product_detection_latest
select a.id, a.product_id, a.title, a.image_url, a.item_url, a.price, a.rating, a.sub_category,
a.reviews_count, a.review_change, a.rank_number, a.country, a.brand, a.source, a.tag, a.category,
a.create_time, a.reviews_count_latest, a.rating_latest, a.first_review_day, a.latest_review_day,
a.period, a.base, a.review_score,a.nn_socre,a.ins_sim_score,a.ins_engagemt_score,a.unit
from product_detection a join product_lastest b on a.product_id=b.product_id and a.id=b.id  ;

rename table goods to goods_bak;
rename table tmp to goods;