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

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

[复制链接]

153

主题

334

回帖

5703

积分

管理员

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

  1. ! k, J$ H1 I/ b- ~3 b8 J( o- |

  2. # K* b! z* P( d* m
  3. use account;
    / f1 o1 [2 Q# {* {4 s1 r" C
  4. DELETE FROM C_IP_BAN;
    7 w) ?7 o- S$ C' |# n
  5. DELETE FROM C_IP_PERMIT;. k8 p1 c/ \" u$ _6 M; s* U
  6. DELETE FROM C_IP_PWD;0 d  z$ V* x  j  P
  7. DELETE FROM C_LOGINIPBLOCK_LOG;7 v9 _" }0 o6 X' c
  8. DELETE FROM C_SEQUENCE;1 ^: |* L4 H$ \% P
  9. DELETE FROM CP_USER_PROFILE;0 R7 q/ J  w, |0 ~/ @6 s( q- ?
  10. DELETE FROM MB_USR_IP;
    6 E. Z, h" e0 l: y. V
  11. DELETE FROM MB_USR_PUN;
    4 t* t5 w  L& a1 K) i
  12. DELETE FROM Tbl_user;
    " n. _1 h+ i' \# f' B% A* A
  13. DELETE FROM USER_CONNLOG_KEY;
    2 j: l3 T, r# C* P# u$ u) S' ^
  14. DELETE FROM USER_PROFILE;; k2 H2 m1 Q/ h& F3 |( H
  15. GO1 k0 c  V- j& w) O
  16. use billing;+ \+ e2 A) ~, X/ ?! i. w, s4 K
  17. DELETE FROM bl_error_log;
    ) z7 s: [& D4 i
  18. DELETE FROM c_sequence;
    * R; a. B* @/ F* ^. r8 l
  19. DELETE FROM dba_online_daily;- o" I1 o3 ^  t% N
  20. DELETE FROM dba_online_daily_notok;
    % O" @- ]" d' C9 Z7 D
  21. DELETE FROM Tbl_KeepId;
    ) _/ C$ R* F+ m: ]* g1 J9 \( `
  22. DELETE FROM user_account;
    * S+ x4 J+ H9 H0 @' D
  23. DELETE FROM user_account;+ D. X' d8 F$ E4 `
  24. DELETE FROM user_charge_log;
    & L3 j3 g% G2 D
  25. DELETE FROM user_everyday_use_info;
    + D( u1 Y$ W9 B
  26. DELETE FROM user_give_log;
    4 }& [3 G1 x4 \) m5 \9 K
  27. DELETE FROM user_use_log;& y' X/ v- ^1 Q! q* Y
  28. DELETE FROM user_use_log_bk;
    - v8 S. j9 e9 ]) G( E" q0 I. p
  29. GO
    + h" U% ]" K; O6 L
  30. use cash;
    0 |6 I  D( A* n# y# R
  31. DELETE FROM bl_error_log;
    1 c4 i  M" S  B
  32. DELETE FROM Tbl_Cash_zj;
    ( |  G8 A: G4 Z/ r
  33. DELETE FROM user_cash;
    . l' X7 V' N, ~( c5 ?: M) q
  34. DELETE FROM user_charge_log;9 K! T' c; W, d  s
  35. DELETE FROM user_use_log;: q( z: a& H. L1 l
  36. GO7 Y) R0 x9 E9 G
  37. use character;
    5 X# {8 e, q5 _. E9 F, l5 I7 X! X
  38. DELETE FROM C_EVENT_ITEM_OP
    7 R) W/ n4 f$ W, q0 S" F7 W% h( A
  39. DELETE FROM c_restword;; m5 c, r. `9 U! G& b+ G# q$ N. a
  40. DELETE FROM char_connlog;
    + w5 y+ y- @8 U" _
  41. DELETE FROM CHAR_CONNLOG_KEY;
    2 }2 [  _: e5 l8 k. G
  42. DELETE FROM DEL_USER_CHAR_LIST;) ?/ k  c; I, K
  43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;2 q+ u6 ]8 _' i- d* W: u" q
  44. DELETE FROM GM_ITEM_MST;
    + X' r# a5 C9 O  s5 i. C$ n" C
  45. DELETE FROM GUILD_CHAR_INFO;
    2 h4 y5 ~( a( F# M, S/ V( Z
  46. DELETE FROM GUILD_INFO% Y: d% j- Y# b  U) l* K) Y
  47. WHERE guild_code NOT LIKE 'MASTERCODE';
    ' c( D. d" P) m' U* d
  48. DELETE FROM GUILD_INFO_SECEDE;
    4 ^3 l1 m/ A: O, A/ O% c' i( y
  49. DELETE FROM GUILD_PEERAGE: ?' S. c1 K7 _7 y7 U
  50. WHERE guild_code NOT LIKE 'MASTERCODE';
    $ ^: V0 B8 v& N" f' q& L
  51. DELETE FROM MSSNGR_CHAR_LIST;
    % E3 R6 V! b. r2 ?5 z# C) v! L4 q
  52. DELETE FROM SIEGE_INFO;
    % G- {$ c, I- d" m, V6 Q, T& j
  53. DELETE FROM SIEGE_RESULT_LOG;
    2 J, J7 N  @+ n$ T3 ^, q
  54. DELETE FROM user_bag+ {9 v8 T3 c+ G  [, M* F3 ^1 W! H" X
  55. WHERE character_no NOT LIKE 'DEKARON_000001';
    : D- `( ]  o# p- }  f! }' q
  56. DELETE FROM user_bag_copy;, q+ q/ @. u, i3 O( q& [: \) @( E$ E
  57. DELETE FROM user_bag_secede;3 K; a9 q7 ^% @: l1 D9 u1 U6 ^
  58. DELETE FROM user_character
    9 \0 u2 y: \; v2 s( `. L# d# R7 j3 B! i
  59. WHERE character_no NOT LIKE 'DEKARON_000001';
    & ?) F  d: o5 f" u
  60. DELETE FROM user_character_secede;) m$ N. x. K: b
  61. DELETE FROM USER_POSTBOX;
    " \' T. k1 O+ Q
  62. DELETE FROM USER_POSTBOX_SECEDE;
    + ?7 j, g& s5 K, @1 u2 y
  63. DELETE FROM User_Quest_Doing;
    % w- D' c3 d  O. U9 m. r" `0 i
  64. DELETE FROM user_quest_doing_secede;
    / g' Q9 Q3 X- F. e
  65. DELETE FROM User_Quest_Done;
    4 M6 t0 j$ C( p/ {. l$ F
  66. DELETE FROM user_quest_done_secede;; D. N; r8 h8 }  a! f
  67. DELETE FROM user_skill; D1 @: t; [, Q4 \% `( Z
  68. WHERE character_no NOT LIKE 'DEKARON_000001';+ H* l9 B% ~9 s% o/ m7 z! v
  69. DELETE FROM user_skill_secede6 b- w# k7 C7 [
  70. DELETE FROM user_slot
    0 A: `$ B1 n" [& \
  71. WHERE character_no NOT LIKE 'DEKARON_000001';
      u: m+ Z% {$ m( d  `
  72. DELETE FROM user_storage;: g/ |, s# |* r! K! I# V& V
  73. DELETE FROM user_storage_copy;: G5 w  x4 X5 S0 B; l/ _1 I
  74. DELETE FROM USER_STORE;
    4 @* Q& p* K8 g. b* C) g* W, d
  75. DELETE FROM USER_STORE_copy;4 X( O# @! M2 y+ y
  76. DELETE FROM USER_STORE_SECEDE;
    $ Y" E$ }! Z( z( e
  77. DELETE FROM user_suit- u, K1 h+ V- b
  78. WHERE character_no NOT LIKE 'DEKARON_000001';, F5 F: a/ n0 K- ^4 H0 E3 T
  79. DELETE FROM user_suit_copy;' N7 ^6 b* {. X1 B! c7 L
  80. DELETE FROM user_suit_secede;
    ( V2 y8 g+ Y% Z4 B3 T( ~; G) T
  81. GO
复制代码
' Y0 ^4 Q* k$ z0 Z6 J! z) }

6 f: r4 m9 s' h% f
商业服务端 登录器 网站 出售

13

主题

250

回帖

1220

积分

金牌会员

积分
1220
金钱
779
贡献
173
注册时间
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

主题

67

回帖

5682

积分

论坛元老

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

153

主题

334

回帖

5703

积分

管理员

积分
5703
金钱
1800
贡献
3416
注册时间
2023-11-3
QQ
 楼主| 发表于 2024-10-16 16:39:16 | 显示全部楼层
大张 发表于 2024-10-16 14:56
- L0 e! S. e4 m1 K3 {语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~!

# f5 ?: y4 b1 z0 I7 V帖子里面有复制功能
商业服务端 登录器 网站 出售
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则


Archiver|小黑屋|EGameol

GMT+8, 2025-11-22 10:36 , Processed in 0.052271 second(s), 23 queries .

Powered by Discuz! X3.5

Copyright © 2001-2020, Tencent Cloud.

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