update product id category id

#第一步:

#18是分类个数
update categories set categories_id = categories_id+18;

update categories_description set categories_id = categories_id+18;

update products_to_categories set categories_id = categories_id+18;

update products set master_categories_id= master_categories_id+18 ;

#有子类,1是有子分类的一级目录个数
update categories set parent_id= parent_id + 1 where parent_id >0; 

#第二步:
#610是商品个数
update products set products_id = products_id+610;

update products_attributes set products_id = products_id+610;

update products_description set products_id = products_id+610;

update products_to_categories set products_id = products_id+610;

#推荐
update featured set products_id = products_id+610;

#特价
update specials set products_id = products_id +610;

posted on 2012-12-05 11:38  haven24  阅读(305)  评论(0)    收藏  举报

导航