数据库清档SQL语句

admin

1. 
   2 Q9 H, P) H4 [. z  {, m" M
2. 
   
3. use account;
   5 }, d- R! f' X7 x! e
4. DELETE FROM C_IP_BAN;
   
5. DELETE FROM C_IP_PERMIT;
   / K8 w( A: K- T& w+ V
6. DELETE FROM C_IP_PWD;
   
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   
8. DELETE FROM C_SEQUENCE;
   1 C# n6 Q- f4 }, o7 p4 W
9. DELETE FROM CP_USER_PROFILE;
   " I! P7 [3 E3 K8 f3 J* G
10. DELETE FROM MB_USR_IP;
    1 w; v6 z6 I& z6 }! e* \
11. DELETE FROM MB_USR_PUN;
    
12. DELETE FROM Tbl_user;
    
13. DELETE FROM USER_CONNLOG_KEY;
    
14. DELETE FROM USER_PROFILE;
    
15. GO
    ) Y1 e) S9 o9 E3 _
16. use billing;
    
17. DELETE FROM bl_error_log;
    
18. DELETE FROM c_sequence;
    5 t+ M; J- |. N; t/ R$ s5 r
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;
    
24. DELETE FROM user_charge_log;
    8 P8 J+ l5 _' E, y. ?$ d7 ?1 Y& O
25. DELETE FROM user_everyday_use_info;
    # A4 |" ~, C0 ^* q# X( N# w
26. DELETE FROM user_give_log;
    7 v' n* d) V& [+ X# ?: S& v. c
27. DELETE FROM user_use_log;
    
28. DELETE FROM user_use_log_bk;
    & U( ~7 z. G# G( Y
29. GO
    
30. use cash;
    - \$ {: a" b9 \" P0 h/ f4 o
31. DELETE FROM bl_error_log;
    + }' \& B6 D: ^) F' L' Q2 p
32. DELETE FROM Tbl_Cash_zj;
    
33. DELETE FROM user_cash;
    2 O8 a: d/ z' C
34. DELETE FROM user_charge_log;
    
35. DELETE FROM user_use_log;
    ( Z$ {4 |2 t) O$ t& ^' d
36. GO
    - |- J9 _- l1 q0 K
37. use character;
    
38. DELETE FROM C_EVENT_ITEM_OP
    : a/ f& N* r! L" S
39. DELETE FROM c_restword;
    9 `$ B+ w9 O9 n. F: L
40. DELETE FROM char_connlog;
    ) R5 M2 _$ p8 z2 o! l7 k
41. DELETE FROM CHAR_CONNLOG_KEY;
    8 l- ?6 B5 x  L) k% W
42. DELETE FROM DEL_USER_CHAR_LIST;
    
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    ! r$ D3 A8 E4 q# `' U6 r3 ^
44. DELETE FROM GM_ITEM_MST;
      x$ i  u6 @2 S
45. DELETE FROM GUILD_CHAR_INFO;
    4 g1 Q2 m/ ?( A6 f6 U# h2 l
46. DELETE FROM GUILD_INFO
    
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    1 a  I. @: R$ G3 q5 Z' N- W2 x
48. DELETE FROM GUILD_INFO_SECEDE;
    
49. DELETE FROM GUILD_PEERAGE
    7 m) H# p% N# r  u$ |. X5 {
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    $ q0 h) ]3 B( ^/ E
51. DELETE FROM MSSNGR_CHAR_LIST;
    
52. DELETE FROM SIEGE_INFO;
    
53. DELETE FROM SIEGE_RESULT_LOG;
      T* `' \" W! j/ C3 o3 ^, ]$ M
54. DELETE FROM user_bag
    
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    
56. DELETE FROM user_bag_copy;
    
57. DELETE FROM user_bag_secede;
    # A6 G1 ]& g9 W/ }1 G7 C" h/ J
58. DELETE FROM user_character
    : v2 l9 J! j7 n2 }
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    % l9 Z; f" s2 U7 ^1 l: s: t
60. DELETE FROM user_character_secede;
    
61. DELETE FROM USER_POSTBOX;
    
62. DELETE FROM USER_POSTBOX_SECEDE;
    / L, l2 n" R' Z. D9 s/ b) g
63. DELETE FROM User_Quest_Doing;
    " T! h9 U8 Q6 g
64. DELETE FROM user_quest_doing_secede;
    
65. DELETE FROM User_Quest_Done;
    " k1 p' ]( Z  S+ v4 b
66. DELETE FROM user_quest_done_secede;
    
67. DELETE FROM user_skill
    2 D# p1 X! O; O6 m; ]3 B
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    2 o; z; {: Z( M2 ^1 }
69. DELETE FROM user_skill_secede
    6 n) C# G5 F& J7 a- D9 b" p
70. DELETE FROM user_slot
    / z! p* h( _- g: ?) m0 v6 f' @
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    ! I$ h; R2 {! m" q0 q1 ?( {5 \3 u4 m
72. DELETE FROM user_storage;
    # p- X7 r  C  \7 J4 D
73. DELETE FROM user_storage_copy;
    8 ~. k! i+ ]7 ?4 P1 P5 [( c
74. DELETE FROM USER_STORE;
    8 ~8 q: {; ]( p0 G- ^
75. DELETE FROM USER_STORE_copy;
    5 D; S3 t8 E$ C7 }9 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;
    ! k1 f* ?* b1 N1 p  Q( d
80. DELETE FROM user_suit_secede;
    6 L, C3 d( M, i! ?6 \
81. GO

复制代码

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

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

帖子里面有复制功能