数据库清档SQL语句

admin

1. 
   
2. 
   * }' h# E  }9 y/ k/ n
3. use account;
   * A5 h5 R" L( F1 D" V: y
4. DELETE FROM C_IP_BAN;
   3 f8 j8 y. P3 f0 i7 Q4 n
5. DELETE FROM C_IP_PERMIT;
   
6. DELETE FROM C_IP_PWD;
   " i0 \% \3 b) Z& j9 Z% z, J8 X, t2 V
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   
8. DELETE FROM C_SEQUENCE;
   5 x9 k0 K/ X; r( f
9. DELETE FROM CP_USER_PROFILE;
     r+ }; G; v( V* k
10. DELETE FROM MB_USR_IP;
    $ P6 F+ @" D- o! U" L1 Z: Z9 @
11. DELETE FROM MB_USR_PUN;
      x- S5 Q4 m9 p( M
12. DELETE FROM Tbl_user;
    4 C. ?; t  _8 ^$ T
13. DELETE FROM USER_CONNLOG_KEY;
    
14. DELETE FROM USER_PROFILE;
    
15. GO
    0 U3 d4 [& B6 y' \1 B) U1 s. ]
16. use billing;
    # g5 b( K; D' p$ _; s$ S5 V# o
17. DELETE FROM bl_error_log;
    
18. DELETE FROM c_sequence;
    
19. DELETE FROM dba_online_daily;
    
20. DELETE FROM dba_online_daily_notok;
    & t: E5 Y; Q- z  ~8 E- _* z
21. DELETE FROM Tbl_KeepId;
    ' c' ]9 O2 R& w; C; T
22. DELETE FROM user_account;
    
23. DELETE FROM user_account;
    7 G4 R2 H: z  h( e$ c# H
24. DELETE FROM user_charge_log;
    3 b1 a9 Q7 k* z6 E
25. DELETE FROM user_everyday_use_info;
    
26. DELETE FROM user_give_log;
    * }# ?  T6 e7 ^% {
27. DELETE FROM user_use_log;
    
28. DELETE FROM user_use_log_bk;
    
29. GO
    : r) z) `( C% f3 @" V0 U# g
30. use cash;
    
31. DELETE FROM bl_error_log;
    # U! |- I; O$ R) A1 F# \
32. DELETE FROM Tbl_Cash_zj;
    
33. DELETE FROM user_cash;
    # B. _, U9 p- S' b/ k- C* u
34. DELETE FROM user_charge_log;
    
35. DELETE FROM user_use_log;
    # z$ v8 \  }; I9 V& k, H1 T/ S
36. GO
    
37. use character;
    
38. DELETE FROM C_EVENT_ITEM_OP
    
39. DELETE FROM c_restword;
    7 c: f$ D( a2 a. F& K' |; S
40. DELETE FROM char_connlog;
    
41. DELETE FROM CHAR_CONNLOG_KEY;
    * `0 D4 {) W: S  n3 g
42. DELETE FROM DEL_USER_CHAR_LIST;
    
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    3 h. ]% f% p  s& `9 U) C$ A3 M
44. DELETE FROM GM_ITEM_MST;
    
45. DELETE FROM GUILD_CHAR_INFO;
    + W- T9 b$ j  I8 b
46. DELETE FROM GUILD_INFO
    
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    * |8 G1 ]) V/ Q8 E6 _6 b6 B
48. DELETE FROM GUILD_INFO_SECEDE;
    , d( P" F0 d" r- w6 R! d! G
49. DELETE FROM GUILD_PEERAGE
    
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    
51. DELETE FROM MSSNGR_CHAR_LIST;
    ( K; \) A; q6 O' p* V% A3 }& S
52. DELETE FROM SIEGE_INFO;
    5 k9 D7 B% c) X/ g- }1 N  M
53. DELETE FROM SIEGE_RESULT_LOG;
    
54. DELETE FROM user_bag
    
55. WHERE character_no NOT LIKE 'DEKARON_000001';
      U8 D( P" G. b- b) V
56. DELETE FROM user_bag_copy;
    5 m( Q1 t. e! y4 f4 V* r7 D
57. DELETE FROM user_bag_secede;
    
58. DELETE FROM user_character
    
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    + x% j( ?) E) a& Z( t" y. b! P
60. DELETE FROM user_character_secede;
    ; o2 B) M* T8 H) x& \# X
61. DELETE FROM USER_POSTBOX;
    : c) g& W; P7 F( p+ {* d& @
62. DELETE FROM USER_POSTBOX_SECEDE;
    
63. DELETE FROM User_Quest_Doing;
    ! `$ Z2 M5 r; S
64. DELETE FROM user_quest_doing_secede;
    / b3 Q& c2 r" t) X! ~
65. DELETE FROM User_Quest_Done;
    
66. DELETE FROM user_quest_done_secede;
    . U8 S$ p. w$ o4 ^, S: y4 v
67. DELETE FROM user_skill
    5 @+ a2 \( O. _+ k4 j( l9 d( s' I
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    % ~0 {( W4 Y# P  ~7 U; K  W
69. DELETE FROM user_skill_secede
    * [, @5 n  H8 x! B8 E. ~
70. DELETE FROM user_slot
    
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    6 o. w6 ~" V5 r3 t7 P+ Z: }! i
72. DELETE FROM user_storage;
    
73. DELETE FROM user_storage_copy;
    % y# R' p3 ^% z+ q, v
74. DELETE FROM USER_STORE;
    ) W- C- c$ Z4 l9 F+ u0 V2 f- Y4 I9 H5 J
75. DELETE FROM USER_STORE_copy;
    
76. DELETE FROM USER_STORE_SECEDE;
    
77. DELETE FROM user_suit
    ! P% S8 ], E: @9 k: W
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    
79. DELETE FROM user_suit_copy;
    
80. DELETE FROM user_suit_secede;
    - C* k6 M: U0 R& I# {! ?0 r8 e/ l
81. GO

复制代码

+ g& a2 r2 h6 \) A3 @- N

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

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

7 I! Q2 X% \9 W帖子里面有复制功能