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

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

[复制链接]

157

主题

362

回帖

6843

积分

管理员

积分
6843
金钱
1944
贡献
4380
注册时间
2023-11-3
QQ
发表于 2024-1-28 20:00:01 | 显示全部楼层 |阅读模式
  1. ; }0 e& g2 L( {* w; Q4 W
  2. 1 K5 s2 |/ `3 X: q- u  w  m
  3. use account;* ?% [0 C6 }4 `9 v/ r: `( t
  4. DELETE FROM C_IP_BAN;+ M+ Y5 |' a! ~* K3 O
  5. DELETE FROM C_IP_PERMIT;
    7 Q) @3 F- R( Q% R! J
  6. DELETE FROM C_IP_PWD;3 ^( e' m( A7 R% x3 s  p
  7. DELETE FROM C_LOGINIPBLOCK_LOG;1 R+ L- _" F: b6 I5 ~3 S8 q; p
  8. DELETE FROM C_SEQUENCE;
    2 @, q; }$ T1 }) P! K
  9. DELETE FROM CP_USER_PROFILE;, B! ^- p0 f- `3 P) s4 h
  10. DELETE FROM MB_USR_IP;, U" n2 Q4 n% _' ]. t( q5 V
  11. DELETE FROM MB_USR_PUN;" G) L! o3 X' d7 r6 \
  12. DELETE FROM Tbl_user;
    2 ?9 }; n8 @# U- N
  13. DELETE FROM USER_CONNLOG_KEY;" ]9 f5 n/ b+ r# m
  14. DELETE FROM USER_PROFILE;
    , T! M" B8 e4 N
  15. GO7 ^6 k7 [# m2 V# @
  16. use billing;
    8 o' W1 e9 D4 ^$ S5 j/ m0 A
  17. DELETE FROM bl_error_log;
    : K% A& Q  K' z5 P
  18. DELETE FROM c_sequence;- O& F' W: N2 O/ M1 @" [4 K3 Q
  19. DELETE FROM dba_online_daily;
    ; ~. \* T& _8 a( V5 g
  20. DELETE FROM dba_online_daily_notok;
    / S: B; C, s5 k
  21. DELETE FROM Tbl_KeepId;; \1 k$ d. C- O* ], A9 z& L
  22. DELETE FROM user_account;$ t: |/ v: X! W" g
  23. DELETE FROM user_account;" E- u- B0 X. p" M+ ]/ d4 ~/ W, Q
  24. DELETE FROM user_charge_log;% w# p; M5 e- [; v3 |. C
  25. DELETE FROM user_everyday_use_info;
    ' g- p" t8 p! P6 t
  26. DELETE FROM user_give_log;+ ^9 H/ n  h0 W0 f# Y- y
  27. DELETE FROM user_use_log;, G# m8 r3 h# x" _% f, b0 k
  28. DELETE FROM user_use_log_bk;6 U- ]2 {# U7 z1 p6 E! [0 i
  29. GO& ]- p* s; X( D2 U9 x/ s
  30. use cash;$ r0 c. |8 p4 U1 ]7 r! K1 j
  31. DELETE FROM bl_error_log;4 X- V0 ^/ {1 T- ^( U
  32. DELETE FROM Tbl_Cash_zj;  B) h0 B* [2 g
  33. DELETE FROM user_cash;
    ' _0 T1 h0 u: i3 t5 C
  34. DELETE FROM user_charge_log;
    " C/ z- E" _6 |; c2 i4 u/ d1 ~
  35. DELETE FROM user_use_log;$ T3 T1 k! ~7 Q$ H; Q
  36. GO5 T; Y* y! N9 b+ L7 ^5 C# n
  37. use character;
    ; C# y, h9 ]! B: t; m7 z! y1 y
  38. DELETE FROM C_EVENT_ITEM_OP
    & ?  k5 ?5 K0 A* K9 u0 y& n2 D* F( ]% o
  39. DELETE FROM c_restword;/ e: M7 V% ^. C! a9 f
  40. DELETE FROM char_connlog;0 g# Q& x! j0 h; v
  41. DELETE FROM CHAR_CONNLOG_KEY;  F  N  l0 f! O3 D- {" q
  42. DELETE FROM DEL_USER_CHAR_LIST;
    7 ~; a* n9 r/ N" Q* O
  43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;. x) j4 |# e- p% b" _
  44. DELETE FROM GM_ITEM_MST;
    7 x" m! H9 j! k! g
  45. DELETE FROM GUILD_CHAR_INFO;
    5 H, g! y% q( N/ }; ?# {
  46. DELETE FROM GUILD_INFO
      ^+ E# F) V& M& A' |
  47. WHERE guild_code NOT LIKE 'MASTERCODE';5 ~; f3 W- t8 g
  48. DELETE FROM GUILD_INFO_SECEDE;' F- V2 ~2 B9 Y& n3 b
  49. DELETE FROM GUILD_PEERAGE, M4 J: d( _. ^$ ?) T/ ?6 R' L* A
  50. WHERE guild_code NOT LIKE 'MASTERCODE';( v& F: K$ W6 E& E/ r" M
  51. DELETE FROM MSSNGR_CHAR_LIST;/ O' W( U" \+ H" A/ C
  52. DELETE FROM SIEGE_INFO;# l4 ?. \- n# e- v3 F8 C" ]( I
  53. DELETE FROM SIEGE_RESULT_LOG;# z! M( \/ G5 h
  54. DELETE FROM user_bag4 N+ y4 c2 f3 I2 d1 r% ~# U' M
  55. WHERE character_no NOT LIKE 'DEKARON_000001';$ f2 Y$ e: S# k% p& V
  56. DELETE FROM user_bag_copy;. v( s; j' j( i6 p0 T  f
  57. DELETE FROM user_bag_secede;
      E1 J' g9 d5 A
  58. DELETE FROM user_character* i0 T0 K  G8 L  z
  59. WHERE character_no NOT LIKE 'DEKARON_000001';
    " I+ N5 D0 G" Q
  60. DELETE FROM user_character_secede;* U. M' }2 h6 _% @
  61. DELETE FROM USER_POSTBOX;. X3 G+ y; Z$ V9 x3 s8 v) r1 f; A% U3 N
  62. DELETE FROM USER_POSTBOX_SECEDE;
    2 g: N2 Y6 U& E% F' s
  63. DELETE FROM User_Quest_Doing;- i7 S9 C9 Z8 ^# r
  64. DELETE FROM user_quest_doing_secede;5 }0 Y2 M) ?0 Q. A8 m) J
  65. DELETE FROM User_Quest_Done;
    . U. }. @0 J9 U' r
  66. DELETE FROM user_quest_done_secede;
    * b1 k( y9 c& L4 n% D
  67. DELETE FROM user_skill
    ) q8 o. @% S1 e0 Z- `
  68. WHERE character_no NOT LIKE 'DEKARON_000001';  \8 e% i3 [% S" t/ g4 x, Q
  69. DELETE FROM user_skill_secede' v$ g6 y: A( b" z! c
  70. DELETE FROM user_slot( v  A: H( f: }
  71. WHERE character_no NOT LIKE 'DEKARON_000001';
    7 L5 v  r4 j. A! I. M" D& S
  72. DELETE FROM user_storage;
    # D4 M! F/ ?9 F/ l% a6 d
  73. DELETE FROM user_storage_copy;* Z, `( ?9 O+ }- |; y6 T
  74. DELETE FROM USER_STORE;
    ( k3 \+ `( O5 R1 l: f
  75. DELETE FROM USER_STORE_copy;6 P% t* E: e/ j1 A% G; ^
  76. DELETE FROM USER_STORE_SECEDE;5 f/ X7 i! x2 N5 u) t5 H
  77. DELETE FROM user_suit
    * K5 g3 {0 a7 }5 S6 W: z' I
  78. WHERE character_no NOT LIKE 'DEKARON_000001';
    % Y4 }  X5 L* ~/ `) E$ E) N
  79. DELETE FROM user_suit_copy;9 b. N+ J1 \$ l3 R
  80. DELETE FROM user_suit_secede;5 G- D+ I# {. u& e
  81. GO
复制代码
2 p' o/ F/ `: V3 p

9 l, T4 f' H# e7 B# l2 o8 g
商业服务端 登录器 网站 出售

15

主题

256

回帖

1271

积分

金牌会员

积分
1271
金钱
873
贡献
122
注册时间
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

主题

68

回帖

7401

积分

论坛元老

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

157

主题

362

回帖

6843

积分

管理员

积分
6843
金钱
1944
贡献
4380
注册时间
2023-11-3
QQ
 楼主| 发表于 2024-10-16 16:39:16 | 显示全部楼层
大张 发表于 2024-10-16 14:56: O9 |6 U8 ?+ y
语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~!
; Y/ f9 y+ g9 P! q! T2 t" l
帖子里面有复制功能
商业服务端 登录器 网站 出售
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则


Archiver|小黑屋|EGameol

GMT+8, 2026-2-16 11:06 , Processed in 0.054818 second(s), 23 queries .

Powered by Discuz! X3.5

Copyright © 2001-2020, Tencent Cloud.

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