批量修改附件售价

tkbianyuan

批量设置附件价格，在网上查一下，发现下面这个语法是能用的，但是把图片都包括在里了，图片作为展示不能设置价格，怎么把图片格式的不设置价格呢?谢谢！
UPDATE `pre_forum_attachment_0` SET price = 0  WHERE 1 ;UPDATE `pre_forum_attachment_1` SET price = 0  WHERE 1 ;UPDATE `pre_forum_attachment_2` SET price = 0  WHERE 1 ;UPDATE `pre_forum_attachment_3` SET price = 0  WHERE 1 ;UPDATE `pre_forum_attachment_4` SET price = 0  WHERE 1 ;UPDATE `pre_forum_attachment_5` SET price = 0  WHERE 1 ;UPDATE `pre_forum_attachment_6` SET price = 0  WHERE 1 ;UPDATE `pre_forum_attachment_7` SET price = 0  WHERE 1 ;UPDATE `pre_forum_attachment_8` SET price = 0  WHERE 1 ;UPDATE `pre_forum_attachment_9` SET price = 0  WHERE 1 ;

我知道答案 回答被采纳将会获得1 贡献 已有3人回答

bangyang

UPDATE `pre_forum_attachment_0` SET price = 0  WHERE isimage=0 ;UPDATE `pre_forum_attachment_1` SET price = 0  WHERE isimage=0 ;UPDATE `pre_forum_attachment_2` SET price = 0  WHERE isimage=0 ;UPDATE `pre_forum_attachment_3` SET price = 0  WHERE isimage=0 ;UPDATE `pre_forum_attachment_4` SET price = 0  WHERE isimage=0 ;UPDATE `pre_forum_attachment_5` SET price = 0  WHERE isimage=0 ;UPDATE `pre_forum_attachment_6` SET price = 0  WHERE isimage=0 ;UPDATE `pre_forum_attachment_7` SET price = 0  WHERE isimage=0 ;UPDATE `pre_forum_attachment_8` SET price = 0  WHERE isimage=0 ;UPDATE `pre_forum_attachment_9` SET price = 0  WHERE isimage=0 ;

bangyang

数据库操作前务必先做好备份操作

tkbianyuan

bangyang 发表于 2021-11-4 17:07
数据库操作前务必先做好备份操作

非常感谢大哥！！可以了！