批量設(shè)置附件價(jià)格,在網(wǎng)上查一下,發(fā)現(xiàn)下面這個(gè)語(yǔ)法是能用的,但是把圖片都包括在里了,圖片作為展示不能設(shè)置價(jià)格,怎么把圖片格式的不設(shè)置價(jià)格呢?謝謝!
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 時(shí)間: 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 時(shí)間: 2021-11-4 17:07
數(shù)據(jù)庫(kù)操作前務(wù)必先做好備份操作作者: tkbianyuan 時(shí)間: 2021-11-4 17:45