婷姐 发表于 2021-11-4 16:11:47

批量修改附件售价

批量设置附件价格,在网上查一下,发现下面这个语法是能用的,但是把图片都包括在里了,图片作为展示不能设置价格,怎么把图片格式的不设置价格呢?谢谢!
UPDATE`pre_forum_attachment_0`SET price = 0WHERE1 ;UPDATE`pre_forum_attachment_1`SET price = 0WHERE1 ;UPDATE`pre_forum_attachment_2`SET price = 0WHERE1 ;UPDATE`pre_forum_attachment_3`SET price = 0WHERE1 ;UPDATE`pre_forum_attachment_4`SET price = 0WHERE1 ;UPDATE`pre_forum_attachment_5`SET price = 0WHERE1 ;UPDATE`pre_forum_attachment_6`SET price = 0WHERE1 ;UPDATE`pre_forum_attachment_7`SET price = 0WHERE1 ;UPDATE`pre_forum_attachment_8`SET price = 0WHERE1 ;UPDATE`pre_forum_attachment_9`SET price = 0WHERE1 ;
页: [1]
查看完整版本: 批量修改附件售价

创宇盾启航版免费网站防御网站加速服务