主頁 > 網(wǎng)站建設(shè) > 建站知識 > 織夢清空所有會員的sql怎么寫,織夢怎么清空會

織夢清空所有會員的sql怎么寫,織夢怎么清空會

POST TIME:2017-11-12 23:41

執(zhí)行下面的sql語句即可完成清空,清空前建議先做好數(shù)據(jù)備份以免發(fā)生錯誤。

DELETE FROM dede_member WHERE mid >= 2 and mid<=200000;
DELETE FROM dede_member_person WHERE mid >= 2 and mid<=200000;
DELETE FROM dede_member_space WHERE mid >= 2 and mid<=200000;
DELETE FROM dede_member_tj WHERE mid >= 2 and mid<=200000;
DELETE FROM dede_member_operation WHERE aid >= 2 and aid<=200000;


上一篇:織夢問答常見問題修改,織夢問答修改

下一篇:織夢autoindex從02開始到10的寫法

收縮
  • 微信客服
  • 微信二維碼
  • 電話咨詢

  • 400-1100-266