数据库清档SQL语句

admin

1. 
   6 U) k) C7 V6 s0 Y# s/ j
2. 
   
3. use account;
   & J* u; E8 F' n" a: }
4. DELETE FROM C_IP_BAN;
   
5. DELETE FROM C_IP_PERMIT;
   
6. DELETE FROM C_IP_PWD;
   
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   
8. DELETE FROM C_SEQUENCE;
   % d& X; X% Q# v$ c
9. DELETE FROM CP_USER_PROFILE;
   6 c/ {/ ^9 g+ P5 R4 _
10. DELETE FROM MB_USR_IP;
    
11. DELETE FROM MB_USR_PUN;
    
12. DELETE FROM Tbl_user;
    . E5 ^* ~0 s2 _6 [# q* }+ c7 a5 R
13. DELETE FROM USER_CONNLOG_KEY;
    
14. DELETE FROM USER_PROFILE;
    7 e% r- a% m7 O+ ?1 F% g
15. GO
    
16. use billing;
    % @) F6 o# \5 k# @8 c
17. DELETE FROM bl_error_log;
    6 G( _! M( v" ]" z
18. DELETE FROM c_sequence;
    4 d% ?6 l! p1 h9 x5 x& w9 V
19. DELETE FROM dba_online_daily;
    6 q; j- q( T2 R4 d2 A# {
20. DELETE FROM dba_online_daily_notok;
    3 W2 {' z2 a( z: |/ [- |' r5 c
21. DELETE FROM Tbl_KeepId;
    $ t( |5 m* Z; K) z+ D
22. DELETE FROM user_account;
    
23. DELETE FROM user_account;
    ! N- F/ {& [- S: P
24. DELETE FROM user_charge_log;
    
25. DELETE FROM user_everyday_use_info;
    
26. DELETE FROM user_give_log;
    
27. DELETE FROM user_use_log;
    1 _6 P$ \9 M4 [' H; s; C
28. DELETE FROM user_use_log_bk;
    
29. GO
    4 X) |, e  f/ Q0 X' ~+ p. J% p# ?
30. use cash;
    
31. DELETE FROM bl_error_log;
    ; |' G7 J6 y8 D( f1 ]; f
32. DELETE FROM Tbl_Cash_zj;
    
33. DELETE FROM user_cash;
    
34. DELETE FROM user_charge_log;
    
35. DELETE FROM user_use_log;
    2 L& |0 p# r: s5 X
36. GO
    
37. use character;
    
38. DELETE FROM C_EVENT_ITEM_OP
    
39. DELETE FROM c_restword;
    
40. DELETE FROM char_connlog;
    ) ]4 Q7 _5 o: _) m9 G
41. DELETE FROM CHAR_CONNLOG_KEY;
    
42. DELETE FROM DEL_USER_CHAR_LIST;
    / Z) G. }4 m$ l! ?; f
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    4 z) P" {& U3 y9 K
44. DELETE FROM GM_ITEM_MST;
    
45. DELETE FROM GUILD_CHAR_INFO;
    
46. DELETE FROM GUILD_INFO
    1 e# i8 P5 D% f# q! K. U- O
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    ' f8 u( s' M% Y$ F
48. DELETE FROM GUILD_INFO_SECEDE;
    / O0 x- H3 _2 ~$ M3 |
49. DELETE FROM GUILD_PEERAGE
    5 q, y8 a' W: J7 O4 G
50. WHERE guild_code NOT LIKE 'MASTERCODE';
      v1 J: @, J6 W0 Y1 l# M- w
51. DELETE FROM MSSNGR_CHAR_LIST;
    0 C, c2 P- P9 x$ X3 e5 |) F
52. DELETE FROM SIEGE_INFO;
    # f3 R6 i6 `' E6 v- C5 T
53. DELETE FROM SIEGE_RESULT_LOG;
    # E3 w. C) s* K0 f, A
54. DELETE FROM user_bag
    + s. y! l' J. \' y$ D
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    1 p! K" u# K; ]. N% U  R3 D! E
56. DELETE FROM user_bag_copy;
    + E3 ?8 p7 R; J
57. DELETE FROM user_bag_secede;
    
58. DELETE FROM user_character
    # i5 R6 U( w7 Z' w* _( G- J
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    : S  U) ]2 |6 S: J/ p
60. DELETE FROM user_character_secede;
    5 k/ }1 Y# ?: r; a' U" m: c
61. DELETE FROM USER_POSTBOX;
    
62. DELETE FROM USER_POSTBOX_SECEDE;
      g3 ]4 m# l/ a: E
63. DELETE FROM User_Quest_Doing;
    
64. DELETE FROM user_quest_doing_secede;
    
65. DELETE FROM User_Quest_Done;
    
66. DELETE FROM user_quest_done_secede;
    
67. DELETE FROM user_skill
    
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    1 j% V. A9 z- G2 u
69. DELETE FROM user_skill_secede
    $ m6 n0 p# F/ H0 `2 Q# u' |7 S
70. DELETE FROM user_slot
    ) T$ B7 q  o9 W+ x' m+ q$ f2 P
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    9 E9 i% H8 Z% Q7 ?9 l/ F, L# s
72. DELETE FROM user_storage;
    
73. DELETE FROM user_storage_copy;
    
74. DELETE FROM USER_STORE;
    
75. DELETE FROM USER_STORE_copy;
    
76. DELETE FROM USER_STORE_SECEDE;
    / X8 ~" A- |0 s4 z+ P3 ?
77. DELETE FROM user_suit
    8 z4 S4 w0 @( j, |8 E) D
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    ' P' y" j9 n8 c9 ]1 L3 \+ C- I
79. DELETE FROM user_suit_copy;
    
80. DELETE FROM user_suit_secede;
    
81. GO

复制代码

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

大张 发表于 2024-10-16 14:56
& m+ I! e& C9 M语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~！

9 `3 D- O! T) P% l3 l4 }帖子里面有复制功能