worlday Posted March 28, 2011 Share Posted March 28, 2011 首页推荐我想批量取消，也就是后台产品点进去Catalog 那边Home打钩要取消掉，但不知道是哪个字段，所以SQL就不能写了。那位大侠知道的请帮我一下，先谢过 Link to comment Share on other sites More sharing options...
worlday Posted March 28, 2011 Author Share Posted March 28, 2011 呼叫班长，班长帮我一下。。。。 Link to comment Share on other sites More sharing options...
21846657 Posted March 28, 2011 Share Posted March 28, 2011 备份好DB后，登入你的phpmyadmin，执行下面的SQL语句： DELETE FROM `ps_category_product` WHERE `id_category` = 1 AND `id_product` IN (这里面，需要填的是产品ID，用英文逗号隔开就可以了。譬如：1,2,3,4) Good luck! Link to comment Share on other sites More sharing options...
worlday Posted March 29, 2011 Author Share Posted March 29, 2011 谢谢，按那样解决了。。。 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now