找回密码
 立即注册
查看: 6129|回复: 5

[技术文章] 数据库清档SQL语句

[复制链接]

167

主题

431

回帖

8422

积分

管理员

积分
8422
金钱
2429
贡献
5395
注册时间
2023-11-3
QQ
发表于 2024-1-28 20:00:01 | 显示全部楼层 |阅读模式

  1. / Q7 Y3 b) ^8 z% i* K

  2. " O7 h2 }) |0 j
  3. use account;
    & v' a( K  }- m1 h" R3 `
  4. DELETE FROM C_IP_BAN;) q$ O3 B- t& ?5 g7 ]8 p& ?' }# x
  5. DELETE FROM C_IP_PERMIT;
    ' r7 [1 @2 y7 F9 L9 U8 m$ R* c! H
  6. DELETE FROM C_IP_PWD;# q: O! {$ e% r/ F+ s5 C/ \8 p
  7. DELETE FROM C_LOGINIPBLOCK_LOG;& f) c0 P) n, c' Q
  8. DELETE FROM C_SEQUENCE;
    / s, s/ A2 v& X( X. `
  9. DELETE FROM CP_USER_PROFILE;
    . t8 Y4 V: _" J. P: v) Y8 R9 n
  10. DELETE FROM MB_USR_IP;- f9 u" j2 Q) O8 c1 {1 r* d9 z
  11. DELETE FROM MB_USR_PUN;
    / `6 ]" n/ a) J6 b2 o  M+ C
  12. DELETE FROM Tbl_user;, ~: h" E2 p& E; g+ y4 n: C& \; d
  13. DELETE FROM USER_CONNLOG_KEY;* {( ?) j! ]& f
  14. DELETE FROM USER_PROFILE;/ _. u+ X" r. p
  15. GO+ z8 z' M% Y  g
  16. use billing;
    & a- b( k  V8 v+ K
  17. DELETE FROM bl_error_log;+ }$ d6 B; |) b: q- w# }$ |
  18. DELETE FROM c_sequence;( u  w& t4 Q& i
  19. DELETE FROM dba_online_daily;* |% B& A9 Q+ \& g# N2 M5 h2 A+ d
  20. DELETE FROM dba_online_daily_notok;
    - u4 ~2 g7 L3 Y3 g$ {+ S' W
  21. DELETE FROM Tbl_KeepId;
    ' [0 D9 S3 K9 G2 k' O$ T$ @
  22. DELETE FROM user_account;
    7 ]6 a+ V8 L) o# n) J% K
  23. DELETE FROM user_account;- D$ v$ C2 ?; U+ q" J
  24. DELETE FROM user_charge_log;% L( z, r9 h9 ?$ ]
  25. DELETE FROM user_everyday_use_info;% c  B3 X# ~; A3 y) a4 t0 I' g. D
  26. DELETE FROM user_give_log;" G: U8 v. \' ]% ~6 i- N0 e# Z
  27. DELETE FROM user_use_log;3 e3 U: T! S5 y- z: u3 j  U
  28. DELETE FROM user_use_log_bk;
    6 M* d! L! q2 @' g
  29. GO2 w7 i0 g  D" z
  30. use cash;
    7 Y0 G, ^+ A  b% b% d. J
  31. DELETE FROM bl_error_log;+ j3 g; Q: w# b/ x# w
  32. DELETE FROM Tbl_Cash_zj;; u5 W/ @5 X+ o0 A! A& m
  33. DELETE FROM user_cash;% ]! U( e1 J- [+ G
  34. DELETE FROM user_charge_log;
    / n0 \3 P$ v, c  F  m
  35. DELETE FROM user_use_log;
    & X6 V; w) Q) b5 X: P+ }, ]; S, x5 `
  36. GO6 ]+ g7 o5 Q7 _% k; j
  37. use character;
    9 S0 i. i) k. C, Q$ Q) i9 k
  38. DELETE FROM C_EVENT_ITEM_OP  n2 t( W/ R5 c  v! E6 U+ E/ |3 A
  39. DELETE FROM c_restword;9 U" L+ w5 c% D4 X
  40. DELETE FROM char_connlog;9 J4 v- h' t1 \% e  g/ U
  41. DELETE FROM CHAR_CONNLOG_KEY;
    , Y. }  o8 H% ^- C
  42. DELETE FROM DEL_USER_CHAR_LIST;
    ! M8 Z/ Q' [1 c. Q
  43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;9 p/ Z" P; ^! {& s6 G
  44. DELETE FROM GM_ITEM_MST;
    2 ^& n. D. z4 P9 ]3 P9 R% ]0 W
  45. DELETE FROM GUILD_CHAR_INFO;
    7 g- v: }% `7 _  Q7 R
  46. DELETE FROM GUILD_INFO
    5 i+ H& ~- E- F' l: R8 `
  47. WHERE guild_code NOT LIKE 'MASTERCODE';) S, i- j* N3 ?3 ^
  48. DELETE FROM GUILD_INFO_SECEDE;5 R: L, n- R! p) [% u
  49. DELETE FROM GUILD_PEERAGE2 r; I) J) Q# ?) ?' K7 N
  50. WHERE guild_code NOT LIKE 'MASTERCODE';
    - B0 R2 Q7 f7 E( j! N% l
  51. DELETE FROM MSSNGR_CHAR_LIST;. m& h& d' [7 p$ k+ b$ G9 n
  52. DELETE FROM SIEGE_INFO;3 ^0 _) e0 v4 L# K) @
  53. DELETE FROM SIEGE_RESULT_LOG;" Q, V5 q6 h. _+ f  V" a; m7 ?
  54. DELETE FROM user_bag3 z7 j9 q9 M, t+ V- U/ H
  55. WHERE character_no NOT LIKE 'DEKARON_000001';3 N/ y0 V  T& C* T; Z, G5 H4 ?
  56. DELETE FROM user_bag_copy;
    0 ^, i' \) c+ E5 E& \) y) c9 Q
  57. DELETE FROM user_bag_secede;
    . @: M  o3 ~6 s6 p/ l) I& B/ I
  58. DELETE FROM user_character" {6 }& g; [* h. a0 C2 R" `2 l
  59. WHERE character_no NOT LIKE 'DEKARON_000001';6 ^# k7 e+ I; }# G5 M
  60. DELETE FROM user_character_secede;
    6 P$ V+ S4 y! ]" o+ H8 u
  61. DELETE FROM USER_POSTBOX;
    , I4 k2 K7 }" a2 G$ j- k" x5 H
  62. DELETE FROM USER_POSTBOX_SECEDE;* V: e4 d" ]0 |
  63. DELETE FROM User_Quest_Doing;' t6 m/ \* O6 P6 c  a
  64. DELETE FROM user_quest_doing_secede;
    9 h/ k* e9 r) x+ U
  65. DELETE FROM User_Quest_Done;9 @7 ?0 {5 c: |7 F/ f9 X1 F2 _
  66. DELETE FROM user_quest_done_secede;
    ' t5 @8 _1 D! w  {% @2 d
  67. DELETE FROM user_skill
    ( n) N4 D) o& z+ ?2 C3 V$ m
  68. WHERE character_no NOT LIKE 'DEKARON_000001';
    . P8 w  @1 D/ }8 c
  69. DELETE FROM user_skill_secede
    ' p" D; L8 q7 ^
  70. DELETE FROM user_slot7 b5 G' I! m0 o! C5 m
  71. WHERE character_no NOT LIKE 'DEKARON_000001';
    0 Q  j4 e" p; A+ U3 `9 j1 t
  72. DELETE FROM user_storage;
    5 n! v6 T% }7 F0 y7 J
  73. DELETE FROM user_storage_copy;
    ( h/ D$ F; ]- K% I
  74. DELETE FROM USER_STORE;
    + d' `. f0 e% _
  75. DELETE FROM USER_STORE_copy;
    1 {% G% V: d7 a6 m. n; y% i
  76. DELETE FROM USER_STORE_SECEDE;( v; b  N* B1 t7 u# m9 i
  77. DELETE FROM user_suit" I5 S6 p$ ?7 e. |
  78. WHERE character_no NOT LIKE 'DEKARON_000001';
    ' l2 p6 y& u# j. B; F0 k+ ]
  79. DELETE FROM user_suit_copy;2 D" d% o% C. R, h1 o. u
  80. DELETE FROM user_suit_secede;: r3 S6 q" G$ h" E' G" N' |
  81. GO
复制代码
1 l* l' D# M2 M- e! R/ }% E

, Z% \$ O+ Q1 G6 Q- ?, b! N
商业服务端 登录器 网站 出售

16

主题

271

回帖

1616

积分

金牌会员

积分
1616
金钱
1168
贡献
156
注册时间
2023-11-10
发表于 2024-1-29 15:23:38 | 显示全部楼层
我是来学习的!

21

主题

378

回帖

1013

积分

高级会员

积分
1013
金钱
445
贡献
169
注册时间
2024-1-20
发表于 2024-1-31 23:10:21 | 显示全部楼层
感谢楼主分享!!

0

主题

129

回帖

630

积分

高级会员

积分
630
金钱
380
贡献
121
注册时间
2024-9-19
发表于 2024-10-15 23:11:27 | 显示全部楼层
干活学习

0

主题

73

回帖

1万

积分

论坛元老

积分
10231
金钱
9356
贡献
802
注册时间
2023-11-23
发表于 2024-10-16 14:56:13 | 显示全部楼层
语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~!

167

主题

431

回帖

8422

积分

管理员

积分
8422
金钱
2429
贡献
5395
注册时间
2023-11-3
QQ
发表于 2024-10-16 16:39:16 | 显示全部楼层
大张 发表于 2024-10-16 14:56$ o; m1 n3 M! u
语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~!

& l: c2 O" s% N帖子里面有复制功能
商业服务端 登录器 网站 出售
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则


Archiver|小黑屋|EGameol

GMT+8, 2026-11-19 10:24 , Processed in 0.046640 second(s), 26 queries .

Powered by Discuz! X3.5

© 2001-2026 Discuz! Team.

快速回复 返回顶部 返回列表