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;
解析:批量导入商品数据表
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;
解析:批量导入商品数据表