数据有选择性的导入到所需要的表中

mysql> insert into test.goods
    -> select
    -> goods_id,cat_id,goods_sn,goods_name,click_count,goods_n
,shop_price,add_time,is_best,is_new,is_hot from shop.goods;

解析：批量导入商品数据表