数据库清档SQL语句

admin

1. 
   
2. 
   
3. use account;
   & E7 I- L" g- ?( p! M$ d' s& A, o
4. DELETE FROM C_IP_BAN;
   - a! z$ U% F! R6 f% E* ?  `$ y( {
5. DELETE FROM C_IP_PERMIT;
   ! |5 Z$ P) o0 n% O" f1 `8 P: l
6. DELETE FROM C_IP_PWD;
   
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   0 {( e3 |: v& Q" w. i
8. DELETE FROM C_SEQUENCE;
   8 i+ O5 h; f) e4 ~5 D
9. DELETE FROM CP_USER_PROFILE;
   
10. DELETE FROM MB_USR_IP;
    
11. DELETE FROM MB_USR_PUN;
    
12. DELETE FROM Tbl_user;
    
13. DELETE FROM USER_CONNLOG_KEY;
    
14. DELETE FROM USER_PROFILE;
    % h1 a  J& M& u
15. GO
    
16. use billing;
    ) e& K$ ^" `/ b" R  |
17. DELETE FROM bl_error_log;
    
18. DELETE FROM c_sequence;
    0 o' q% u$ n3 W8 o* d; x# z
19. DELETE FROM dba_online_daily;
    4 Y9 N9 u( b8 q. j* ^8 x
20. DELETE FROM dba_online_daily_notok;
    
21. DELETE FROM Tbl_KeepId;
    1 h. j' a: Z; `. E
22. DELETE FROM user_account;
    
23. DELETE FROM user_account;
    ! ]* [2 F, d& A% ^- S$ J  [
24. DELETE FROM user_charge_log;
    
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;
    9 U, r! Q$ f! p* i. x
29. GO
    ) {0 F9 V$ E. o  x
30. use cash;
    ) T3 y# @, s7 C6 _/ a8 ~
31. DELETE FROM bl_error_log;
    
32. DELETE FROM Tbl_Cash_zj;
    
33. DELETE FROM user_cash;
    4 }& D/ m- {: b- g7 T, U7 M; f* |8 O+ W0 i
34. DELETE FROM user_charge_log;
    " s, c1 n8 l) P" ~
35. DELETE FROM user_use_log;
    
36. GO
    
37. use character;
    
38. DELETE FROM C_EVENT_ITEM_OP
    # [! c1 M7 @9 K9 e$ @
39. DELETE FROM c_restword;
    ' q" }% _- _# X2 e
40. DELETE FROM char_connlog;
    
41. DELETE FROM CHAR_CONNLOG_KEY;
    
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;
    
46. DELETE FROM GUILD_INFO
    
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    / v& t& H  K% b; E- H  U+ h
48. DELETE FROM GUILD_INFO_SECEDE;
    8 x5 {0 A( k0 W
49. DELETE FROM GUILD_PEERAGE
    6 F( Z2 @% J- {. t2 q' c2 e
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    4 q8 ^& e1 q7 Q: A  O& J5 E# o
51. DELETE FROM MSSNGR_CHAR_LIST;
    
52. DELETE FROM SIEGE_INFO;
    
53. DELETE FROM SIEGE_RESULT_LOG;
    
54. DELETE FROM user_bag
    7 E$ A) Y& U7 H6 w
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    
56. DELETE FROM user_bag_copy;
    / `  m% F6 U4 A# e0 Z, R) D0 i
57. DELETE FROM user_bag_secede;
    , k3 d6 ^7 r$ ]  i, v* F
58. DELETE FROM user_character
    ' p  }/ F0 p/ B, p, a' t- D9 i+ H. ?
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    1 k/ M# X: o  z/ a
60. DELETE FROM user_character_secede;
    
61. DELETE FROM USER_POSTBOX;
    2 C- E* z* q, M2 A
62. DELETE FROM USER_POSTBOX_SECEDE;
    
63. DELETE FROM User_Quest_Doing;
    
64. DELETE FROM user_quest_doing_secede;
    * E  T0 U0 a0 |  |- ]5 O# I
65. DELETE FROM User_Quest_Done;
    / ?  C2 ~; v1 n0 j! u
66. DELETE FROM user_quest_done_secede;
    4 A  @7 w5 {! k+ u/ D% T0 b
67. DELETE FROM user_skill
    5 `. a- K4 J; _! u0 M3 ^8 I
68. WHERE character_no NOT LIKE 'DEKARON_000001';
      f: d  P( V( C$ g! {- x
69. DELETE FROM user_skill_secede
    
70. DELETE FROM user_slot
    
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    7 q! Y5 Z* m$ L% C0 D
72. DELETE FROM user_storage;
    8 M, Z3 g4 n& M/ |1 ?
73. DELETE FROM user_storage_copy;
    9 l) `7 D6 ~4 R% h' i/ g/ ^
74. DELETE FROM USER_STORE;
    $ p* U; Y. l' u2 R' S
75. DELETE FROM USER_STORE_copy;
    
76. DELETE FROM USER_STORE_SECEDE;
    6 S- \% u* V- y. @3 a
77. DELETE FROM user_suit
    
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    / |' u# V. w0 Y. Z4 P+ T; q
79. DELETE FROM user_suit_copy;
    * k5 c1 S1 t" M8 i1 _
80. DELETE FROM user_suit_secede;
    
81. GO

复制代码

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

大张 发表于 2024-10-16 14:56
+ a! A2 D4 a( ]8 X$ ~语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~！

" I) O6 X3 k9 B8 c7 c" u帖子里面有复制功能