数据库清档SQL语句

admin

1. 
   + @. K$ q  n& h: A" Z6 _, p5 k7 p
2. 
   
3. use account;
   ' [! A6 S+ `  \! A5 I3 M
4. DELETE FROM C_IP_BAN;
   + B* |5 X: P! I- X
5. DELETE FROM C_IP_PERMIT;
   # E% c& p4 B: E2 u1 u9 R
6. DELETE FROM C_IP_PWD;
   ! J- n2 V( O6 s; \; Z: x( t
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   . b& e9 e' m9 p6 `' Z. V/ e) C
8. DELETE FROM C_SEQUENCE;
   ( H. _4 }, I: F1 o; A, [; a
9. DELETE FROM CP_USER_PROFILE;
   , S4 [! X6 n# V4 a
10. DELETE FROM MB_USR_IP;
    
11. DELETE FROM MB_USR_PUN;
    
12. DELETE FROM Tbl_user;
    1 X9 [4 @2 V& Q8 Z
13. DELETE FROM USER_CONNLOG_KEY;
    
14. DELETE FROM USER_PROFILE;
    
15. GO
    
16. use billing;
    
17. DELETE FROM bl_error_log;
    
18. DELETE FROM c_sequence;
    : Z8 n; X) Y  W9 a" |1 M4 F" h. J  R
19. DELETE FROM dba_online_daily;
    , n' J  O% ~" ?, {2 R* I
20. DELETE FROM dba_online_daily_notok;
    
21. DELETE FROM Tbl_KeepId;
    9 L. Z3 s/ ]& p/ a
22. DELETE FROM user_account;
    & M9 y+ F6 R$ T' Z9 j) e
23. DELETE FROM user_account;
    
24. DELETE FROM user_charge_log;
    ! N% Q1 P/ d+ v' A: A& Z  \
25. DELETE FROM user_everyday_use_info;
    + }/ u9 J6 m( v2 c0 V' i/ A
26. DELETE FROM user_give_log;
    : b0 I: K& X- Z3 {) x+ D" Z# ^
27. DELETE FROM user_use_log;
    # Z* {, T! _+ A9 ]
28. DELETE FROM user_use_log_bk;
    
29. GO
    5 J  ~- V5 Q$ O8 o) a
30. use cash;
    , V! ^5 p" y3 d( e6 M9 g" d! A
31. DELETE FROM bl_error_log;
    5 y+ n: ^& d  ^8 I8 Y6 `* I7 O
32. DELETE FROM Tbl_Cash_zj;
    
33. DELETE FROM user_cash;
    $ k" ]" D) c: h5 m1 |
34. DELETE FROM user_charge_log;
    - z3 h# N0 s# e; n; \% n0 Z
35. DELETE FROM user_use_log;
    
36. GO
    8 j; `, V9 @4 X9 Y9 U: _3 k
37. use character;
    - g3 \, y% K, p; f+ D/ i
38. DELETE FROM C_EVENT_ITEM_OP
    , x: u# Y: ]9 y, B0 V* `4 W/ ]
39. DELETE FROM c_restword;
    
40. DELETE FROM char_connlog;
    2 J/ P2 W9 |& Q
41. DELETE FROM CHAR_CONNLOG_KEY;
    
42. DELETE FROM DEL_USER_CHAR_LIST;
    . R. [5 c' [* Y
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    
44. DELETE FROM GM_ITEM_MST;
    5 U+ Q7 m9 b3 O$ a& P: ]# w
45. DELETE FROM GUILD_CHAR_INFO;
    
46. DELETE FROM GUILD_INFO
    * a4 k0 K( a# T
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    
48. DELETE FROM GUILD_INFO_SECEDE;
    6 D0 i4 e1 r4 g/ U& r0 e3 e
49. DELETE FROM GUILD_PEERAGE
    " t+ j8 ?" \* D+ t  H
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    
51. DELETE FROM MSSNGR_CHAR_LIST;
    
52. DELETE FROM SIEGE_INFO;
    " W" Z, A/ ~- M3 k# b% F, i
53. DELETE FROM SIEGE_RESULT_LOG;
    & J5 F: c' V2 E( i
54. DELETE FROM user_bag
    , _6 T. b: |" k9 X9 `# j. q5 P/ p
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    
56. DELETE FROM user_bag_copy;
    1 Z' [" Z' y# {% S7 t' G2 V6 p
57. DELETE FROM user_bag_secede;
    
58. DELETE FROM user_character
    + ^' [& A" o! Z2 Z
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    
60. DELETE FROM user_character_secede;
    
61. DELETE FROM USER_POSTBOX;
    * Q5 v8 w$ X- @! N1 e- o, r( P
62. DELETE FROM USER_POSTBOX_SECEDE;
    , g& ]% B$ E- }; r% G3 K
63. DELETE FROM User_Quest_Doing;
    
64. DELETE FROM user_quest_doing_secede;
    
65. DELETE FROM User_Quest_Done;
    7 ~) _/ T9 d4 i- a
66. DELETE FROM user_quest_done_secede;
    % I. h  F, x% k
67. DELETE FROM user_skill
    " V5 ]; ^( E; u1 v
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    4 T% H. i- ^3 l6 b0 ?: y/ b" b; @
69. DELETE FROM user_skill_secede
    
70. DELETE FROM user_slot
    
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    / C/ L. a' d. ~$ F
72. DELETE FROM user_storage;
    9 o4 L6 F1 n. R1 {) C' _" f4 R8 Q) o
73. DELETE FROM user_storage_copy;
    
74. DELETE FROM USER_STORE;
    + f% v6 a3 G( _
75. DELETE FROM USER_STORE_copy;
    ' q5 O$ j" W. R  Z0 R
76. DELETE FROM USER_STORE_SECEDE;
    & I9 B, C( c/ m3 h3 ?. O
77. DELETE FROM user_suit
    
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    
79. DELETE FROM user_suit_copy;
    4 r, U  }7 U- P5 U
80. DELETE FROM user_suit_secede;
    
81. GO

复制代码

/ |) b3 Y% A! \6 ^

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

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

. g+ y  c% r8 s" Q: e* B  }' V帖子里面有复制功能