在不同商店中SHOPEX数据库商品数据表同步

最新推荐文章于 2021-01-21 14:56:20 发布

王其林

最新推荐文章于 2021-01-21 14:56:20 发布

阅读量299

点赞数

本文链接：https://blog.csdn.net/weixin_43446375/article/details/109096741

版权

第一步：清空目标数据库的SQL语句

TRUNCATE `lyq2012sdb_admin_roles`;
TRUNCATE `lyq2012sdb_promotion_activity`;
TRUNCATE `lyq2012sdb_sell_logs`;
TRUNCATE `lyq2012sdb_products`;
TRUNCATE `lyq2012sdb_promotion`;
TRUNCATE `lyq2012sdb_brand`;
TRUNCATE `lyq2012sdb_comments`;
TRUNCATE `lyq2012sdb_coupons`;
TRUNCATE `lyq2012sdb_coupons_p_items`;
TRUNCATE `lyq2012sdb_coupons_u_items`;
TRUNCATE `lyq2012sdb_dly_corp`;
TRUNCATE `lyq2012sdb_dly_h_area`;
TRUNCATE `lyq2012sdb_dly_type`;
TRUNCATE `lyq2012sdb_gift`;
TRUNCATE `lyq2012sdb_gift_cat`;
TRUNCATE `lyq2012sdb_gift_items`;
TRUNCATE `lyq2012sdb_gimages`;
TRUNCATE `lyq2012sdb_goods`;
TRUNCATE `lyq2012sdb_goods_cat`;
TRUNCATE `lyq2012sdb_goods_keywords`;
TRUNCATE `lyq2012sdb_goods_lv_price`;
TRUNCATE `lyq2012sdb_goods_memo`;
TRUNCATE `lyq2012sdb_goods_rate`;
TRUNCATE `lyq2012sdb_goods_spec_index`;
TRUNCATE `lyq2012sdb_goods_type`;
TRUNCATE `lyq2012sdb_goods_type_spec`;
TRUNCATE `lyq2012sdb_goods_virtual_cat`;
TRUNCATE `lyq2012sdb_job_goods_download`;
TRUNCATE `lyq2012sdb_member_lv`;
TRUNCATE `lyq2012sdb_package_product`;
TRUNCATE `lyq2012sdb_payment_cfg`;
TRUNCATE `lyq2012sdb_pmt_gen_coupon`;
TRUNCATE `lyq2012sdb_pmt_goods`;
TRUNCATE `lyq2012sdb_pmt_goods_cat`;
TRUNCATE `lyq2012sdb_pmt_member_lv`;
TRUNCATE `lyq2012sdb_product_memo`;
TRUNCATE `lyq2012sdb_return_product`;
TRUNCATE `lyq2012sdb_specification`;
TRUNCATE `lyq2012sdb_spec_values`;
TRUNCATE `lyq2012sdb_tag_rel`;
TRUNCATE `lyq2012sdb_taobao_goods_goods`;
TRUNCATE `lyq2012sdb_type_brand`;