数据库清档SQL语句

admin

1. 
   
2. 
   
3. use account;
   + o1 ~: F. V, }8 ?0 `
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;
   - F- \# k) K" a; F# z  L6 y6 Q) M
9. DELETE FROM CP_USER_PROFILE;
   
10. DELETE FROM MB_USR_IP;
    
11. DELETE FROM MB_USR_PUN;
    
12. DELETE FROM Tbl_user;
    ' l* k: S, ]& O* l4 d. f, A7 ~2 B0 L, @. X/ k
13. DELETE FROM USER_CONNLOG_KEY;
    3 Z8 f% ]' O2 b& G( M
14. DELETE FROM USER_PROFILE;
    ( w: Y5 Z2 v/ X7 J5 c5 n! u
15. GO
    
16. use billing;
    
17. DELETE FROM bl_error_log;
    ; s2 j5 W$ m$ K! ?/ h% R
18. DELETE FROM c_sequence;
    
19. DELETE FROM dba_online_daily;
    ( J$ g. b2 x& U' t% ]
20. DELETE FROM dba_online_daily_notok;
    
21. DELETE FROM Tbl_KeepId;
    
22. DELETE FROM user_account;
    3 n1 [% s2 j6 |1 S2 z
23. DELETE FROM user_account;
    
24. DELETE FROM user_charge_log;
    ( a) l) o* A7 R4 p
25. DELETE FROM user_everyday_use_info;
    
26. DELETE FROM user_give_log;
    
27. DELETE FROM user_use_log;
    
28. DELETE FROM user_use_log_bk;
    * U6 Y' ?% t1 f, U# \
29. GO
    . p3 F- `0 i: u  h# a5 F
30. use cash;
    $ i  X$ N; K# o8 s. Q  e  F- D4 o
31. DELETE FROM bl_error_log;
    
32. DELETE FROM Tbl_Cash_zj;
    - s; d; G4 b1 j  @8 r. O
33. DELETE FROM user_cash;
    % h1 }9 n3 V1 m7 ^+ E4 V
34. DELETE FROM user_charge_log;
    
35. DELETE FROM user_use_log;
    # w9 K4 v% \3 C# M+ ~
36. GO
    
37. use character;
    * y# \3 |3 P: O5 o* \; w# Q
38. DELETE FROM C_EVENT_ITEM_OP
    2 A7 {7 b0 X; I3 O# ]$ ^
39. DELETE FROM c_restword;
    ! b, {) L# A0 X# ~! ]4 S
40. DELETE FROM char_connlog;
    
41. DELETE FROM CHAR_CONNLOG_KEY;
    
42. DELETE FROM DEL_USER_CHAR_LIST;
    
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    
44. DELETE FROM GM_ITEM_MST;
      g" ]2 S0 z" G1 X
45. DELETE FROM GUILD_CHAR_INFO;
    
46. DELETE FROM GUILD_INFO
    
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    ( I2 k0 Z+ _' ?% ?& y/ n4 I/ d
48. DELETE FROM GUILD_INFO_SECEDE;
    
49. DELETE FROM GUILD_PEERAGE
    ) c8 ~/ r" _* {
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    
51. DELETE FROM MSSNGR_CHAR_LIST;
    ! V2 p, g1 f, O- C
52. DELETE FROM SIEGE_INFO;
    
53. DELETE FROM SIEGE_RESULT_LOG;
    
54. DELETE FROM user_bag
    
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    
56. DELETE FROM user_bag_copy;
    % g! o8 M0 c3 N& H, H
57. DELETE FROM user_bag_secede;
    ) M1 T. E, Y! \+ d7 S, d4 ?
58. DELETE FROM user_character
    
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    ' \( r# W' ~0 h& r- q+ e
60. DELETE FROM user_character_secede;
    ) U1 p2 H: \: p" l3 q5 T- G+ l
61. DELETE FROM USER_POSTBOX;
    
62. DELETE FROM USER_POSTBOX_SECEDE;
    
63. DELETE FROM User_Quest_Doing;
    
64. DELETE FROM user_quest_doing_secede;
    * H+ z* D( j4 Q. `) x( h! V8 x
65. DELETE FROM User_Quest_Done;
    : p1 b6 H9 H: p# d
66. DELETE FROM user_quest_done_secede;
    
67. DELETE FROM user_skill
    " l# m* M% X$ U  @  c+ q8 d% d
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    
69. DELETE FROM user_skill_secede
    & @9 K7 i9 I+ s- G4 P
70. DELETE FROM user_slot
    ! I1 H0 H3 b) Y" Q  s0 n3 |& r
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    $ D3 p5 L/ u/ X
72. DELETE FROM user_storage;
    
73. DELETE FROM user_storage_copy;
    
74. DELETE FROM USER_STORE;
    % u& r/ }( V& r) T! S' S
75. DELETE FROM USER_STORE_copy;
    0 |& B! s6 u8 _
76. DELETE FROM USER_STORE_SECEDE;
    # h: L% b7 ]+ a( p
77. DELETE FROM user_suit
    ) a' O0 N1 {) _! H6 G3 K! s
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    , U7 ^5 R0 ^" N  o) _1 l- s  N
79. DELETE FROM user_suit_copy;
    
80. DELETE FROM user_suit_secede;
    
81. GO

复制代码

* K4 {" Y0 k# c  b- j3 S, G) H
# U. w4 o  z+ z. R! ~! s; L

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

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

帖子里面有复制功能