Discuz 實用的SQL語法

on 2019 年 01 月 13 日 08:16:46 on 技術資料

Discuz 實用的SQL語法

批量刪除回帖 pre_forum_post 表中存儲的是論壇帖子和回覆。每增加一個帖子或者回覆，pid值+1. first值為1的，代表是主題。first值為0的，代表是回帖。

delete from pre_forum_post where pid>3 and pid<16283795 and first=0;

1	delete from pre_forum_post where pid>3 and pid<16283795 and first=0;

這是刪除語句，語法是：delete from 表名 where 條件 and 條件;

清空用戶勛章的SQL指令

UPDATE `pre_common_member_field_forum` SET `medals` = '';

1	UPDATE `pre_common_member_field_forum` SET `medals` = '';

批量刪除簽名的SQL語句

update pre_common_member_field_forum set sightml='';

1	update pre_common_member_field_forum set sightml='';

刪除指定貼子的所有回覆

DELETE FROM pre_forum_post WHERE first='0' AND tid=123;

1	DELETE FROM pre_forum_post WHERE first='0' AND tid=123;

pre_forum_post表所有tid=帖子ID First=0的就是回覆

Tags: Discuz, sql

Eric的攝影世界