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

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

[复制链接]

167

主题

431

回帖

8422

积分

管理员

积分
8422
金钱
2429
贡献
5395
注册时间
2023-11-3
QQ
发表于 2024-1-28 20:00:01 | 显示全部楼层 |阅读模式
  1. - t5 ]1 o, Y& S' [9 y
  2. 6 j6 h& P  O# I+ U, v: a
  3. use account;
    7 ~/ D* e5 n0 H
  4. DELETE FROM C_IP_BAN;) E$ C) f' [  X8 v
  5. DELETE FROM C_IP_PERMIT;
    ) `* R* B: ]! t) D; |  ]
  6. DELETE FROM C_IP_PWD;2 v* o6 d, l6 Z/ q3 N
  7. DELETE FROM C_LOGINIPBLOCK_LOG;8 V9 J" j6 d) ~  H3 ~1 C0 I
  8. DELETE FROM C_SEQUENCE;* U- e4 q+ r5 E% ~
  9. DELETE FROM CP_USER_PROFILE;7 d6 S! B9 r0 d, A8 E; k$ z
  10. DELETE FROM MB_USR_IP;3 P% Q1 O$ R6 S% {% T- X3 e- w
  11. DELETE FROM MB_USR_PUN;8 @0 d4 i, i% L
  12. DELETE FROM Tbl_user;
    0 S& _8 n; w, @9 B- T, u' o
  13. DELETE FROM USER_CONNLOG_KEY;
    ) I/ y) c5 k- \4 L  e! F
  14. DELETE FROM USER_PROFILE;2 W7 m5 I; L  `, h$ H' x2 `# m
  15. GO( s, a( \3 F4 U1 K. s
  16. use billing;
    1 x6 f' n: Q* Z2 R
  17. DELETE FROM bl_error_log;
    3 {! S  Q7 P( }7 j( s2 m1 N
  18. DELETE FROM c_sequence;3 e2 P$ {2 S; r, \: n1 n& [
  19. DELETE FROM dba_online_daily;/ u0 S2 n$ p* r0 ~, G) y6 k0 n
  20. DELETE FROM dba_online_daily_notok;0 r0 _. \8 R; {1 j. S; P' {
  21. DELETE FROM Tbl_KeepId;
    3 e' [1 u  Z5 u$ V0 l9 i
  22. DELETE FROM user_account;
    7 t! e& ^$ _* C7 w& t
  23. DELETE FROM user_account;) \- S) j7 W& V: g* c  H
  24. DELETE FROM user_charge_log;
    ' X# ]: u) F2 B; v; ?
  25. DELETE FROM user_everyday_use_info;
    * j2 c- N6 G9 }0 l
  26. DELETE FROM user_give_log;2 h$ r; n) M; T- w- A2 G% c+ X
  27. DELETE FROM user_use_log;: P% }+ ^! ^7 t4 k
  28. DELETE FROM user_use_log_bk;$ z( A' N5 ^3 |# B, a- i$ q! {
  29. GO: f; A# Z& O1 j4 |5 W$ B
  30. use cash;
    9 A. X1 ]6 c1 f2 A" p6 E3 D
  31. DELETE FROM bl_error_log;: b/ ], f! v+ V
  32. DELETE FROM Tbl_Cash_zj;
    ; C, K  i) u% e/ m) y, L3 `4 ]
  33. DELETE FROM user_cash;4 p0 E# D7 q$ Z
  34. DELETE FROM user_charge_log;
    + G- E5 D. R. T& V
  35. DELETE FROM user_use_log;
    & M% f; w/ Q! d2 d* Q
  36. GO
    4 ]" [4 Q4 ^0 T2 g7 e1 n1 ^
  37. use character;% o$ ?& Q9 L5 m3 U, ]
  38. DELETE FROM C_EVENT_ITEM_OP
    % S2 U. K& A8 L
  39. DELETE FROM c_restword;
    + E' n" ^3 @- b: r1 B
  40. DELETE FROM char_connlog;1 u: t( @1 K) E7 T! ?1 D, K; w
  41. DELETE FROM CHAR_CONNLOG_KEY;5 r( t% F8 _) v, H5 r% N4 P
  42. DELETE FROM DEL_USER_CHAR_LIST;7 m4 @' H# I' W* E* G, d
  43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;2 O/ h( p5 H0 T+ S! f6 r
  44. DELETE FROM GM_ITEM_MST;9 e& v% S6 f2 A% E
  45. DELETE FROM GUILD_CHAR_INFO;
    ; _9 @$ E# L4 S1 x  C& P' v) U
  46. DELETE FROM GUILD_INFO
    ; z1 x6 E8 R2 j& ~1 O
  47. WHERE guild_code NOT LIKE 'MASTERCODE';0 a8 `6 e% Z4 ~+ _
  48. DELETE FROM GUILD_INFO_SECEDE;
    $ ^" l9 e; v$ w% [! }: Q7 _5 G
  49. DELETE FROM GUILD_PEERAGE
    / H) _+ \5 U# ~9 k. p) k' k' N- t
  50. WHERE guild_code NOT LIKE 'MASTERCODE';
    3 y* A+ e+ a- l. ?1 I5 r9 M
  51. DELETE FROM MSSNGR_CHAR_LIST;/ B3 \* e5 I. H& ]2 O" l4 l! `
  52. DELETE FROM SIEGE_INFO;: c1 U+ o2 e* v0 f5 J# X8 S
  53. DELETE FROM SIEGE_RESULT_LOG;
    9 g, B2 Y1 t- o; z6 [
  54. DELETE FROM user_bag
    & v' ]0 [$ W4 C7 m- z, H
  55. WHERE character_no NOT LIKE 'DEKARON_000001';
    " d9 m! i* c) T6 E1 M
  56. DELETE FROM user_bag_copy;. F" v# N# z# G% m3 |7 z* {
  57. DELETE FROM user_bag_secede;
    # y, R0 A/ ?) K: o
  58. DELETE FROM user_character
    ! d+ I! P2 n& |) h
  59. WHERE character_no NOT LIKE 'DEKARON_000001';3 z8 u! D2 x# j5 L3 C
  60. DELETE FROM user_character_secede;+ D9 G( l, ^7 V& o
  61. DELETE FROM USER_POSTBOX;4 ]) Q, C+ c9 u: H
  62. DELETE FROM USER_POSTBOX_SECEDE;) [. b* h1 E+ l% I% n
  63. DELETE FROM User_Quest_Doing;5 P1 I& t* M, h6 X* `7 f5 K
  64. DELETE FROM user_quest_doing_secede;3 H$ Q' n9 l. H) z
  65. DELETE FROM User_Quest_Done;
    " w1 X1 ?, u; Y# o1 r- h9 A% a* s
  66. DELETE FROM user_quest_done_secede;
    " ?4 B  x- @6 r, y
  67. DELETE FROM user_skill7 |& X3 Y. |( v2 Q: E
  68. WHERE character_no NOT LIKE 'DEKARON_000001';# E! L" W. A! u# G& |
  69. DELETE FROM user_skill_secede4 x+ p+ B, q0 F
  70. DELETE FROM user_slot
    7 V2 ?9 M" D4 z! G
  71. WHERE character_no NOT LIKE 'DEKARON_000001';! s$ @+ f- H/ l5 Z  e
  72. DELETE FROM user_storage;$ G: v. t7 R5 k
  73. DELETE FROM user_storage_copy;
    ' E7 M- {! Q+ h
  74. DELETE FROM USER_STORE;% ]! Z& r4 O/ D) I0 X
  75. DELETE FROM USER_STORE_copy;
    , v# y7 r" d7 x& S7 E
  76. DELETE FROM USER_STORE_SECEDE;
    % ?5 w; {1 B) j5 ~
  77. DELETE FROM user_suit
    9 h% o; t' v/ h* |& Y4 X
  78. WHERE character_no NOT LIKE 'DEKARON_000001';: _! W, g% R, Q, A  H) o
  79. DELETE FROM user_suit_copy;
    1 L* _+ ~, V2 y1 q
  80. DELETE FROM user_suit_secede;, o% \) \& M1 y$ B; h) Z: X
  81. GO
复制代码
: k$ G  d, a3 D5 `: B/ Y. s
6 e7 E, I3 z+ x* H! @! ]
商业服务端 登录器 网站 出售

16

主题

270

回帖

1605

积分

金牌会员

积分
1605
金钱
1161
贡献
153
注册时间
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

主题

72

回帖

1万

积分

论坛元老

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

167

主题

431

回帖

8422

积分

管理员

积分
8422
金钱
2429
贡献
5395
注册时间
2023-11-3
QQ
发表于 2024-10-16 16:39:16 | 显示全部楼层
大张 发表于 2024-10-16 14:56
0 q# M  G" E% D; ^! s语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~!

- U& {  A  o* _' D" O- A- i" a帖子里面有复制功能
商业服务端 登录器 网站 出售
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则


Archiver|小黑屋|EGameol

GMT+8, 2026-11-16 08:20 , Processed in 0.052812 second(s), 26 queries .

Powered by Discuz! X3.5

© 2001-2026 Discuz! Team.

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