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

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

[复制链接]

164

主题

416

回帖

7820

积分

管理员

积分
7820
金钱
2282
贡献
4958
注册时间
2023-11-3
QQ
发表于 2024-1-28 20:00:01 | 显示全部楼层 |阅读模式
  1. # q  X4 ]+ K5 f
  2.   b3 H& d/ `0 w0 e0 z+ d
  3. use account;7 @, q" Z- u  Z5 |4 Z; M4 I" t+ u
  4. DELETE FROM C_IP_BAN;
    : w' e1 {* _: u, }/ y
  5. DELETE FROM C_IP_PERMIT;
    / D* q  J* |, `
  6. DELETE FROM C_IP_PWD;- ?: }( I% \! A) V- N
  7. DELETE FROM C_LOGINIPBLOCK_LOG;
    * C% Q# |+ a2 Z' Z- l4 r
  8. DELETE FROM C_SEQUENCE;
    ! d5 O% J, c5 J2 P
  9. DELETE FROM CP_USER_PROFILE;
    ; N3 d0 K! j, B
  10. DELETE FROM MB_USR_IP;
    . `: e3 X$ ^- c& r/ e# V
  11. DELETE FROM MB_USR_PUN;
    0 n1 \, I8 D8 ^- u0 a
  12. DELETE FROM Tbl_user;
    , i9 g. l) c. o4 U& O. S
  13. DELETE FROM USER_CONNLOG_KEY;* L6 y* z" s' x6 x* Y3 `" q- T0 W4 d. m
  14. DELETE FROM USER_PROFILE;8 L  m% w6 V6 G1 v% c8 s
  15. GO+ y% g8 L, c/ ~
  16. use billing;
      k, R% o) s! x8 Y
  17. DELETE FROM bl_error_log;
    1 O4 i$ B0 o: \! ^$ T
  18. DELETE FROM c_sequence;
    0 \/ W+ q& k* n
  19. DELETE FROM dba_online_daily;$ j4 S0 s1 s2 o* U) C
  20. DELETE FROM dba_online_daily_notok;7 X1 y# Q  f4 y$ ]7 t+ ?2 w/ }% I  J
  21. DELETE FROM Tbl_KeepId;
    6 \" O" D1 u- }) A
  22. DELETE FROM user_account;
    ! `8 Z. P0 Z4 h: P
  23. DELETE FROM user_account;
    5 R0 e' g9 q7 x1 I
  24. DELETE FROM user_charge_log;2 G, ^2 [* W) `! {
  25. DELETE FROM user_everyday_use_info;6 X6 m  H% g* i5 ], d
  26. DELETE FROM user_give_log;6 N; C8 D# e# a! U
  27. DELETE FROM user_use_log;
    $ y% E. d" S+ q7 A! ?' d9 K- |
  28. DELETE FROM user_use_log_bk;4 g6 o; ^1 |3 q
  29. GO) }, P2 q8 r$ S5 q4 t8 ^6 ?  Z. ]
  30. use cash;
    ! E" `; j5 y& I* [: t
  31. DELETE FROM bl_error_log;. p2 P, q3 n8 u+ R! U0 U% _% @0 W
  32. DELETE FROM Tbl_Cash_zj;# B. ]. F: L+ o+ C
  33. DELETE FROM user_cash;
    0 O2 L% Z7 F: @( u6 Z+ ^/ w
  34. DELETE FROM user_charge_log;
    ) [. f: A9 _$ p& |" u2 ]; K# K  S
  35. DELETE FROM user_use_log;
    9 ?. ^7 M- O/ \  c4 F! B
  36. GO
    6 x( U2 {# O$ s4 g2 J/ Z
  37. use character;# w# J2 G" C4 k& _, B# g9 m. ?
  38. DELETE FROM C_EVENT_ITEM_OP5 R3 j4 L. C  C8 i
  39. DELETE FROM c_restword;
    % Q% C6 H6 S# k
  40. DELETE FROM char_connlog;' B7 s# C3 f7 V( E/ k
  41. DELETE FROM CHAR_CONNLOG_KEY;! l2 W6 `/ t, e; N  s+ T
  42. DELETE FROM DEL_USER_CHAR_LIST;
    * y9 \6 d4 q/ p& V% w
  43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;/ p+ O6 H& E- v, M) H& v. u6 d
  44. DELETE FROM GM_ITEM_MST;
    # H+ h4 O+ M/ h* a
  45. DELETE FROM GUILD_CHAR_INFO;
    % \; q( w5 L4 Q
  46. DELETE FROM GUILD_INFO
    * U! T! k  F( \' o
  47. WHERE guild_code NOT LIKE 'MASTERCODE';
    1 k, [. f2 h$ M9 |# Q4 c
  48. DELETE FROM GUILD_INFO_SECEDE;  }6 |2 ?8 N) r/ V5 G3 u1 Y
  49. DELETE FROM GUILD_PEERAGE9 [/ j5 f5 ]# }5 \
  50. WHERE guild_code NOT LIKE 'MASTERCODE';) `# R- u, [; V) X+ u, i! W
  51. DELETE FROM MSSNGR_CHAR_LIST;
    * V; {2 j6 @8 O& v- v, c/ h
  52. DELETE FROM SIEGE_INFO;9 |- B+ K# a8 {! Y4 c# L$ M, [
  53. DELETE FROM SIEGE_RESULT_LOG;
    % [' P) U* ^' k' M
  54. DELETE FROM user_bag0 h( b! Q+ k4 I1 S
  55. WHERE character_no NOT LIKE 'DEKARON_000001';# A- {3 i9 A, R/ q
  56. DELETE FROM user_bag_copy;' n- ?' e' a% G) `0 t$ p& E0 U
  57. DELETE FROM user_bag_secede;0 K$ Y3 Y6 m# h/ i8 d
  58. DELETE FROM user_character
      h4 `) k, g0 ?% h+ r! f- a
  59. WHERE character_no NOT LIKE 'DEKARON_000001';7 ]# l. [: e8 ^. y! B) f
  60. DELETE FROM user_character_secede;
    6 p5 Z5 G! X) R- l; R; ^
  61. DELETE FROM USER_POSTBOX;& i- Y# A$ `4 }0 ?0 L
  62. DELETE FROM USER_POSTBOX_SECEDE;
    / |, {9 U9 y( y
  63. DELETE FROM User_Quest_Doing;
    : |4 L* W6 w, H- }5 u& g
  64. DELETE FROM user_quest_doing_secede;
    3 I- M8 O/ ?0 S; u, ?4 K  d
  65. DELETE FROM User_Quest_Done;- T9 W3 d  g9 n9 F) K/ K" l
  66. DELETE FROM user_quest_done_secede;
    ) e' E5 n. p! f/ u) u- C
  67. DELETE FROM user_skill" p2 a6 y. Y6 V; l% \# \& {
  68. WHERE character_no NOT LIKE 'DEKARON_000001';; v8 ]4 v4 q% R
  69. DELETE FROM user_skill_secede
    ) v, O8 p% C1 z
  70. DELETE FROM user_slot9 E) Y5 ~2 g0 Q3 U, v/ K
  71. WHERE character_no NOT LIKE 'DEKARON_000001';
    " y2 A( u6 g5 _& Q( W
  72. DELETE FROM user_storage;
    : j( i4 T2 W8 o" x+ P$ K& v
  73. DELETE FROM user_storage_copy;$ Y1 b6 ~/ |3 K5 z- y6 M7 @
  74. DELETE FROM USER_STORE;/ [1 o0 }2 E& J; t5 X! f/ w
  75. DELETE FROM USER_STORE_copy;
    0 ^$ |3 ?$ ?( h
  76. DELETE FROM USER_STORE_SECEDE;
    $ }3 U' i  ^# H3 L3 Q8 |
  77. DELETE FROM user_suit  g6 @  ^- c) L( F: }* Z
  78. WHERE character_no NOT LIKE 'DEKARON_000001';
    / K; c* @* c. o" E5 V
  79. DELETE FROM user_suit_copy;
    3 C' Y; k6 c+ N- z
  80. DELETE FROM user_suit_secede;9 @8 M2 K, R3 v
  81. GO
复制代码

$ _; n6 n' t  T7 H+ _
3 d2 E  z/ k7 x7 P/ \+ [0 T6 p
商业服务端 登录器 网站 出售

16

主题

262

回帖

1370

积分

金牌会员

积分
1370
金钱
993
贡献
94
注册时间
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

主题

70

回帖

9821

积分

论坛元老

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

164

主题

416

回帖

7820

积分

管理员

积分
7820
金钱
2282
贡献
4958
注册时间
2023-11-3
QQ
发表于 2024-10-16 16:39:16 | 显示全部楼层
大张 发表于 2024-10-16 14:56
$ y3 Y2 Z, ^4 R4 l' P语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~!

, P3 @$ p, f, A+ T3 k" N帖子里面有复制功能
商业服务端 登录器 网站 出售
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则


Archiver|小黑屋|EGameol

GMT+8, 2026-7-3 07:43 , Processed in 0.056413 second(s), 26 queries .

Powered by Discuz! X3.5

© 2001-2026 Discuz! Team.

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