数据库清档SQL语句

admin

1. 
   3 s! o; M+ U! r3 y2 U* e7 O+ d) J
2. 
   
3. use account;
   . s2 y  M0 {9 X. b" e
4. DELETE FROM C_IP_BAN;
   & O4 f3 M' J1 b
5. DELETE FROM C_IP_PERMIT;
   % X: {7 G/ }2 Q/ b1 k  U- U& i
6. DELETE FROM C_IP_PWD;
   
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   + l; M  U! T9 J! B
8. DELETE FROM C_SEQUENCE;
   6 m; {1 F6 I$ n
9. DELETE FROM CP_USER_PROFILE;
   . d% @. P$ U8 X# l
10. DELETE FROM MB_USR_IP;
    5 p6 K% ~: ]' t
11. DELETE FROM MB_USR_PUN;
    
12. DELETE FROM Tbl_user;
    
13. DELETE FROM USER_CONNLOG_KEY;
    
14. DELETE FROM USER_PROFILE;
    
15. GO
    - |( k. Z, S) Y+ Q' l! s
16. use billing;
    
17. DELETE FROM bl_error_log;
    $ G( F( l) n: m* v7 }3 s: i
18. DELETE FROM c_sequence;
    
19. DELETE FROM dba_online_daily;
    4 D. S. ]6 i- A, O, O9 X& Q% {2 p
20. DELETE FROM dba_online_daily_notok;
    
21. DELETE FROM Tbl_KeepId;
    9 ], y1 p8 z  n$ u5 ^
22. DELETE FROM user_account;
    
23. DELETE FROM user_account;
    
24. DELETE FROM user_charge_log;
    8 ]* t2 X! o7 P) h
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;
    8 N* V' R) J, S$ T
29. GO
    0 U0 U; D; O# }; A% Y
30. use cash;
    ! H. n9 ?3 {4 \1 z+ t6 U# y
31. DELETE FROM bl_error_log;
    2 l* k( z( U- [0 [# k0 x
32. DELETE FROM Tbl_Cash_zj;
    ' \) ~# f, s) `# @+ ~0 y2 k
33. DELETE FROM user_cash;
    
34. DELETE FROM user_charge_log;
    % T4 T8 n4 V. g. K0 ~* [
35. DELETE FROM user_use_log;
    
36. GO
    4 ~) B) }( y4 Y
37. use character;
    + v% D0 f9 n) A5 L0 p
38. DELETE FROM C_EVENT_ITEM_OP
    + S% @  O6 C, X$ Y& C
39. DELETE FROM c_restword;
    
40. DELETE FROM char_connlog;
    
41. DELETE FROM CHAR_CONNLOG_KEY;
    ' I1 V  E8 J- o( q* R$ j
42. DELETE FROM DEL_USER_CHAR_LIST;
    & U) H5 n5 {! U/ |
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
      c$ r  _" A- }# D
44. DELETE FROM GM_ITEM_MST;
    
45. DELETE FROM GUILD_CHAR_INFO;
    
46. DELETE FROM GUILD_INFO
    % H0 E* A; x+ `/ ~+ F* W5 T+ k$ M
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    
48. DELETE FROM GUILD_INFO_SECEDE;
    
49. DELETE FROM GUILD_PEERAGE
    ; y: K8 \  I/ ]; q/ E* J2 G" ^
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    
51. DELETE FROM MSSNGR_CHAR_LIST;
    , R. j# V- K; f! Q: {0 M  u
52. DELETE FROM SIEGE_INFO;
    4 r# J( [7 S8 _0 W; `0 K' |* A
53. DELETE FROM SIEGE_RESULT_LOG;
      k* r1 b" ~: i- N8 ?, [  Z; R( W- ^
54. DELETE FROM user_bag
    
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    " t, e- _! s0 r! ^$ v
56. DELETE FROM user_bag_copy;
    
57. DELETE FROM user_bag_secede;
    
58. DELETE FROM user_character
    
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    % |9 Z) z% O- i( Q3 r+ @
60. DELETE FROM user_character_secede;
    2 H5 \# f' i! 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;
    + J2 S4 s, _# Y" v
65. DELETE FROM User_Quest_Done;
    , {  h, K9 j3 y: v! W( v
66. DELETE FROM user_quest_done_secede;
    
67. DELETE FROM user_skill
    / ~1 A5 f. |6 b1 e; C! S: v
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    
69. DELETE FROM user_skill_secede
    : }4 {" S1 Q# P
70. DELETE FROM user_slot
    % Y4 O- F) A2 R1 r. j( L6 `
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    1 M/ c: e* ^3 Q* ?+ F
72. DELETE FROM user_storage;
    3 V$ J0 Z2 S$ O0 L
73. DELETE FROM user_storage_copy;
    
74. DELETE FROM USER_STORE;
    " s1 k. }3 M6 B( C: t+ p
75. DELETE FROM USER_STORE_copy;
    " J1 a9 V% I7 E2 z
76. DELETE FROM USER_STORE_SECEDE;
    
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;
    
81. GO

复制代码

( G: T) p7 i& u2 |5 x. l6 ?

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

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

帖子里面有复制功能