数据库清档SQL语句

admin

1. 
   
2. 
   9 k9 b/ `5 H' `& J9 G
3. use account;
   ; L: ?  d, h" V0 q
4. DELETE FROM C_IP_BAN;
   9 ~3 _, `6 J; g. y7 O1 \% u0 i
5. DELETE FROM C_IP_PERMIT;
   
6. DELETE FROM C_IP_PWD;
   8 @, H" @0 J9 s* H
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   
8. DELETE FROM C_SEQUENCE;
   
9. DELETE FROM CP_USER_PROFILE;
   : I* k4 Y6 Q. N
10. DELETE FROM MB_USR_IP;
    1 K+ t$ Q9 D9 S6 l. Y, f) u2 c
11. DELETE FROM MB_USR_PUN;
    
12. DELETE FROM Tbl_user;
    
13. DELETE FROM USER_CONNLOG_KEY;
    % `4 O1 G# R( N0 t5 X  b
14. DELETE FROM USER_PROFILE;
      J. J& W  T( P  b( d' k/ m
15. GO
    
16. use billing;
    
17. DELETE FROM bl_error_log;
    0 A& I8 ~( r4 r- i8 ?3 [
18. DELETE FROM c_sequence;
    
19. DELETE FROM dba_online_daily;
    
20. DELETE FROM dba_online_daily_notok;
    
21. DELETE FROM Tbl_KeepId;
    
22. DELETE FROM user_account;
    
23. DELETE FROM user_account;
    1 \; v5 c/ w6 w& g) L$ ?$ ^
24. DELETE FROM user_charge_log;
    ) m9 o7 C- u9 O9 z* M$ f+ G
25. DELETE FROM user_everyday_use_info;
    2 x1 h7 B$ \1 j. V4 ]" \
26. DELETE FROM user_give_log;
    7 m1 g1 j$ ?- T# ?0 a
27. DELETE FROM user_use_log;
    
28. DELETE FROM user_use_log_bk;
    ; N+ j6 I  F+ W/ S% j; L. Q1 m
29. GO
    9 k( j$ r) Q# H' \, z$ Z0 b# o( O
30. use cash;
    
31. DELETE FROM bl_error_log;
    ! ?1 T9 [5 t" ?5 M8 c9 e
32. DELETE FROM Tbl_Cash_zj;
    7 Z% i$ v- A* B) ^8 u
33. DELETE FROM user_cash;
    0 D. N0 n* }! A* b9 `% O* L/ Q
34. DELETE FROM user_charge_log;
    , l6 a% v8 B/ P+ j9 e5 h0 q/ N
35. DELETE FROM user_use_log;
    
36. GO
    * L: [, ]* m0 l
37. use character;
    ; a8 B4 d/ \! j; K
38. DELETE FROM C_EVENT_ITEM_OP
    
39. DELETE FROM c_restword;
    8 k+ d% h. ~( U+ x4 \
40. DELETE FROM char_connlog;
    ' ^; M: K, p" f6 W& ^& g+ U0 A2 Y
41. DELETE FROM CHAR_CONNLOG_KEY;
    
42. DELETE FROM DEL_USER_CHAR_LIST;
    / Q1 y& v) M* d- {" p: K; }
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    2 g  K$ i( l' ?* l# `  v
44. DELETE FROM GM_ITEM_MST;
    
45. DELETE FROM GUILD_CHAR_INFO;
    
46. DELETE FROM GUILD_INFO
    " ?4 J" U/ q0 i, G1 A+ i) d$ t  _
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    
48. DELETE FROM GUILD_INFO_SECEDE;
    
49. DELETE FROM GUILD_PEERAGE
    ! P* R2 s# L2 p. J
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    
51. DELETE FROM MSSNGR_CHAR_LIST;
    
52. DELETE FROM SIEGE_INFO;
    
53. DELETE FROM SIEGE_RESULT_LOG;
    . }' d0 Z0 K: t6 |* w
54. DELETE FROM user_bag
    2 b, g) ?3 D) M6 t- `) R% E- Z
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    
56. DELETE FROM user_bag_copy;
    
57. DELETE FROM user_bag_secede;
    6 Y" \& U) R* \
58. DELETE FROM user_character
    ) @: d# Y8 d5 r' k4 }7 m
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    ) ~# N( z. ?; g% Z
60. DELETE FROM user_character_secede;
    
61. DELETE FROM USER_POSTBOX;
    
62. DELETE FROM USER_POSTBOX_SECEDE;
    
63. DELETE FROM User_Quest_Doing;
    
64. DELETE FROM user_quest_doing_secede;
    + H+ @. H. ^" C$ K; W1 }0 h
65. DELETE FROM User_Quest_Done;
    . q3 D- L- D& b5 z& I: [) U
66. DELETE FROM user_quest_done_secede;
    
67. DELETE FROM user_skill
    8 ~. z+ ]" n# {' V4 n3 Z% o) `& ?
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    
69. DELETE FROM user_skill_secede
    
70. DELETE FROM user_slot
    
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    " O1 ^+ V+ {. A0 z
72. DELETE FROM user_storage;
    2 F  P8 |, D. d# n
73. DELETE FROM user_storage_copy;
    # Y# a* I* V. v, Y
74. DELETE FROM USER_STORE;
    
75. DELETE FROM USER_STORE_copy;
    
76. DELETE FROM USER_STORE_SECEDE;
    
77. DELETE FROM user_suit
    ; k0 v9 D/ x- A9 m5 v* K4 W9 Y" g+ P
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    
79. DELETE FROM user_suit_copy;
    
80. DELETE FROM user_suit_secede;
    9 V1 ^9 _9 i, a2 g) w
81. GO

复制代码

' p- k1 s' t( ^  Q4 w

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

大张 发表于 2024-10-16 14:56
$ z" v( i' ~' Y. \0 J语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~！

帖子里面有复制功能