找回密码
 立即注册
查看: 823|回复: 2

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

[复制链接]

106

主题

128

回帖

1475

积分

管理员

积分
1475
金钱
633
贡献
608
注册时间
2023-11-3
QQ
发表于 2024-1-28 20:00:01 | 显示全部楼层 |阅读模式
  1. 4 q4 G" c: \( o: h% ?/ n5 X

  2. & H2 |: v4 c9 S) q" e5 }8 m6 K
  3. use account;8 }2 L; s* @' E. v& g) F* d' B
  4. DELETE FROM C_IP_BAN;9 T0 P  q3 ?* i! D0 O% h8 N! M
  5. DELETE FROM C_IP_PERMIT;
    0 A* t$ l9 d# X6 y8 p% z
  6. DELETE FROM C_IP_PWD;
    / u" \: q# `# P. W5 M
  7. DELETE FROM C_LOGINIPBLOCK_LOG;, h/ ^! m% k6 j' G4 \
  8. DELETE FROM C_SEQUENCE;1 s0 |4 G* k3 ~# ?6 n# ?1 v* e9 S
  9. DELETE FROM CP_USER_PROFILE;
    4 H8 r* e/ y4 ~& H! r  e$ |
  10. DELETE FROM MB_USR_IP;/ I% {" s6 z4 Y$ W
  11. DELETE FROM MB_USR_PUN;1 k7 j5 W6 j+ _* i# a
  12. DELETE FROM Tbl_user;6 e7 J9 t0 v: r8 I3 g( t# b2 j2 X
  13. DELETE FROM USER_CONNLOG_KEY;* R! N4 e. o7 C" P
  14. DELETE FROM USER_PROFILE;
    ; ]% i- N% x4 _6 }" N5 b! @2 {
  15. GO
    3 T0 }0 G7 W8 d1 ?' b" O4 H, z
  16. use billing;) |. `/ P; J' m6 T* }
  17. DELETE FROM bl_error_log;7 L5 ], h5 p0 }! C' t8 C
  18. DELETE FROM c_sequence;
    1 O* o7 I' P: c$ F) C  _4 ?& G
  19. DELETE FROM dba_online_daily;
    8 ^& z, u3 v4 B) L! z/ H- g
  20. DELETE FROM dba_online_daily_notok;2 d8 M. m& s/ A0 ]( Z
  21. DELETE FROM Tbl_KeepId;0 L2 d- V- \- ?/ \
  22. DELETE FROM user_account;
    $ t  _& Y7 r; q) N& H, \5 r: v
  23. DELETE FROM user_account;' }$ J8 {1 V; Y2 ?" ^7 E5 i6 E
  24. DELETE FROM user_charge_log;
    + ^  F! L3 V% h) h4 k
  25. DELETE FROM user_everyday_use_info;
      I, |2 x! c& Q) N
  26. DELETE FROM user_give_log;
    ' D/ Z2 Z7 M! l" k" g. R; J
  27. DELETE FROM user_use_log;
    ( o5 ~. W9 \& C& a2 w6 T9 f$ C
  28. DELETE FROM user_use_log_bk;* q+ }2 J, Q! i! x5 M
  29. GO
    + ^4 V' V; H. V1 c
  30. use cash;6 d0 g% z% d5 i* _' l+ O) a
  31. DELETE FROM bl_error_log;
    6 G/ q% f- z0 u; H8 s# A
  32. DELETE FROM Tbl_Cash_zj;7 b+ Z, U! V: M
  33. DELETE FROM user_cash;( N2 h+ R; F! Q' y  L4 \/ L0 E
  34. DELETE FROM user_charge_log;! c5 U, b3 [( D
  35. DELETE FROM user_use_log;
    6 _- l: g/ a  ~. F7 s, Y* }
  36. GO/ b8 o/ Q# f2 l' d8 u) z4 e  V: l
  37. use character;
    * r, j5 e3 n* H- Q+ F
  38. DELETE FROM C_EVENT_ITEM_OP
    1 U! `; m, Q8 N5 S$ v
  39. DELETE FROM c_restword;1 D8 D7 S% w& E7 b2 o2 O% e" T
  40. DELETE FROM char_connlog;
    ( L, M  |3 \. m+ b) G. ]
  41. DELETE FROM CHAR_CONNLOG_KEY;0 m/ ^& `4 E7 @% ~9 Z
  42. DELETE FROM DEL_USER_CHAR_LIST;  Z( `4 U! Z; m* e" e
  43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;8 y- h& {+ u; C! P; R' s6 ~* l
  44. DELETE FROM GM_ITEM_MST;$ p' X' [0 e/ H2 C
  45. DELETE FROM GUILD_CHAR_INFO;
    , z' `4 b9 Q8 N$ I/ C, k
  46. DELETE FROM GUILD_INFO
    : {& z+ W8 g  e4 V6 O
  47. WHERE guild_code NOT LIKE 'MASTERCODE';
    " m$ \3 h0 n1 g' }( h8 V6 _
  48. DELETE FROM GUILD_INFO_SECEDE;
    : F$ Y% ]& e# E& L+ {; t# {
  49. DELETE FROM GUILD_PEERAGE
    7 k" J, ?  j+ u
  50. WHERE guild_code NOT LIKE 'MASTERCODE';
    9 b0 E2 R9 }5 z3 A0 B
  51. DELETE FROM MSSNGR_CHAR_LIST;
    " ~& T4 I) L  l
  52. DELETE FROM SIEGE_INFO;
    * B' t3 U* a5 V3 x$ L5 d, ]) B
  53. DELETE FROM SIEGE_RESULT_LOG;
    # R  s# r, m3 X. k6 g! ^
  54. DELETE FROM user_bag4 O4 Z/ Q: o% s  L
  55. WHERE character_no NOT LIKE 'DEKARON_000001';
    " N' H/ `, A+ z# E7 w) N
  56. DELETE FROM user_bag_copy;
    8 E% F6 Y; V# L' j0 s/ j5 p
  57. DELETE FROM user_bag_secede;: N4 @/ @( A# G& x1 Y0 |, i
  58. DELETE FROM user_character: A( ~% P8 G8 Q
  59. WHERE character_no NOT LIKE 'DEKARON_000001';
    ( @) }: ]' ~* ^. p. i
  60. DELETE FROM user_character_secede;
    ) v! W( F" k7 t( d8 D: d
  61. DELETE FROM USER_POSTBOX;
    ) J' C: o6 N% [1 j% B2 G3 b
  62. DELETE FROM USER_POSTBOX_SECEDE;- O0 k$ r: I6 C, @( j
  63. DELETE FROM User_Quest_Doing;
    " U( n( d1 ^3 [, ]* @' o
  64. DELETE FROM user_quest_doing_secede;
    # z5 J6 Q  i7 F1 ~/ p
  65. DELETE FROM User_Quest_Done;% C" n8 \  A: z3 n0 F9 T2 |3 w
  66. DELETE FROM user_quest_done_secede;" V  k4 R$ U& @, Y
  67. DELETE FROM user_skill
    % d  E5 [9 r/ y/ K$ w
  68. WHERE character_no NOT LIKE 'DEKARON_000001';
    * ]) {, S2 n% G9 _- O  y
  69. DELETE FROM user_skill_secede+ F7 h  d" G% t; |' v- b
  70. DELETE FROM user_slot
    , @, }" q8 M  P: x2 V
  71. WHERE character_no NOT LIKE 'DEKARON_000001';8 [/ g* v; l  {6 V0 {' o/ G) \/ n# P
  72. DELETE FROM user_storage;
    5 E7 R& m* T/ O/ T# u; N1 U' a* i
  73. DELETE FROM user_storage_copy;
    " L+ z- c& b# Q- _2 ^1 }
  74. DELETE FROM USER_STORE;
    9 N0 e( i9 Q5 @' Q# R: |, ?1 D8 t6 {
  75. DELETE FROM USER_STORE_copy;
    1 L- V6 \6 p0 A
  76. DELETE FROM USER_STORE_SECEDE;
    9 J" z3 X! p, e
  77. DELETE FROM user_suit
    ; c  n5 @" B' Q$ c6 K$ [, A
  78. WHERE character_no NOT LIKE 'DEKARON_000001';
    ) F+ ~- ]/ Q3 _  K6 j. _/ R
  79. DELETE FROM user_suit_copy;, }) Q1 N* I1 R) `5 c
  80. DELETE FROM user_suit_secede;! R( A2 ~! p$ `
  81. GO
复制代码
8 Z' j0 I0 G, _6 v" P, B% P

+ y7 d! C8 L& V/ n# H2 N
商业服务端 登录器 网站 出售

8

主题

188

回帖

454

积分

中级会员

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

21

主题

375

回帖

770

积分

高级会员

积分
770
金钱
284
贡献
90
注册时间
2024-1-20
发表于 2024-1-31 23:10:21 | 显示全部楼层
感谢楼主分享!!
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

Archiver|手机版|小黑屋|EGameol

GMT+8, 2024-6-16 06:28 , Processed in 0.072177 second(s), 32 queries .

Powered by Discuz! X3.5

Copyright © 2001-2020, Tencent Cloud.

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