select * from zjr_shop_goods_sku_tmp inner join zjr_shop_goods on zjr_shop_goods_sku_tmp.pid=zjr_shop_goods.id where 1

找出無效sku
select * from zjr_shop_goods_sku_tmp left join zjr_shop_goods on zjr_shop_goods_sku_tmp.pid=zjr_shop_goods.id where zjr_shop_goods.id is null

copy產品名
update zjr_shop_goods_sku_tmp inner join zjr_shop_goods on zjr_shop_goods_sku_tmp.pid=zjr_shop_goods.id set zjr_shop_goods_sku_tmp.pname=zjr_shop_goods.name where 1