1.將eb_store_product的表中帶視頻的數(shù)據(jù)導出備用
SELECT image,store_info,video_link,id,is_show,is_verify,is_verify FROM `eb_store_product` WHERE is_show=1 AND is_verify=1 AND pid=0 ORDER BY `eb_store_product`.`video_link` DESC
2.改造導出來的數(shù)據(jù)，將eb_store_product改為eb_video, 將
INSERT INTO `eb_store_product` (`image`, `store_info`, `video_link`, `id`, `is_show`, `is_verify`, `is_verify`) VALUES
改為
`INSERT INTO `eb_video` (`image`, `desc`, `video_url`, `product_id`, `is_show`, `is_recommend`, `is_verify`) VALUES`
3.在數(shù)據(jù)庫中執(zhí)行整段數(shù)據(jù)插入,原有帶視頻的商品就自動轉成短視頻了
