数据库清档SQL语句

admin

1. 
   ; w" F0 C2 l) _. S
2. 
   
3. use account;
   
4. DELETE FROM C_IP_BAN;
   & ~" s4 ?1 ]/ _7 o1 ]* g
5. DELETE FROM C_IP_PERMIT;
   
6. DELETE FROM C_IP_PWD;
   1 j4 Q! t# h1 l; k# t4 p
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   
8. DELETE FROM C_SEQUENCE;
   
9. DELETE FROM CP_USER_PROFILE;
   4 c! [/ r; D3 f- x. t' p
10. DELETE FROM MB_USR_IP;
    5 r7 s7 ~1 c, ?7 g
11. DELETE FROM MB_USR_PUN;
    " k8 `  @" s3 j$ y/ N
12. DELETE FROM Tbl_user;
    ( h, c& m1 h( P
13. DELETE FROM USER_CONNLOG_KEY;
    + h/ f. L$ C. d7 L) S
14. DELETE FROM USER_PROFILE;
    " H: a- Z) F* D, q
15. GO
    2 M) ~+ y5 {$ l
16. use billing;
    3 P4 o( V$ a3 _2 a: ]
17. DELETE FROM bl_error_log;
    ! f: T; H9 _# b( {
18. DELETE FROM c_sequence;
    : `- P) ^0 e% q2 ?
19. DELETE FROM dba_online_daily;
    0 n5 Y" o! j1 h/ y) P* U
20. DELETE FROM dba_online_daily_notok;
    ( s% }5 a5 J* n  s$ C- N
21. DELETE FROM Tbl_KeepId;
    7 p- O! u: t; B3 B  V) m
22. DELETE FROM user_account;
    4 }' }5 F7 |' v+ |" N
23. DELETE FROM user_account;
    3 Z; q+ f* g3 X! H! L' ~
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;
      u: ?" @$ ^8 x* x
28. DELETE FROM user_use_log_bk;
    ) Q7 [+ H: \$ P  T$ R
29. GO
    
30. use cash;
    
31. DELETE FROM bl_error_log;
    
32. DELETE FROM Tbl_Cash_zj;
    9 b+ ~! l. `2 `- f6 X+ ~
33. DELETE FROM user_cash;
    ! @  S! l4 M  y+ S5 g9 z
34. DELETE FROM user_charge_log;
    
35. DELETE FROM user_use_log;
    
36. GO
    
37. use character;
    
38. DELETE FROM C_EVENT_ITEM_OP
    . q5 g1 K/ a, k! r+ g2 C. o) x4 `+ b
39. DELETE FROM c_restword;
    % ~% m1 o* W, w+ a% }
40. DELETE FROM char_connlog;
    ! V2 {/ v) G* T0 F6 w6 a' Z+ r
41. DELETE FROM CHAR_CONNLOG_KEY;
    
42. DELETE FROM DEL_USER_CHAR_LIST;
    
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    ) o+ k$ H5 J' S. ^& \& i. a
44. DELETE FROM GM_ITEM_MST;
    
45. DELETE FROM GUILD_CHAR_INFO;
    : i. L; C7 m( j
46. DELETE FROM GUILD_INFO
    " h$ X) s+ f: n
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    4 `/ S1 V- F7 q4 y8 d
48. DELETE FROM GUILD_INFO_SECEDE;
    % ?) o# ]9 b: |+ ?% m9 U% H; K
49. DELETE FROM GUILD_PEERAGE
    . h; N3 p8 n# M" ]
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    ' l" g8 M+ R* P) w7 o
51. DELETE FROM MSSNGR_CHAR_LIST;
    
52. DELETE FROM SIEGE_INFO;
    
53. DELETE FROM SIEGE_RESULT_LOG;
    ! O8 L% c1 o- n. O0 _
54. DELETE FROM user_bag
    
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    & m" {1 c3 h4 `8 l! I. G: ]
56. DELETE FROM user_bag_copy;
    - n. L8 h1 p: w2 c0 U/ _& c/ x; R
57. DELETE FROM user_bag_secede;
    ! V) p4 T/ k; i: t6 r; C( H7 |3 @7 l
58. DELETE FROM user_character
    
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    
60. DELETE FROM user_character_secede;
    
61. DELETE FROM USER_POSTBOX;
    ' M! ^# c7 O" g, v+ W; v( O$ L
62. DELETE FROM USER_POSTBOX_SECEDE;
    
63. DELETE FROM User_Quest_Doing;
    
64. DELETE FROM user_quest_doing_secede;
    
65. DELETE FROM User_Quest_Done;
    $ i( _, q3 q! L- o6 i4 n! q1 k
66. DELETE FROM user_quest_done_secede;
    
67. DELETE FROM user_skill
    
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    : h# b+ t" L$ s* N; s/ t* Y
69. DELETE FROM user_skill_secede
    
70. DELETE FROM user_slot
    ' ?# r* N( q% j  }- ?6 Y
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    # d& q! N; g: c0 m( X2 Z5 x
72. DELETE FROM user_storage;
    # w* R/ H# c/ g; S
73. DELETE FROM user_storage_copy;
    + ^0 t' W) s- W; s
74. DELETE FROM USER_STORE;
    % e: u- M2 d  C
75. DELETE FROM USER_STORE_copy;
    
76. DELETE FROM USER_STORE_SECEDE;
    
77. DELETE FROM user_suit
    2 m' n4 i# p7 s  F4 m+ @3 `- r$ f# X
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    ( R5 _5 L0 W0 g
79. DELETE FROM user_suit_copy;
    6 M0 l" V! M. r3 q% ]2 {0 P
80. DELETE FROM user_suit_secede;
    7 Y3 P; Y9 ^) e# E: q
81. GO

复制代码

6 n0 c" Z* L: ^' t( G8 a6 I2 v! D
" J% g/ Q: w) M' _* s3 c

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

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

帖子里面有复制功能