数据库清档SQL语句

admin

1. 
   - z2 ?: L- ~* _3 F5 X2 \% ]
2. 
   9 V+ G- m  w+ w3 N6 R& @0 [
3. use account;
   : O& b4 ?% t) |# o9 N5 f! a
4. DELETE FROM C_IP_BAN;
   - t5 x, I' O' E0 f% H
5. DELETE FROM C_IP_PERMIT;
   
6. DELETE FROM C_IP_PWD;
   
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   2 M/ o+ R8 {5 z( {9 O& v  g
8. DELETE FROM C_SEQUENCE;
   
9. DELETE FROM CP_USER_PROFILE;
   
10. DELETE FROM MB_USR_IP;
    . j. }) y1 d5 ]2 ]) Q0 ?& n8 g  y0 n
11. DELETE FROM MB_USR_PUN;
    
12. DELETE FROM Tbl_user;
    9 F5 y- N3 i( q( Q
13. DELETE FROM USER_CONNLOG_KEY;
    8 B3 N3 m+ o8 l0 I" I
14. DELETE FROM USER_PROFILE;
    ! v, h, d" g2 D
15. GO
    
16. use billing;
    ' s9 I0 \0 x8 S. l* E7 q% B" D) z
17. DELETE FROM bl_error_log;
    
18. DELETE FROM c_sequence;
    ( y" H2 m$ q1 }$ J
19. DELETE FROM dba_online_daily;
    + a9 E& d$ }" V! D2 |, Q- y
20. DELETE FROM dba_online_daily_notok;
    : |5 B) }. d* [3 u5 H
21. DELETE FROM Tbl_KeepId;
    
22. DELETE FROM user_account;
    
23. DELETE FROM user_account;
    
24. DELETE FROM user_charge_log;
    
25. DELETE FROM user_everyday_use_info;
    - |; J& s. L9 D: G7 D, }9 L3 x. t- ?
26. DELETE FROM user_give_log;
    
27. DELETE FROM user_use_log;
    7 [. D" P3 O6 B. n9 L
28. DELETE FROM user_use_log_bk;
    8 B7 h2 W7 k, r5 ?0 A
29. GO
    + J. q9 T1 N0 J, ?
30. use cash;
    
31. DELETE FROM bl_error_log;
    " m+ K; G6 f  m  L  Q8 j2 f$ _
32. DELETE FROM Tbl_Cash_zj;
    
33. DELETE FROM user_cash;
    
34. DELETE FROM user_charge_log;
    
35. DELETE FROM user_use_log;
    ' p! t8 e  F; i8 _& S1 E* o# m( S) F
36. GO
    
37. use character;
    : G; A; R) I; v( x& t) W
38. DELETE FROM C_EVENT_ITEM_OP
    
39. DELETE FROM c_restword;
    
40. DELETE FROM char_connlog;
    - [% j5 f) v) |6 M
41. DELETE FROM CHAR_CONNLOG_KEY;
    ; p$ U4 v/ t; E, {# V' v( t
42. DELETE FROM DEL_USER_CHAR_LIST;
    
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    + R4 w$ D4 B5 }/ _
44. DELETE FROM GM_ITEM_MST;
    ) v9 ^. U* G4 d$ b# H- A& N
45. DELETE FROM GUILD_CHAR_INFO;
    1 i( E: o+ f5 w, u- H
46. DELETE FROM GUILD_INFO
    
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    
48. DELETE FROM GUILD_INFO_SECEDE;
    , @8 r! m. u4 h- D) B1 N: X
49. DELETE FROM GUILD_PEERAGE
    8 t! E7 a1 ]- f4 y- \
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    
51. DELETE FROM MSSNGR_CHAR_LIST;
    
52. DELETE FROM SIEGE_INFO;
    
53. DELETE FROM SIEGE_RESULT_LOG;
    # y5 L3 U) V& {% p9 R
54. DELETE FROM user_bag
    ' x5 u) @% n0 K1 d5 j5 F
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    
56. DELETE FROM user_bag_copy;
    
57. DELETE FROM user_bag_secede;
    % e  z8 p/ _* J/ f$ C
58. DELETE FROM user_character
    
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    ) F. ?, y- }1 Y
60. DELETE FROM user_character_secede;
    & y; R& k  h( V% K% D9 Q$ d
61. DELETE FROM USER_POSTBOX;
    ' w; @5 {4 e$ U! ?" W
62. DELETE FROM USER_POSTBOX_SECEDE;
    ! b7 I; s1 z( v, K4 u& I6 O
63. DELETE FROM User_Quest_Doing;
    
64. DELETE FROM user_quest_doing_secede;
    2 v" x! N1 c" j, o: Q) S9 Z
65. DELETE FROM User_Quest_Done;
    ' \  o2 T6 ?  y5 W" K
66. DELETE FROM user_quest_done_secede;
    
67. DELETE FROM user_skill
    
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    
69. DELETE FROM user_skill_secede
    
70. DELETE FROM user_slot
    
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    
72. DELETE FROM user_storage;
    1 _; u1 x$ g1 p
73. DELETE FROM user_storage_copy;
    
74. DELETE FROM USER_STORE;
    
75. DELETE FROM USER_STORE_copy;
    
76. DELETE FROM USER_STORE_SECEDE;
    ! o/ n% Z( x8 D3 d
77. DELETE FROM user_suit
    9 s# {- x& D8 L$ R* U
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    . d, E' j9 [7 u! {0 {5 g) S
79. DELETE FROM user_suit_copy;
    
80. DELETE FROM user_suit_secede;
    
81. GO

复制代码

' q3 U3 Y5 K% [9 Q

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

大张 发表于 2024-10-16 14:56
语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~！

帖子里面有复制功能