数据库清档SQL语句

admin

1. 
   ; C. z& T  }! T5 X# o& y
2. 
   6 }% r! g0 g- ^1 L) _' H6 S! T
3. use account;
   / h1 p: Y/ p6 P' o0 A5 S& p, l
4. DELETE FROM C_IP_BAN;
   - n7 g) Q: _+ C% M. j# b1 ^
5. DELETE FROM C_IP_PERMIT;
   2 y, Y& e$ T3 f7 s; w/ }* L( a
6. DELETE FROM C_IP_PWD;
   6 j' w" s; A- m* w8 K) r$ v
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   
8. DELETE FROM C_SEQUENCE;
   
9. DELETE FROM CP_USER_PROFILE;
   
10. DELETE FROM MB_USR_IP;
      U- Z3 Z) \" E! w
11. DELETE FROM MB_USR_PUN;
    
12. DELETE FROM Tbl_user;
    
13. DELETE FROM USER_CONNLOG_KEY;
      T  A  ?7 E2 k& x; @. C! i; e
14. DELETE FROM USER_PROFILE;
    ( H4 B7 Q4 `; ^
15. GO
    
16. use billing;
    
17. DELETE FROM bl_error_log;
    
18. DELETE FROM c_sequence;
    % g4 Z$ y( r4 j+ s8 L+ O9 l
19. DELETE FROM dba_online_daily;
    . X4 G* x1 \: J
20. DELETE FROM dba_online_daily_notok;
    
21. DELETE FROM Tbl_KeepId;
    2 o8 j1 q( h5 u9 b! x
22. DELETE FROM user_account;
    " e+ F. P. o( s/ j1 `9 v: Q
23. DELETE FROM user_account;
    
24. DELETE FROM user_charge_log;
    . g$ L# p$ m8 N, M# N+ a* |. [
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
    4 D. t& W( z# D1 w
30. use cash;
      ^: Y9 F7 k  g( l5 D
31. DELETE FROM bl_error_log;
    ! ]+ m; g5 f, U' M
32. DELETE FROM Tbl_Cash_zj;
    
33. DELETE FROM user_cash;
    
34. DELETE FROM user_charge_log;
    
35. DELETE FROM user_use_log;
    ; D# L+ i# Y, }7 N4 G) C/ @
36. GO
    ; Y' T& a6 }6 F$ Q. u0 K
37. use character;
    
38. DELETE FROM C_EVENT_ITEM_OP
    
39. DELETE FROM c_restword;
    8 r1 {# A( L' N) |0 B6 _
40. DELETE FROM char_connlog;
    
41. DELETE FROM CHAR_CONNLOG_KEY;
    
42. DELETE FROM DEL_USER_CHAR_LIST;
    ( J2 ]8 q, C* ^" G2 A3 V
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    " G+ @) l. o( k2 {
44. DELETE FROM GM_ITEM_MST;
    7 b# S+ s6 ?$ A. n5 s9 g% D) g: ~
45. DELETE FROM GUILD_CHAR_INFO;
    * n- ]. |* ?6 W: w+ S4 l
46. DELETE FROM GUILD_INFO
    ! v7 z: ~2 N, `0 @1 X
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    7 h: e) U2 e$ m) K( z/ t
48. DELETE FROM GUILD_INFO_SECEDE;
    
49. DELETE FROM GUILD_PEERAGE
    
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    
51. DELETE FROM MSSNGR_CHAR_LIST;
    7 |4 s7 ~' {5 O' c5 g
52. DELETE FROM SIEGE_INFO;
    " F& a, \/ p- D0 X! @
53. DELETE FROM SIEGE_RESULT_LOG;
    
54. DELETE FROM user_bag
    
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    . g' S5 a4 I: d0 b9 N$ i5 R" @* ^
56. DELETE FROM user_bag_copy;
    
57. DELETE FROM user_bag_secede;
    
58. DELETE FROM user_character
    
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    " d/ [* v# @5 |7 l& V
60. DELETE FROM user_character_secede;
    $ ^1 C" L/ m" H" `4 t. O
61. DELETE FROM USER_POSTBOX;
    
62. DELETE FROM USER_POSTBOX_SECEDE;
    
63. DELETE FROM User_Quest_Doing;
    1 b# m7 m- L7 m& \, k" M
64. DELETE FROM user_quest_doing_secede;
    - |. M) d  x; N4 F4 H
65. DELETE FROM User_Quest_Done;
    
66. DELETE FROM user_quest_done_secede;
    * y; a0 ~1 l( g; c# }9 `$ Y, k
67. DELETE FROM user_skill
    ; e0 j/ w- {( y5 ]' }. N7 r. X4 n% m
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    
69. DELETE FROM user_skill_secede
    + D+ R( \: y' F. B+ {2 |2 F
70. DELETE FROM user_slot
    ' L# S9 _- J# L+ ~# v: \
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    6 `0 p  t" y% Z" }3 l
72. DELETE FROM user_storage;
    0 q: p8 G/ U# i
73. DELETE FROM user_storage_copy;
    ' o0 _/ ^* S# ]* `- E
74. DELETE FROM USER_STORE;
    7 x3 e9 e! }+ y! T" u, q8 |" a; P
75. DELETE FROM USER_STORE_copy;
    , |( H8 Q! |) X9 t
76. DELETE FROM USER_STORE_SECEDE;
    3 q& H0 K0 Y" B9 a2 L. U' ~: [
77. DELETE FROM user_suit
    # q. g+ @5 j6 v* X
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    + l/ X; o0 _+ v5 ~5 L
79. DELETE FROM user_suit_copy;
    % X: H' k* }$ A
80. DELETE FROM user_suit_secede;
    2 @+ A* i" I/ l
81. GO

复制代码

& z; L! O3 s" Q& K

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

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

; W5 H+ q7 O' C/ |帖子里面有复制功能