批量修改附件售價

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
數據庫操作前務必先做好備份操作

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