数据库清档SQL语句

admin

1. 
   
2. 
   
3. use account;
   
4. DELETE FROM C_IP_BAN;
   
5. DELETE FROM C_IP_PERMIT;
   2 a) P) ?2 }" }9 H0 C8 B3 q. W$ |. Z
6. DELETE FROM C_IP_PWD;
   
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   
8. DELETE FROM C_SEQUENCE;
   / C9 W. i& A: |: M  z
9. DELETE FROM CP_USER_PROFILE;
   
10. DELETE FROM MB_USR_IP;
    3 D4 \5 e9 {2 s
11. DELETE FROM MB_USR_PUN;
    ) [& u$ L( v/ R  y
12. DELETE FROM Tbl_user;
    
13. DELETE FROM USER_CONNLOG_KEY;
    5 K* G; l8 o% W9 X
14. DELETE FROM USER_PROFILE;
    
15. GO
    1 W% i6 O' T3 t! i$ L4 k- d
16. use billing;
    3 a9 D  t: l2 f, g* @9 J
17. DELETE FROM bl_error_log;
    0 u/ x( {. k+ ~  A! i( g4 m, s
18. DELETE FROM c_sequence;
    
19. DELETE FROM dba_online_daily;
    
20. DELETE FROM dba_online_daily_notok;
    4 g; e% a. i- s5 n8 Y! R
21. DELETE FROM Tbl_KeepId;
    
22. DELETE FROM user_account;
    
23. DELETE FROM user_account;
    ) a3 p6 z6 Q+ o$ P' M$ r
24. DELETE FROM user_charge_log;
    ( R+ V& h2 z- _  Z& [
25. DELETE FROM user_everyday_use_info;
    , g% @  E" ~% [0 ]' M& b6 C) }6 X
26. DELETE FROM user_give_log;
    
27. DELETE FROM user_use_log;
    0 w+ E# S+ d, x' g0 A8 o
28. DELETE FROM user_use_log_bk;
    / K* L1 M$ W1 f9 @' X2 c4 g
29. GO
    
30. use cash;
    
31. DELETE FROM bl_error_log;
    
32. DELETE FROM Tbl_Cash_zj;
    0 J* ^, R! h3 T) q
33. DELETE FROM user_cash;
    
34. DELETE FROM user_charge_log;
    3 j. v1 A% B& D9 I6 R
35. DELETE FROM user_use_log;
    
36. GO
    ) }4 Y6 @; `) G
37. use character;
    5 O  U* R! A" f) F) R/ n
38. DELETE FROM C_EVENT_ITEM_OP
    / ?2 D4 L6 ?2 _( p5 Y5 M% V/ b3 n
39. DELETE FROM c_restword;
    2 d& `) M! }2 m3 Z2 f* t  z
40. DELETE FROM char_connlog;
    : K; B  U% i) w; P4 ?
41. DELETE FROM CHAR_CONNLOG_KEY;
    
42. DELETE FROM DEL_USER_CHAR_LIST;
    ; B7 p+ e7 O4 F% P7 E9 \
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    
44. DELETE FROM GM_ITEM_MST;
    . ?- _& g+ `. A9 x7 X
45. DELETE FROM GUILD_CHAR_INFO;
    / R+ W! M. m; z% A  N
46. DELETE FROM GUILD_INFO
    
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    
48. DELETE FROM GUILD_INFO_SECEDE;
    
49. DELETE FROM GUILD_PEERAGE
    
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    6 c4 c/ `" m9 T6 J- z8 `: [
51. DELETE FROM MSSNGR_CHAR_LIST;
    
52. DELETE FROM SIEGE_INFO;
    3 X( b$ C3 C6 G1 Z' N
53. DELETE FROM SIEGE_RESULT_LOG;
    
54. DELETE FROM user_bag
    
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    $ ~$ z$ j- c* r% @2 e7 Y4 a" R5 b" u
56. DELETE FROM user_bag_copy;
    
57. DELETE FROM user_bag_secede;
    : S7 Z8 t" g# f- S
58. DELETE FROM user_character
    
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    / R; T! k  m, N
60. DELETE FROM user_character_secede;
    4 T# l& V8 n+ c0 T+ M8 |
61. DELETE FROM USER_POSTBOX;
    : z8 G4 t# q0 [% C* C
62. DELETE FROM USER_POSTBOX_SECEDE;
    
63. DELETE FROM User_Quest_Doing;
    7 x: l4 L1 P/ i
64. DELETE FROM user_quest_doing_secede;
    % e: q  n' N( E4 b2 f' w/ J
65. DELETE FROM User_Quest_Done;
    ; U+ M2 Q% F- R2 O6 d
66. DELETE FROM user_quest_done_secede;
    7 l( Z5 |& @) W0 s+ c- z
67. DELETE FROM user_skill
    
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    - y0 ^$ Z( ^' q  ?
69. DELETE FROM user_skill_secede
    0 L4 L) Z1 ^, k4 w- m/ A
70. DELETE FROM user_slot
    1 A. Z; {& |) U1 `# f
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    
72. DELETE FROM user_storage;
      i; I* X1 s& V' F9 J, m. s
73. DELETE FROM user_storage_copy;
    
74. DELETE FROM USER_STORE;
      T' v7 F& P2 `' I2 s
75. DELETE FROM USER_STORE_copy;
    
76. DELETE FROM USER_STORE_SECEDE;
    , b  B; T. i0 K. Y. [
77. DELETE FROM user_suit
    
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    
79. DELETE FROM user_suit_copy;
    6 v8 A7 V3 T4 z8 D! A4 O& X$ T1 F
80. DELETE FROM user_suit_secede;
    & e. H6 _, G3 k1 m9 v' o
81. GO

复制代码

* O9 l9 q% T+ N6 L+ t: k7 O

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

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

: |7 C1 A& h8 d4 v: q5 v0 R# c帖子里面有复制功能