数据库清档SQL语句

admin

1. 
   $ j, g! G% |# \8 M- O
2. 
   
3. use account;
   
4. DELETE FROM C_IP_BAN;
   5 w9 j' H& Y% a$ ]: ?. r" B  t
5. DELETE FROM C_IP_PERMIT;
   
6. DELETE FROM C_IP_PWD;
   2 d) k  ^2 x* F) z$ h9 A
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   
8. DELETE FROM C_SEQUENCE;
   5 y) ], \3 {% f0 U+ G* z' c9 W0 v" l
9. DELETE FROM CP_USER_PROFILE;
   
10. DELETE FROM MB_USR_IP;
    
11. DELETE FROM MB_USR_PUN;
    5 E: M6 a9 Z- f, t0 h4 h
12. DELETE FROM Tbl_user;
    
13. DELETE FROM USER_CONNLOG_KEY;
    ( _: ]' [( v1 ?. E8 U2 ~. \, `) M( E, X
14. DELETE FROM USER_PROFILE;
    ( A8 z( B, z* e, E( R, \; L) e
15. GO
    & e0 I: T0 e$ T) [) u4 X+ U1 X5 v
16. use billing;
    
17. DELETE FROM bl_error_log;
    
18. DELETE FROM c_sequence;
    
19. DELETE FROM dba_online_daily;
    ( I) ]+ D( s2 w5 J, L% ]3 p* ?
20. DELETE FROM dba_online_daily_notok;
    # n) r- X: y1 h7 Y
21. DELETE FROM Tbl_KeepId;
    ! [, i9 i) `: e; |* b' w8 z8 Y9 L
22. DELETE FROM user_account;
    
23. DELETE FROM user_account;
    . K0 M, q/ H" H; }9 W1 `! d
24. DELETE FROM user_charge_log;
    , K: {' Z2 T( ~6 i
25. DELETE FROM user_everyday_use_info;
    2 c% y) T8 z- p
26. DELETE FROM user_give_log;
    
27. DELETE FROM user_use_log;
    " d4 D+ U8 G7 ^5 ~$ e+ a
28. DELETE FROM user_use_log_bk;
    2 w' |$ L' G: s3 C9 ^  k
29. GO
    ) X/ |. d1 \% V# x
30. use cash;
    4 k4 u) f: C( D/ o8 L
31. DELETE FROM bl_error_log;
    4 B! Z5 H" U! }' ?' ^+ R9 l
32. DELETE FROM Tbl_Cash_zj;
    
33. DELETE FROM user_cash;
      H& _1 D# l6 C: i1 Z  F4 F
34. DELETE FROM user_charge_log;
    
35. DELETE FROM user_use_log;
    
36. GO
    ) ^& `8 ^( T! x# b; Z1 a7 r
37. use character;
    
38. DELETE FROM C_EVENT_ITEM_OP
    
39. DELETE FROM c_restword;
    5 c- n& m+ |/ w% O/ a/ J  G1 r
40. DELETE FROM char_connlog;
    ) ^1 `& R$ Y7 t, v* c
41. DELETE FROM CHAR_CONNLOG_KEY;
    
42. DELETE FROM DEL_USER_CHAR_LIST;
      B& s3 _0 I3 I" }/ N' c. L
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    ( ^0 e, Z( a& V* `; {2 r
44. DELETE FROM GM_ITEM_MST;
    
45. DELETE FROM GUILD_CHAR_INFO;
    
46. DELETE FROM GUILD_INFO
    
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    8 V5 z  C) O7 i5 z
48. DELETE FROM GUILD_INFO_SECEDE;
    
49. DELETE FROM GUILD_PEERAGE
    + f! P$ q" G! y. I
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    5 e; Z+ L, M: s3 R( ~9 c& d1 r7 k
51. DELETE FROM MSSNGR_CHAR_LIST;
    ' B$ e) M8 w1 |6 h
52. DELETE FROM SIEGE_INFO;
    
53. DELETE FROM SIEGE_RESULT_LOG;
    
54. DELETE FROM user_bag
    2 D" V# H8 H7 z% r# o
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    7 T" Z& \/ y: S( w# I
56. DELETE FROM user_bag_copy;
    0 T7 ?8 y. x+ c/ s. {$ y4 ]
57. DELETE FROM user_bag_secede;
    
58. DELETE FROM user_character
    4 b& y) Q  S  O8 y6 c
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    
60. DELETE FROM user_character_secede;
    $ ^4 z" s" u  O0 L7 c) L; f6 ?  n! A1 b
61. DELETE FROM USER_POSTBOX;
    
62. DELETE FROM USER_POSTBOX_SECEDE;
    
63. DELETE FROM User_Quest_Doing;
    
64. DELETE FROM user_quest_doing_secede;
    * }4 h" z+ {$ H$ {. [6 t
65. DELETE FROM User_Quest_Done;
    
66. DELETE FROM user_quest_done_secede;
    ! [) l# b& Y; s3 W' b/ c$ e
67. DELETE FROM user_skill
    $ B) E$ X( _: s: i# k
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    % Y' k  K- a" L! I, [9 z; F, ]: E6 p
69. DELETE FROM user_skill_secede
    4 d# I( J  C/ _% K$ w* n
70. DELETE FROM user_slot
    9 H' q# {* j& x: J! {' f  q
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    
72. DELETE FROM user_storage;
    / B6 y$ O) T( V3 `/ B& M/ P1 V4 y
73. DELETE FROM user_storage_copy;
    
74. DELETE FROM USER_STORE;
    : G" M# G, A6 ^0 ^, C
75. DELETE FROM USER_STORE_copy;
    8 U2 X- B  G$ Y' c& q
76. DELETE FROM USER_STORE_SECEDE;
    ! S0 A3 h& S: I  r! |
77. DELETE FROM user_suit
    6 i4 X! P/ M" K0 X
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    
79. DELETE FROM user_suit_copy;
    
80. DELETE FROM user_suit_secede;
    ' q* _- M) m, _" ]
81. GO

复制代码

$ j6 @2 [* x. ~/ k

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

大张 发表于 2024-10-16 14:56
- u  Y$ ?3 @* y: q; ]语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~！

帖子里面有复制功能