数据库清档SQL语句

admin

1. 
   
2. 
   
3. use account;
   9 N+ y$ A6 \( s9 R, N
4. DELETE FROM C_IP_BAN;
   , Z( F9 H& a, a% D% l5 }
5. DELETE FROM C_IP_PERMIT;
   
6. DELETE FROM C_IP_PWD;
   8 P+ k$ @$ ^& R: o: C0 A: p
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   8 u4 \6 r. A* M' U. K
8. DELETE FROM C_SEQUENCE;
   ; y" W5 f5 @0 T
9. DELETE FROM CP_USER_PROFILE;
   
10. DELETE FROM MB_USR_IP;
    - Z9 |8 A& X' @8 h
11. DELETE FROM MB_USR_PUN;
    
12. DELETE FROM Tbl_user;
    
13. DELETE FROM USER_CONNLOG_KEY;
    
14. DELETE FROM USER_PROFILE;
    
15. GO
    ; B* F: M/ H' l9 H3 U* Q
16. use billing;
    
17. DELETE FROM bl_error_log;
    ) ^  }/ }" i- G% o5 Q3 |0 |
18. DELETE FROM c_sequence;
    
19. DELETE FROM dba_online_daily;
    
20. DELETE FROM dba_online_daily_notok;
    ; b( @6 l2 R' W. J. @
21. DELETE FROM Tbl_KeepId;
    ( |& p: o2 p& ~
22. DELETE FROM user_account;
    . l# y' r8 C! _2 F' M0 W- r6 ^
23. DELETE FROM user_account;
    0 i2 d# I6 [" y) b8 B) u6 X$ R8 P
24. DELETE FROM user_charge_log;
    
25. DELETE FROM user_everyday_use_info;
    
26. DELETE FROM user_give_log;
    . }. M. P( p4 D
27. DELETE FROM user_use_log;
    , @2 Z5 C' \' ?6 f0 `  n
28. DELETE FROM user_use_log_bk;
    : Q8 q' i! B3 n3 b
29. GO
    % G9 D. [0 w0 k; [5 C/ q. n+ s
30. use cash;
    
31. DELETE FROM bl_error_log;
    
32. DELETE FROM Tbl_Cash_zj;
    ) I5 F3 Y! L" ~" }1 Y
33. DELETE FROM user_cash;
    ) I/ l: L! T+ e0 J! e
34. DELETE FROM user_charge_log;
    8 e: ]6 l% A$ c. w/ X
35. DELETE FROM user_use_log;
    : _, ~1 o2 x0 I! P- |
36. GO
    ) ~7 E2 s, @( _$ [' o9 e1 X
37. use character;
    
38. DELETE FROM C_EVENT_ITEM_OP
    
39. DELETE FROM c_restword;
    ! C" E( X$ z1 {* `
40. DELETE FROM char_connlog;
    
41. DELETE FROM CHAR_CONNLOG_KEY;
    + |3 q/ F0 B. \, C" y
42. DELETE FROM DEL_USER_CHAR_LIST;
      w0 m2 x. h0 b( ^% l
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    $ u9 v1 S. F9 h1 ?4 c- k# y, j1 c
44. DELETE FROM GM_ITEM_MST;
    ; Z8 T! g7 `  F) L& v5 [
45. DELETE FROM GUILD_CHAR_INFO;
    
46. DELETE FROM GUILD_INFO
    
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    
48. DELETE FROM GUILD_INFO_SECEDE;
    6 J% c# `5 C/ L7 T* u( v
49. DELETE FROM GUILD_PEERAGE
    % r6 i( M3 o3 ~1 x) e* u6 w2 M% P3 X
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    
51. DELETE FROM MSSNGR_CHAR_LIST;
    & h! }( [" ]9 k4 J( y0 b8 }
52. DELETE FROM SIEGE_INFO;
    2 H0 S8 Q  U' u, i
53. DELETE FROM SIEGE_RESULT_LOG;
    
54. DELETE FROM user_bag
    ( e1 r% C8 t+ ^+ j4 J
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    
56. DELETE FROM user_bag_copy;
    ( Z5 O4 a+ w$ i  w# F4 |0 E1 X
57. DELETE FROM user_bag_secede;
    
58. DELETE FROM user_character
    0 |! v  M, o$ w  {- H
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    
60. DELETE FROM user_character_secede;
    , N! M; e( q0 ]! \" {. p
61. DELETE FROM USER_POSTBOX;
    
62. DELETE FROM USER_POSTBOX_SECEDE;
    . Q0 n9 H7 M; o* N( G/ \( c
63. DELETE FROM User_Quest_Doing;
    & l7 p% H  u% j* R, W/ J- w
64. DELETE FROM user_quest_doing_secede;
    * g* f( X, l3 b% B
65. DELETE FROM User_Quest_Done;
    $ Q4 ?" ]1 V" ]. l4 C, @: [
66. DELETE FROM user_quest_done_secede;
    ( R& J3 @% Q$ F2 D
67. DELETE FROM user_skill
    
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    3 x* q" P9 ]! q
69. DELETE FROM user_skill_secede
    
70. DELETE FROM user_slot
    
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    
72. DELETE FROM user_storage;
    
73. DELETE FROM user_storage_copy;
    
74. DELETE FROM USER_STORE;
    1 w) l! K6 b( l" l# w; o
75. DELETE FROM USER_STORE_copy;
    
76. DELETE FROM USER_STORE_SECEDE;
    - G$ Y3 c# O' w( J
77. DELETE FROM user_suit
    
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    
79. DELETE FROM user_suit_copy;
    % p- D) P( @6 Z' c0 b1 |/ H( B* e
80. DELETE FROM user_suit_secede;
    
81. GO

复制代码

, B8 o" h. S9 R& {& v6 e
) i* t2 R& G2 \' V" R% B9 d

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~！

admin

大张 发表于 2024-10-16 14:56
, R3 }0 `5 E2 P$ n. o9 C语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~！

; f( |- B: e3 _8 \6 X帖子里面有复制功能