数据库清档SQL语句

admin

1. 
   
2. 
   
3. use account;
   + v. J' ]0 A7 b
4. DELETE FROM C_IP_BAN;
   : I; ~) P7 |8 }) Z2 T) u, H5 j; `: o
5. DELETE FROM C_IP_PERMIT;
   & Q7 _8 m8 ~7 ~* ?  Q
6. DELETE FROM C_IP_PWD;
   , P1 F% s$ s9 `. L3 Y9 u( t1 y" C
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   
8. DELETE FROM C_SEQUENCE;
   8 n( U+ C* G0 _/ Q1 H3 h" |
9. DELETE FROM CP_USER_PROFILE;
   $ |; Q* R7 U1 N5 K6 ?- A3 R
10. DELETE FROM MB_USR_IP;
    
11. DELETE FROM MB_USR_PUN;
    $ y+ g9 }8 a% u7 a9 R! Q/ |
12. DELETE FROM Tbl_user;
    , D. h' u  K$ a  T2 V6 d, Q* f- X
13. DELETE FROM USER_CONNLOG_KEY;
    / x2 L/ @/ G7 q+ b
14. DELETE FROM USER_PROFILE;
    5 X; z7 u* Y8 i- N/ C0 Z; w
15. GO
    6 q$ z$ O& E& Q+ H; b/ c& y; O! {
16. use billing;
    6 r: p8 P) w2 \" w5 N% V6 S) r; X
17. DELETE FROM bl_error_log;
    
18. DELETE FROM c_sequence;
    " n  `7 ?  w* [& A1 C% f
19. DELETE FROM dba_online_daily;
    ' I1 J. O/ s4 u9 i3 z: Q# D5 c
20. DELETE FROM dba_online_daily_notok;
    
21. DELETE FROM Tbl_KeepId;
    
22. DELETE FROM user_account;
    ( C( v  u$ O% q/ e
23. DELETE FROM user_account;
    0 Z. Z0 R; C# R5 Q" U8 E
24. DELETE FROM user_charge_log;
    ) @' ^. n2 k  S  }5 w1 @
25. DELETE FROM user_everyday_use_info;
    8 ^( N, K% Z: k! {8 e
26. DELETE FROM user_give_log;
    
27. DELETE FROM user_use_log;
    
28. DELETE FROM user_use_log_bk;
    8 A' i- e+ b- K$ Q; s
29. GO
    
30. use cash;
    
31. DELETE FROM bl_error_log;
    $ J6 n7 v" D+ V
32. DELETE FROM Tbl_Cash_zj;
    3 y2 f9 P/ z' B7 ^
33. DELETE FROM user_cash;
    
34. DELETE FROM user_charge_log;
    
35. DELETE FROM user_use_log;
    - c1 @7 R% W9 T0 ^7 V: L6 D
36. GO
    1 s- f% U+ J$ B. x9 c
37. use character;
    
38. DELETE FROM C_EVENT_ITEM_OP
    
39. DELETE FROM c_restword;
    - H( n( b0 R8 _: ?' z
40. DELETE FROM char_connlog;
    
41. DELETE FROM CHAR_CONNLOG_KEY;
    
42. DELETE FROM DEL_USER_CHAR_LIST;
    ; j* _! `! B0 v+ _
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    
44. DELETE FROM GM_ITEM_MST;
    
45. DELETE FROM GUILD_CHAR_INFO;
    
46. DELETE FROM GUILD_INFO
    9 P# M! p5 d* ]- _* ]0 E
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    
48. DELETE FROM GUILD_INFO_SECEDE;
    1 G2 W  }$ _6 u1 M; [: J
49. DELETE FROM GUILD_PEERAGE
    # t0 U7 g5 m: B* b- \  r
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    6 T; y1 s& I* M' l- P. E% J5 ?6 @# l2 C
51. DELETE FROM MSSNGR_CHAR_LIST;
    
52. DELETE FROM SIEGE_INFO;
    
53. DELETE FROM SIEGE_RESULT_LOG;
    ( I1 C; U& a9 X( ]/ U* T1 p) S
54. DELETE FROM user_bag
    
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    ' B) G' l0 F: n
56. DELETE FROM user_bag_copy;
    
57. DELETE FROM user_bag_secede;
    4 a! ]2 d/ @; L8 n9 D1 x9 h! R
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;
    4 p1 g2 T# `+ P: h
64. DELETE FROM user_quest_doing_secede;
    ! I  m1 U2 S; A
65. DELETE FROM User_Quest_Done;
    
66. DELETE FROM user_quest_done_secede;
      L8 D3 L! ^. G& K* n6 t
67. DELETE FROM user_skill
    
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    
69. DELETE FROM user_skill_secede
    % j& s1 S) W. Z/ z; i" t3 T
70. DELETE FROM user_slot
    4 O& s% }# m- c9 r# K
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    
72. DELETE FROM user_storage;
    ) w/ P5 O6 }' Y6 S
73. DELETE FROM user_storage_copy;
    
74. DELETE FROM USER_STORE;
    
75. DELETE FROM USER_STORE_copy;
    
76. DELETE FROM USER_STORE_SECEDE;
    - {5 Q8 u: V/ D% h
77. DELETE FROM user_suit
    
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    
79. DELETE FROM user_suit_copy;
    
80. DELETE FROM user_suit_secede;
    9 {& j' x! K2 I9 H* {# x4 K" ]
81. GO

复制代码

( v# c( H; m' F) P
- ^- k$ M4 ~8 {

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

大张 发表于 2024-10-16 14:56
2 j# B- A4 ^3 E# S语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~！

帖子里面有复制功能