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