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

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

[复制链接]

167

主题

431

回帖

8422

积分

管理员

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

  1. 2 T9 T2 [# c- D9 _1 [9 a  w

  2. ( Y7 o5 m6 f+ u6 O1 x
  3. use account;2 r( P, m' s6 z2 }, x& t+ K
  4. DELETE FROM C_IP_BAN;
    ' g* H) r# p0 R' t- y* s
  5. DELETE FROM C_IP_PERMIT;  T8 S( M- {; w! s0 X
  6. DELETE FROM C_IP_PWD;, N/ g& j( I/ Y7 i! e1 Z: P/ K' n
  7. DELETE FROM C_LOGINIPBLOCK_LOG;" b& d# k, y4 X0 A# w# T5 n$ _
  8. DELETE FROM C_SEQUENCE;
    . Y) j* i$ u$ n- R; U! t
  9. DELETE FROM CP_USER_PROFILE;
    9 o+ c) i2 n. ^" D& A) Q- u
  10. DELETE FROM MB_USR_IP;. q; M0 O8 A( X, U1 `6 S! ]5 S' n
  11. DELETE FROM MB_USR_PUN;- c+ f! E3 j  u
  12. DELETE FROM Tbl_user;
    , h7 }8 P- Q2 Q" p, H4 Y
  13. DELETE FROM USER_CONNLOG_KEY;
    # Y# G& w4 }7 e8 v" e4 j) ~
  14. DELETE FROM USER_PROFILE;- v4 z1 O9 J9 I/ k- L
  15. GO
    5 \2 o1 M% U# m$ U
  16. use billing;! G( p' o6 y1 q
  17. DELETE FROM bl_error_log;! t- ^- w6 Z- L$ r  J8 f- F
  18. DELETE FROM c_sequence;  H( f7 C# a' G) B. ^; V
  19. DELETE FROM dba_online_daily;
    ' b1 ?* \8 x: P3 L' T4 \) H4 `
  20. DELETE FROM dba_online_daily_notok;% C6 [. d  R* |5 C
  21. DELETE FROM Tbl_KeepId;/ U. ]! u% r- P! N0 t6 _
  22. DELETE FROM user_account;
    . g# h- s& ^) @: ]+ U6 q# A
  23. DELETE FROM user_account;
    1 |# G$ k' A: G1 M! f
  24. DELETE FROM user_charge_log;
    ( V  A" z8 q1 I$ R
  25. DELETE FROM user_everyday_use_info;; O1 Q1 c! t5 K/ T: d2 x( {5 c
  26. DELETE FROM user_give_log;
    , j, N" o  a. S  u3 I- t
  27. DELETE FROM user_use_log;
    : M. M5 G, i6 t/ ]
  28. DELETE FROM user_use_log_bk;$ X* }4 p. D) |! `
  29. GO
    * k/ k7 F% M7 f8 W' `. ^
  30. use cash;1 |* \+ |! X6 f( M" x
  31. DELETE FROM bl_error_log;
    * F+ X1 ~0 t: U; C* A
  32. DELETE FROM Tbl_Cash_zj;
    , J- h3 P3 O( w3 T7 Q# B$ L
  33. DELETE FROM user_cash;' X2 {1 ~1 u$ f
  34. DELETE FROM user_charge_log;! U. b% v5 z; b& m5 P" S
  35. DELETE FROM user_use_log;3 i: i, [/ L# F' @& e
  36. GO
    : \2 T9 u; r, m  @
  37. use character;
    " ]7 @  B" v& [7 n  w
  38. DELETE FROM C_EVENT_ITEM_OP5 V* M0 d2 R; _1 N7 E6 b- F
  39. DELETE FROM c_restword;: W$ O: O. F$ L
  40. DELETE FROM char_connlog;
    + u+ E. G  J) J6 x% x& Q* Z7 X
  41. DELETE FROM CHAR_CONNLOG_KEY;
    # O* t; W8 q  d9 X. q2 k
  42. DELETE FROM DEL_USER_CHAR_LIST;
    * Q! Q7 F( J0 g9 B3 ^! w9 L
  43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    . M& [# N( g1 o3 C$ E% F" Q8 t
  44. DELETE FROM GM_ITEM_MST;
    ' X0 _; d& ?- S) b5 h1 j8 e; v
  45. DELETE FROM GUILD_CHAR_INFO;
    ) Q  E9 n$ ?: g+ h/ s
  46. DELETE FROM GUILD_INFO- O" |% k$ F5 S" e
  47. WHERE guild_code NOT LIKE 'MASTERCODE';
    . F+ m) L( d7 l( O! B/ z
  48. DELETE FROM GUILD_INFO_SECEDE;
    ) Y- b* o! N) U, g
  49. DELETE FROM GUILD_PEERAGE
    4 O. l5 _4 O# Y- H7 G
  50. WHERE guild_code NOT LIKE 'MASTERCODE';
    4 n) V/ p4 G! i# C- J
  51. DELETE FROM MSSNGR_CHAR_LIST;
    ; V5 c$ y/ `  C; [/ ~5 X/ R/ b, {
  52. DELETE FROM SIEGE_INFO;9 D/ s3 ?6 v% C+ {5 G( I4 D
  53. DELETE FROM SIEGE_RESULT_LOG;8 i: ?0 z$ R6 b9 ?+ i8 k
  54. DELETE FROM user_bag
    ( v. V3 E+ e' j
  55. WHERE character_no NOT LIKE 'DEKARON_000001';
    9 O1 n. H# S, G6 W* Z$ a6 z& r
  56. DELETE FROM user_bag_copy;
    ; S# `  E. Z+ `- E; @6 C. T6 ?
  57. DELETE FROM user_bag_secede;8 N& p3 n$ F2 L4 f% R
  58. DELETE FROM user_character9 l+ o" {4 b9 f
  59. WHERE character_no NOT LIKE 'DEKARON_000001';
    $ c2 H! ?7 t  _. R: N% `: |5 ^% d
  60. DELETE FROM user_character_secede;& f9 @" c/ r$ D. y3 I
  61. DELETE FROM USER_POSTBOX;
      a# Q. H# U/ `; [) L! C
  62. DELETE FROM USER_POSTBOX_SECEDE;
    8 Q; T, |0 J  H
  63. DELETE FROM User_Quest_Doing;( {- ~( _4 K$ x
  64. DELETE FROM user_quest_doing_secede;
    ( g; ~+ v0 a: I6 b+ Z! I
  65. DELETE FROM User_Quest_Done;
    7 v3 s- d& F9 ~2 t5 c. R3 F
  66. DELETE FROM user_quest_done_secede;3 |$ H& I& L) |3 v6 M
  67. DELETE FROM user_skill# W' Y$ T$ |8 e! J/ q( t
  68. WHERE character_no NOT LIKE 'DEKARON_000001';
    ; H2 m5 n. l! P( m) N
  69. DELETE FROM user_skill_secede" ~* d% d2 H: d' e5 x5 }5 Q! h, @- b
  70. DELETE FROM user_slot& i, x+ n: I( m! f- i
  71. WHERE character_no NOT LIKE 'DEKARON_000001';
    # @  u8 G( ~$ }. h; I$ ]0 ]/ i7 y
  72. DELETE FROM user_storage;
    / U+ ~+ {! q( t
  73. DELETE FROM user_storage_copy;& C0 |- V- O4 q( M8 f  @( a& W
  74. DELETE FROM USER_STORE;
    / L/ q' p' M3 U+ Q8 X
  75. DELETE FROM USER_STORE_copy;
    % @8 d6 }' `/ `
  76. DELETE FROM USER_STORE_SECEDE;4 Y: p- M( Z2 T! ?  J
  77. DELETE FROM user_suit
    , m6 w# P# Y" E; h( f" R3 ]
  78. WHERE character_no NOT LIKE 'DEKARON_000001';
    * |! W7 r3 l" \+ h  i. T. M
  79. DELETE FROM user_suit_copy;% |+ B' j* O' @/ N% c
  80. DELETE FROM user_suit_secede;; x& y* X- c2 t" U" Y5 C8 |
  81. GO
复制代码

/ v: C, v) e# }& @
* b6 r% n, A% D/ M( L
商业服务端 登录器 网站 出售

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
+ O; G* _3 R# v( s语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~!
8 a4 f& W6 z- G/ k
帖子里面有复制功能
商业服务端 登录器 网站 出售
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则


Archiver|小黑屋|EGameol

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

Powered by Discuz! X3.5

© 2001-2026 Discuz! Team.

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