数据库清档SQL语句

admin

1. 
   # I  F/ U6 f& o. y! p
2. 
   ( f7 _2 L1 u3 x9 Z+ ^+ U, b' C
3. use account;
   
4. DELETE FROM C_IP_BAN;
   6 R" z6 H  Y% m* v' v3 E
5. DELETE FROM C_IP_PERMIT;
   
6. DELETE FROM C_IP_PWD;
   9 T$ T1 x( q. s9 J1 |
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   & A1 o. V! N0 J6 H  q8 R
8. DELETE FROM C_SEQUENCE;
   , v: g* c0 W' r7 Q7 b" ]3 u% r; C. b
9. DELETE FROM CP_USER_PROFILE;
   
10. DELETE FROM MB_USR_IP;
    + B9 i" b$ ^, _* }& L
11. DELETE FROM MB_USR_PUN;
    . k. `3 S' c. y0 l% b* q
12. DELETE FROM Tbl_user;
    . [! F7 y4 j1 t' O. w9 {
13. DELETE FROM USER_CONNLOG_KEY;
    
14. DELETE FROM USER_PROFILE;
    3 V# Y2 o$ G. y8 M. Y' g
15. GO
    
16. use billing;
    ' e; \/ G7 o  }; z" H/ o/ ]+ N# z2 F3 h
17. DELETE FROM bl_error_log;
    
18. DELETE FROM c_sequence;
    
19. DELETE FROM dba_online_daily;
    . g* v) m& ^9 K
20. DELETE FROM dba_online_daily_notok;
    " l" |1 p' d1 G* Y  L
21. DELETE FROM Tbl_KeepId;
    # ]& A/ _4 f" p7 g
22. DELETE FROM user_account;
    " I( f8 ~! S+ J3 j* W& i; P
23. DELETE FROM user_account;
    ! K  w5 V' z+ }( T+ x. x
24. DELETE FROM user_charge_log;
    
25. DELETE FROM user_everyday_use_info;
    
26. DELETE FROM user_give_log;
    , A6 `* t! s0 O! a3 I
27. DELETE FROM user_use_log;
    ( W& g( B6 [( N
28. DELETE FROM user_use_log_bk;
    2 u) \5 Y6 t% [( i9 J- r0 g
29. GO
    
30. use cash;
    * i/ R9 m  G3 L3 u, b& i+ A& g! e
31. DELETE FROM bl_error_log;
    
32. DELETE FROM Tbl_Cash_zj;
    
33. DELETE FROM user_cash;
    5 h  t2 p2 R. b
34. DELETE FROM user_charge_log;
    & }4 y  L. v6 N4 k+ R0 W) {, H' ^
35. DELETE FROM user_use_log;
    ' s+ l3 h" n# o0 e* w, @$ v9 n
36. GO
    5 W7 z* x: B0 I: N# {1 k
37. use character;
    
38. DELETE FROM C_EVENT_ITEM_OP
    ; N3 x/ |" _# p7 l- C, K
39. DELETE FROM c_restword;
    - v5 K6 L) D) ^
40. DELETE FROM char_connlog;
    
41. DELETE FROM CHAR_CONNLOG_KEY;
    + O' K7 I5 n. w- z+ x
42. DELETE FROM DEL_USER_CHAR_LIST;
    5 q2 s; K# f3 ^# Y
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    
44. DELETE FROM GM_ITEM_MST;
    1 E6 g, t, |) ~( n* H8 }
45. DELETE FROM GUILD_CHAR_INFO;
    6 q7 c  b- A2 x8 F
46. DELETE FROM GUILD_INFO
    
47. WHERE guild_code NOT LIKE 'MASTERCODE';
      V! l/ o6 ?6 k6 S7 N+ N  G
48. DELETE FROM GUILD_INFO_SECEDE;
    
49. DELETE FROM GUILD_PEERAGE
    ' H0 U8 {, Y& t; A3 e7 P
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    3 B& L( \$ q/ ?; j
51. DELETE FROM MSSNGR_CHAR_LIST;
    
52. DELETE FROM SIEGE_INFO;
    
53. DELETE FROM SIEGE_RESULT_LOG;
    
54. DELETE FROM user_bag
    4 F, d5 u  g7 \
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    / J. D$ z/ Q% x$ e6 t
56. DELETE FROM user_bag_copy;
    * }2 a) i/ ~1 h% w; m
57. DELETE FROM user_bag_secede;
    
58. DELETE FROM user_character
    
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    
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;
    
65. DELETE FROM User_Quest_Done;
    
66. DELETE FROM user_quest_done_secede;
    9 Q; d+ n$ C6 K
67. DELETE FROM user_skill
      I; _' ]2 ~# v) S1 A
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';
    - f, R7 v; b( W) R' L. x; t+ g# {
72. DELETE FROM user_storage;
    
73. DELETE FROM user_storage_copy;
    
74. DELETE FROM USER_STORE;
    % T# G( e# B8 }  F
75. DELETE FROM USER_STORE_copy;
    
76. DELETE FROM USER_STORE_SECEDE;
    $ }, k4 {3 u" f1 Z: u: Z) j
77. DELETE FROM user_suit
    3 C6 G. ^( X4 L( _$ ^# K( b
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    
79. DELETE FROM user_suit_copy;
    2 X* O! L2 {. D; B
80. DELETE FROM user_suit_secede;
    
81. GO

复制代码

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

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

# e( t* w( ]) E7 p/ t, B  H  w帖子里面有复制功能