数据库清档SQL语句

admin

1. 
   
2. 
   
3. use account;
   
4. DELETE FROM C_IP_BAN;
   ( [8 ~5 L5 w: h8 `; i
5. DELETE FROM C_IP_PERMIT;
   & Q7 s6 i" ~/ C& D( P% M" W$ ]6 f
6. DELETE FROM C_IP_PWD;
   : }- R1 c# P/ M6 i
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   0 |4 @, G3 f% k' q$ S0 T
8. DELETE FROM C_SEQUENCE;
   3 d9 x7 t+ y& V; m
9. DELETE FROM CP_USER_PROFILE;
   
10. DELETE FROM MB_USR_IP;
    - j0 c9 X6 a+ r, G* K5 @! {" D
11. DELETE FROM MB_USR_PUN;
    
12. DELETE FROM Tbl_user;
    
13. DELETE FROM USER_CONNLOG_KEY;
    
14. DELETE FROM USER_PROFILE;
    
15. GO
    1 T: C3 e' }4 T7 X! A9 V* ]
16. use billing;
    
17. DELETE FROM bl_error_log;
    
18. DELETE FROM c_sequence;
    
19. DELETE FROM dba_online_daily;
    % h4 n( f5 _$ c5 f; @& r
20. DELETE FROM dba_online_daily_notok;
    " ?3 w* K: K; s* z3 H
21. DELETE FROM Tbl_KeepId;
    
22. DELETE FROM user_account;
      [/ i* G0 r" ?" e, n
23. DELETE FROM user_account;
    ( n& V, T; \+ o( U
24. DELETE FROM user_charge_log;
    
25. DELETE FROM user_everyday_use_info;
    $ Y5 F' @/ g# s$ [- F1 Z; f
26. DELETE FROM user_give_log;
    
27. DELETE FROM user_use_log;
    2 o, ?. r" F  B' Q# ?% k, u/ G
28. DELETE FROM user_use_log_bk;
    ( h1 e$ L) q1 ~  U4 [
29. GO
    
30. use cash;
    
31. DELETE FROM bl_error_log;
    
32. DELETE FROM Tbl_Cash_zj;
    ) _9 ~+ n4 n% g* k; W
33. DELETE FROM user_cash;
    
34. DELETE FROM user_charge_log;
    , O- s1 Y3 }/ W- j0 L. S
35. DELETE FROM user_use_log;
    : t- B* g2 Q; |) u% }% f" \/ A$ O
36. GO
    
37. use character;
    
38. DELETE FROM C_EVENT_ITEM_OP
    
39. DELETE FROM c_restword;
    
40. DELETE FROM char_connlog;
    $ J* z  ^( U4 S) n0 ]% c3 x
41. DELETE FROM CHAR_CONNLOG_KEY;
    
42. DELETE FROM DEL_USER_CHAR_LIST;
    
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    / f6 i% ?  P! M% b% O, U0 D8 Q
44. DELETE FROM GM_ITEM_MST;
    % x3 p% A1 V+ [
45. DELETE FROM GUILD_CHAR_INFO;
    
46. DELETE FROM GUILD_INFO
    # Q! u& [) e( E' j+ `% `8 w
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    ' B2 f+ f" z$ E& x- x% n2 p, i2 c6 f8 c
48. DELETE FROM GUILD_INFO_SECEDE;
    
49. DELETE FROM GUILD_PEERAGE
    
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    . Q6 p& E% Z3 Q" X% Q7 Z( L
51. DELETE FROM MSSNGR_CHAR_LIST;
    
52. DELETE FROM SIEGE_INFO;
    
53. DELETE FROM SIEGE_RESULT_LOG;
    8 h7 V% C6 C! x4 C
54. DELETE FROM user_bag
    . t. p0 L1 }% D1 q" A, [) A
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    / F; x2 h8 }1 @
56. DELETE FROM user_bag_copy;
    3 J  B. R/ Z( {
57. DELETE FROM user_bag_secede;
    
58. DELETE FROM user_character
    
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    
60. DELETE FROM user_character_secede;
    
61. DELETE FROM USER_POSTBOX;
    
62. DELETE FROM USER_POSTBOX_SECEDE;
    
63. DELETE FROM User_Quest_Doing;
    
64. DELETE FROM user_quest_doing_secede;
    0 ~3 L, F) X' v  l$ ?
65. DELETE FROM User_Quest_Done;
    8 ?& j+ l$ L5 O0 I, ]& u/ T
66. DELETE FROM user_quest_done_secede;
    
67. DELETE FROM user_skill
    
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    ! ~& x) g3 P' i4 p3 r( g8 a; ^! K5 p+ h
69. DELETE FROM user_skill_secede
    7 D  \' a! v$ i- r. X$ A
70. DELETE FROM user_slot
    / E2 ~1 O/ Q; |5 s- Q5 e+ k
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    - p3 C9 o* A; P! l' Y9 x0 `
72. DELETE FROM user_storage;
    3 m. o9 j9 V9 T5 B) d# Q
73. DELETE FROM user_storage_copy;
    3 E7 X7 w8 M7 k, _
74. DELETE FROM USER_STORE;
    9 x2 H  T" \% h, g
75. DELETE FROM USER_STORE_copy;
    % }- \+ W; n4 J% p  _
76. DELETE FROM USER_STORE_SECEDE;
    
77. DELETE FROM user_suit
    6 V% I3 c3 D& L; l6 Z+ [6 U0 I
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    
79. DELETE FROM user_suit_copy;
    
80. DELETE FROM user_suit_secede;
    ; \& K* z& c, I7 D1 _8 g7 m
81. GO

复制代码

5 f9 `  X. z8 t6 k

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

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

- s2 F+ d" s' [+ J帖子里面有复制功能