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

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

[复制链接]

155

主题

348

回帖

6155

积分

管理员

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

  1. * r# i( ]/ d! X, n

  2. . \( u( X$ ?( s" ~0 y" w
  3. use account;
    & l! w9 R( m9 R5 r: q& B: G
  4. DELETE FROM C_IP_BAN;
    2 h: |1 n' q  J- ^9 I; M' H! ~
  5. DELETE FROM C_IP_PERMIT;
    2 G4 y3 e. [3 X! ^  |
  6. DELETE FROM C_IP_PWD;
    " q  f  S7 I: X, [# S0 h6 _
  7. DELETE FROM C_LOGINIPBLOCK_LOG;* ^7 V3 m( f6 Y8 h. I5 ^. y
  8. DELETE FROM C_SEQUENCE;
    1 {( K8 H8 j- T* V7 O% b5 H
  9. DELETE FROM CP_USER_PROFILE;7 ]) b, q: m. E- U: D) _5 L, U' Z
  10. DELETE FROM MB_USR_IP;
    5 J  J# x- e) [, J& C# I4 m% i2 e
  11. DELETE FROM MB_USR_PUN;* V! y& s; L& D
  12. DELETE FROM Tbl_user;
    7 J6 W# {2 x+ D' ^- {4 {( K
  13. DELETE FROM USER_CONNLOG_KEY;, l; t! {- o2 S/ W' X- u- c
  14. DELETE FROM USER_PROFILE;
    " p: [  x7 e# T* S0 C
  15. GO
    0 D1 R) k7 x0 M! |8 \$ E' c2 d% p
  16. use billing;: g5 w- M  c& T' [
  17. DELETE FROM bl_error_log;7 m* j& Z' {% E- \1 ~
  18. DELETE FROM c_sequence;
    0 D- m$ |0 I7 w- T# Q
  19. DELETE FROM dba_online_daily;% O! l/ n# I5 l, w
  20. DELETE FROM dba_online_daily_notok;
    # h1 ]3 @0 H. f5 w* T
  21. DELETE FROM Tbl_KeepId;/ m! S+ I" V- ~+ s) z! X* o- D
  22. DELETE FROM user_account;
    $ o# d3 w  L1 Y5 E3 ?; e
  23. DELETE FROM user_account;* C/ o* j0 y- t6 W# K0 j3 ^0 h$ N
  24. DELETE FROM user_charge_log;. ]8 v% _* {8 C0 K" n
  25. DELETE FROM user_everyday_use_info;$ J* t8 S  v1 i8 W  E& @
  26. DELETE FROM user_give_log;3 I$ Q7 F% W' A0 j! x0 S' T' Q6 T
  27. DELETE FROM user_use_log;
    * ^. I/ q6 [5 O' c- W8 j% s
  28. DELETE FROM user_use_log_bk;3 X9 I; J# Z5 V3 @6 I: R
  29. GO
    , s& S* p- g" C. j
  30. use cash;+ A; J2 r0 E% ~7 h/ t- z) G+ |
  31. DELETE FROM bl_error_log;6 X' H1 k0 t- g3 ^
  32. DELETE FROM Tbl_Cash_zj;
    0 N; r. Q% L; s9 Z" l3 y# H
  33. DELETE FROM user_cash;" Y6 D  Y4 b% G+ |& C( z1 ~- T5 s
  34. DELETE FROM user_charge_log;" F0 }# A1 C! ]3 s" M" ]
  35. DELETE FROM user_use_log;+ Q8 d5 Z' R# o8 f5 r
  36. GO
    * n# a- F7 f6 K& e
  37. use character;
    . S) D  i# e% h& Z  x+ G' z
  38. DELETE FROM C_EVENT_ITEM_OP& m2 o1 N; }7 w, a/ D
  39. DELETE FROM c_restword;/ B: p4 a+ m! U$ E& m& O
  40. DELETE FROM char_connlog;
    & L3 u3 K. {7 Q4 p  ~& V) o
  41. DELETE FROM CHAR_CONNLOG_KEY;
    ' c# Y  L) @: e, @" u
  42. DELETE FROM DEL_USER_CHAR_LIST;4 J; R, N! Y1 [2 Q
  43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;- M3 i+ A3 M$ L5 {% w* N
  44. DELETE FROM GM_ITEM_MST;
    ' Q# z4 Q) P. G4 F1 Q
  45. DELETE FROM GUILD_CHAR_INFO;& {: I6 I3 Q: J
  46. DELETE FROM GUILD_INFO# I& F9 _1 l2 p: I* @
  47. WHERE guild_code NOT LIKE 'MASTERCODE';
    ( n. n" p9 K- o* f  w. e
  48. DELETE FROM GUILD_INFO_SECEDE;9 J$ k" x- U) v2 u: l1 |; F
  49. DELETE FROM GUILD_PEERAGE
    9 [8 ?/ m/ {3 i; @( p
  50. WHERE guild_code NOT LIKE 'MASTERCODE';
    # a6 w, P/ b9 V, o0 ?9 k3 y$ ?
  51. DELETE FROM MSSNGR_CHAR_LIST;- v; v: x6 l* V# c) O, {
  52. DELETE FROM SIEGE_INFO;
    ' z3 N+ \' j. n/ D: {' }
  53. DELETE FROM SIEGE_RESULT_LOG;0 }, h9 T' J. N, o/ {% H
  54. DELETE FROM user_bag6 t+ i( i! i5 k/ g' k
  55. WHERE character_no NOT LIKE 'DEKARON_000001';" m7 T4 \& o" _- ^
  56. DELETE FROM user_bag_copy;
    ! ^' S1 r4 Y/ g1 F& l6 X1 Q
  57. DELETE FROM user_bag_secede;( z5 T8 y# E7 I: D1 {& h) t
  58. DELETE FROM user_character# {9 i8 f, x  ]3 C8 _0 K1 v
  59. WHERE character_no NOT LIKE 'DEKARON_000001';) F+ l. [5 s0 h4 d) }
  60. DELETE FROM user_character_secede;( L8 Q$ d6 ?+ d7 U
  61. DELETE FROM USER_POSTBOX;4 m% E' Y( ?* @  \+ c4 |
  62. DELETE FROM USER_POSTBOX_SECEDE;
    ' v% b. t* f: x4 ~  f  T5 a
  63. DELETE FROM User_Quest_Doing;. r# B0 {, p/ f/ F  @; {; z
  64. DELETE FROM user_quest_doing_secede;
    8 z5 N, i5 s8 p9 {! P
  65. DELETE FROM User_Quest_Done;
    3 n" \9 u( |# |9 _' z5 b/ X
  66. DELETE FROM user_quest_done_secede;$ |2 Q" j4 f; N. d: v1 e! B/ N
  67. DELETE FROM user_skill. G( L2 W7 `6 Q, @  _* R
  68. WHERE character_no NOT LIKE 'DEKARON_000001';
    1 u- W! [+ z0 ^) e4 C( y  C) a
  69. DELETE FROM user_skill_secede7 O; m7 u! ^' _9 A5 h
  70. DELETE FROM user_slot) O. b3 Z) a4 Q4 h
  71. WHERE character_no NOT LIKE 'DEKARON_000001';
    / R2 t$ T1 ]/ G. q& L' c& h
  72. DELETE FROM user_storage;  b7 t# C# S4 b, {3 X
  73. DELETE FROM user_storage_copy;
    # k" c7 u! Z! B. Y, ]' G0 K0 M3 l+ V& Y
  74. DELETE FROM USER_STORE;
    3 r1 N+ w) N6 W1 S1 c& W
  75. DELETE FROM USER_STORE_copy;
    * w2 P; v' c8 H7 U) a! h
  76. DELETE FROM USER_STORE_SECEDE;
    3 q  U! n5 w. w# d" o8 a) |
  77. DELETE FROM user_suit
    0 s# j, t9 q( g7 X  Q# H
  78. WHERE character_no NOT LIKE 'DEKARON_000001';
    ( p% U/ ]: x) A& X* P1 C
  79. DELETE FROM user_suit_copy;. h. V8 v' l, Z& S: _6 y
  80. DELETE FROM user_suit_secede;' }% H; f+ n$ s' g% `2 }! X" z
  81. GO
复制代码

5 A! `/ K9 `: p1 w0 Q2 f
7 d# |1 C2 `& \& S, T
商业服务端 登录器 网站 出售

13

主题

251

回帖

1242

积分

金牌会员

积分
1242
金钱
814
贡献
159
注册时间
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

回帖

6504

积分

论坛元老

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

155

主题

348

回帖

6155

积分

管理员

积分
6155
金钱
1868
贡献
3784
注册时间
2023-11-3
QQ
 楼主| 发表于 2024-10-16 16:39:16 | 显示全部楼层
大张 发表于 2024-10-16 14:565 N7 |$ M* K1 s6 Q+ a, G
语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~!
+ z! W. k0 e( A9 i. f
帖子里面有复制功能
商业服务端 登录器 网站 出售
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则


Archiver|小黑屋|EGameol

GMT+8, 2026-1-1 13:45 , Processed in 0.085158 second(s), 23 queries .

Powered by Discuz! X3.5

Copyright © 2001-2020, Tencent Cloud.

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