男的舔女的下面视频在线播放-少妇愉情理仑片高潮日本-久久久久久国产一区二区三区-麻豆精品一区二区综合-国产精品超碰在线观看-网红极品女神精品视频在线-国产亚洲综合777-高清性视频一区二区播放-中文字幕第一页亚洲天堂

Discuz! 官方交流社區(qū)

標(biāo)題: 批量修改附件售價(jià) [打印本頁(yè)]

作者: tkbianyuan 時(shí)間: 2021-11-4 16:14
標(biāo)題: 批量修改附件售價(jià)

批量設(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

bangyang 發(fā)表于 2021-11-4 17:07
數(shù)據(jù)庫(kù)操作前務(wù)必先做好備份操作

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

歡迎光臨 Discuz! 官方交流社區(qū) (http://m.sdtechgong.com.cn/)