数据库清档SQL语句

admin

1. 
   3 y  k' r0 s1 U, w& Q$ o
2. 
   * N& ^$ y) D6 a% a( \  [/ B& g( m4 `
3. use account;
   
4. DELETE FROM C_IP_BAN;
   0 y6 }% l6 a: J* L! {- n
5. DELETE FROM C_IP_PERMIT;
   
6. DELETE FROM C_IP_PWD;
   
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   
8. DELETE FROM C_SEQUENCE;
   
9. DELETE FROM CP_USER_PROFILE;
   
10. DELETE FROM MB_USR_IP;
    7 g4 W2 \9 `4 T' f
11. DELETE FROM MB_USR_PUN;
    
12. DELETE FROM Tbl_user;
    9 @8 K  v9 t+ Z9 k- Z
13. DELETE FROM USER_CONNLOG_KEY;
    ; M, Y% a# U; S" Y% v( s/ S
14. DELETE FROM USER_PROFILE;
    
15. GO
    / H9 h' \9 m) V, H4 b% _
16. use billing;
    " c; G- r2 Y8 A# W  q  ?$ Y
17. DELETE FROM bl_error_log;
    : i6 }6 g) ~( H% N/ P: a
18. DELETE FROM c_sequence;
    
19. DELETE FROM dba_online_daily;
    
20. DELETE FROM dba_online_daily_notok;
    , c7 q4 i3 E- s0 k- d$ K
21. DELETE FROM Tbl_KeepId;
    - \/ f( v( G! y8 z* ?1 N
22. DELETE FROM user_account;
    
23. DELETE FROM user_account;
    9 q" ]+ f) D7 O5 {3 k4 x. R1 y
24. DELETE FROM user_charge_log;
    " q2 V& W* y0 f$ p$ w; }
25. DELETE FROM user_everyday_use_info;
    : p8 c; b; o6 L9 ?# }8 e1 `
26. DELETE FROM user_give_log;
    
27. DELETE FROM user_use_log;
    8 i, g# `( ?8 m5 @5 U& u1 q3 c
28. DELETE FROM user_use_log_bk;
    $ K5 v$ q7 }( b  K/ A0 S$ H
29. GO
    
30. use cash;
    / A6 i: q/ j/ F' P5 m9 b3 `+ _* O
31. DELETE FROM bl_error_log;
    , t* N' N) A) m$ y4 m$ A
32. DELETE FROM Tbl_Cash_zj;
    
33. DELETE FROM user_cash;
    
34. DELETE FROM user_charge_log;
    ; ?, h; p7 k9 S( q3 y- j  O+ s, m  m
35. DELETE FROM user_use_log;
    
36. GO
    
37. use character;
    5 W2 g+ j1 L  `: `) X; n
38. DELETE FROM C_EVENT_ITEM_OP
    
39. DELETE FROM c_restword;
    
40. DELETE FROM char_connlog;
    
41. DELETE FROM CHAR_CONNLOG_KEY;
    & e% S+ R# K9 {* w/ C
42. DELETE FROM DEL_USER_CHAR_LIST;
    3 Z( A) ^- Q+ l* n( k# g0 A/ T
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    
44. DELETE FROM GM_ITEM_MST;
    8 x) y9 E3 F2 q4 v
45. DELETE FROM GUILD_CHAR_INFO;
    
46. DELETE FROM GUILD_INFO
    
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    
48. DELETE FROM GUILD_INFO_SECEDE;
    7 J5 }2 F; ]8 ~5 s' W1 [9 z
49. DELETE FROM GUILD_PEERAGE
    ( y7 ]4 S9 y2 B. {( T1 h! p
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    / ^" Q' c/ F4 |
51. DELETE FROM MSSNGR_CHAR_LIST;
    5 p% s' a: D3 `  n% X4 {3 b# [
52. DELETE FROM SIEGE_INFO;
    8 {8 b, ?1 y5 T, X3 ]
53. DELETE FROM SIEGE_RESULT_LOG;
    
54. DELETE FROM user_bag
    
55. WHERE character_no NOT LIKE 'DEKARON_000001';
      X1 S/ v8 a/ {! Y1 e
56. DELETE FROM user_bag_copy;
    
57. DELETE FROM user_bag_secede;
    % \  d8 p) ?  q: B5 R! x; `/ d
58. DELETE FROM user_character
    
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    9 C$ I# t# p3 r. ~- i" W2 M1 S* m
60. DELETE FROM user_character_secede;
    7 {4 A  r6 N6 q3 {
61. DELETE FROM USER_POSTBOX;
    3 ?# [& {) g0 X- W' \
62. DELETE FROM USER_POSTBOX_SECEDE;
    
63. DELETE FROM User_Quest_Doing;
    
64. DELETE FROM user_quest_doing_secede;
    2 \) B3 D2 n" ?3 I
65. DELETE FROM User_Quest_Done;
    
66. DELETE FROM user_quest_done_secede;
    % d1 x5 W0 u0 j7 Q, x4 ]
67. DELETE FROM user_skill
    , E+ ^- E3 M" ~) P2 o
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    
69. DELETE FROM user_skill_secede
    " K' |% b  k5 q3 p
70. DELETE FROM user_slot
    
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    7 C5 o9 C; X7 w0 D" F; ~
72. DELETE FROM user_storage;
    % [6 k% d( ~/ P" `, J" A: x& `
73. DELETE FROM user_storage_copy;
    
74. DELETE FROM USER_STORE;
    
75. DELETE FROM USER_STORE_copy;
    
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

复制代码

, {: M  L7 r; [4 k

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

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

帖子里面有复制功能