1.將eb_store_product的表中帶視頻的數(shù)據(jù)導(dǎo)出備用
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.改造導(dǎo)出來(lái)的數(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ù)庫(kù)中執(zhí)行整段數(shù)據(jù)插入,原有帶視頻的商品就自動(dòng)轉(zhuǎn)成短視頻了
