数据库清档SQL语句

admin

1. 
   
2. 
   
3. use account;
   . s1 _7 F6 {# [, d& {
4. DELETE FROM C_IP_BAN;
   
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;
   + [, n, E$ U, z
10. DELETE FROM MB_USR_IP;
    
11. DELETE FROM MB_USR_PUN;
    1 |# S/ M) L( q# U% G
12. DELETE FROM Tbl_user;
    
13. DELETE FROM USER_CONNLOG_KEY;
    
14. DELETE FROM USER_PROFILE;
    
15. GO
    
16. use billing;
    
17. DELETE FROM bl_error_log;
    9 W+ t9 [/ {8 K2 o
18. DELETE FROM c_sequence;
    
19. DELETE FROM dba_online_daily;
    
20. DELETE FROM dba_online_daily_notok;
    
21. DELETE FROM Tbl_KeepId;
    # ~5 D5 g4 c- M+ D! X- B# ], U
22. DELETE FROM user_account;
    2 i2 o" E0 [7 J2 |1 D! f
23. DELETE FROM user_account;
    
24. DELETE FROM user_charge_log;
    . V& J  k# h% X- e  A  X
25. DELETE FROM user_everyday_use_info;
    
26. DELETE FROM user_give_log;
    
27. DELETE FROM user_use_log;
    
28. DELETE FROM user_use_log_bk;
    
29. GO
    
30. use cash;
    
31. DELETE FROM bl_error_log;
    ; `' I% }4 L6 u. t
32. DELETE FROM Tbl_Cash_zj;
    
33. DELETE FROM user_cash;
    
34. DELETE FROM user_charge_log;
    & ?9 n- E/ y* o, n0 M1 N
35. DELETE FROM user_use_log;
    
36. GO
    
37. use character;
    3 e7 m. n8 `( |) a8 m5 W- H2 X
38. DELETE FROM C_EVENT_ITEM_OP
    # \9 W7 T* Z  w  T( H; S3 w
39. DELETE FROM c_restword;
    - O" X) c) V0 @: e$ A
40. DELETE FROM char_connlog;
    
41. DELETE FROM CHAR_CONNLOG_KEY;
    6 p: p. Y; t4 f' b6 v- x
42. DELETE FROM DEL_USER_CHAR_LIST;
    
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    
44. DELETE FROM GM_ITEM_MST;
    
45. DELETE FROM GUILD_CHAR_INFO;
    * m; U* [, P3 H6 Z* @* @: s
46. DELETE FROM GUILD_INFO
    6 U9 G/ Y; B2 l: }: B: D
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    
48. DELETE FROM GUILD_INFO_SECEDE;
    0 _- L  W% P. ~  ]) W3 N7 A
49. DELETE FROM GUILD_PEERAGE
    0 O: ]4 U% N" J* Q
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    
51. DELETE FROM MSSNGR_CHAR_LIST;
    3 \0 ?+ k7 u/ _+ u4 u
52. DELETE FROM SIEGE_INFO;
    9 O. D0 t1 l6 a
53. DELETE FROM SIEGE_RESULT_LOG;
    $ B! d4 u* S9 C# ], A! k1 a
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;
    . L+ H& W* C% |; h( k
58. DELETE FROM user_character
    5 U0 j: _$ c& V
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    
60. DELETE FROM user_character_secede;
    / D' M6 V5 K4 H) Q! T
61. DELETE FROM USER_POSTBOX;
    5 |9 `/ F+ }, X, a) w# `
62. DELETE FROM USER_POSTBOX_SECEDE;
    
63. DELETE FROM User_Quest_Doing;
    & ?1 h/ r0 H8 A0 w0 t: a
64. DELETE FROM user_quest_doing_secede;
    
65. DELETE FROM User_Quest_Done;
    ! Z  L) W  s, n. I$ B
66. DELETE FROM user_quest_done_secede;
    3 M( g7 w" @8 f/ J# P( v
67. DELETE FROM user_skill
    
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    8 x  q# E! b3 U0 F1 [3 V5 }% R
69. DELETE FROM user_skill_secede
    % z; l2 H  ~. M
70. DELETE FROM user_slot
    
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    
72. DELETE FROM user_storage;
    ; M8 _) F& N* h/ r* Y
73. DELETE FROM user_storage_copy;
    
74. DELETE FROM USER_STORE;
    
75. DELETE FROM USER_STORE_copy;
    2 `, c1 x4 K7 z3 H
76. DELETE FROM USER_STORE_SECEDE;
    " ^+ A; B, q, q3 N) j
77. DELETE FROM user_suit
    8 G( Z5 ~8 z9 r( W, Q
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    
79. DELETE FROM user_suit_copy;
    
80. DELETE FROM user_suit_secede;
    % h% _9 b' Y; ~
81. GO

复制代码

2 x) ^7 l0 M7 X5 S* K5 h# y

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

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

* t- u5 [, O$ a/ Q' N- m帖子里面有复制功能