+- 餅乾工坊 (http://ninja.s12.xrea.com/mybb)
+-- 版面: 電腦網路 (http://ninja.s12.xrea.com/mybb/forumdisplay.php?fid=2)
+--- 版面: 網頁相關 (http://ninja.s12.xrea.com/mybb/forumdisplay.php?fid=13)
+--- 主題: [Discuz]清空主題操作記錄 (/showthread.php?tid=491)
[Discuz]清空主題操作記錄 - NINJA - 03-08-2010
當版主對主題進行 置頂/精華..etc 的操作後,首篇最下方會出現操作記錄
清空方式:清空 cdb_threadsmod ,重建統計,更新緩存
有2種方式
引言:TRUNCATE TABLE `cdb_threadsmod`
引言:DELETE FROM `cdb_threadsmod`
註:
1.重建統計後,即使還原備份的cdb_threadsmod也不會再產生關聯,操作記錄不會再還原
2.建議保留合併記錄
DELETE FROM "表格名" WHERE {條件}
直接由資料庫中去除一些資料
TRUNCATE TABLE "表格名"
表格中的資料會完全消失，可是表格本身會繼續存在
刪除單一資料
引言:DELETE FROM `discuz`.`cdb_threadsmod` WHERE `cdb_threadsmod`.`tid` = 1 AND `cdb_threadsmod`.`uid` = 1 AND `cdb_threadsmod`.`username` = 'NINJA' AND `cdb_threadsmod`.`dateline` = 1271261753 AND `cdb_threadsmod`.`expiration` = 0 AND `cdb_threadsmod`.`action` = 'UDG' AND `cdb_threadsmod`.`status` = 1 AND `cdb_threadsmod`.`magicid` = 0 AND `cdb_threadsmod`.`stamp` = 0 LIMIT 1;
DELETE FROM `discuz`.`cdb_threadsmod` WHERE `cdb_threadsmod`.`tid` = 1 AND `cdb_threadsmod`.`uid` = 1 AND `cdb_threadsmod`.`username` = 'NINJA' AND `cdb_threadsmod`.`dateline` = 1271261827 AND `cdb_threadsmod`.`expiration` = 0 AND `cdb_threadsmod`.`action` = 'UHL' AND `cdb_threadsmod`.`status` = 1 AND `cdb_threadsmod`.`magicid` = 0 AND `cdb_threadsmod`.`stamp` = 0 LIMIT 1;