久久久久av_欧美日韩一区二区在线_国产精品三区四区_日韩中字在线

Discuz! 官方交流社區

標題: 批量修改附件售價 [打印本頁]

作者: tkbianyuan 時間: 2021-11-4 16:14
標題: 批量修改附件售價

批量設置附件價格，在網上查一下，發現下面這個語法是能用的，但是把圖片都包括在里了，圖片作為展示不能設置價格，怎么把圖片格式的不設置價格呢?謝謝！
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 ;

作者: bangyang 時間: 2021-11-4 17:06
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 時間: 2021-11-4 17:07
數據庫操作前務必先做好備份操作

作者: tkbianyuan 時間: 2021-11-4 17:45

bangyang 發表于 2021-11-4 17:07
數據庫操作前務必先做好備份操作

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

歡迎光臨 Discuz! 官方交流社區 (http://www.9999xn.com/)