数据库清档SQL语句

admin

1. 
   
2. 
   8 N( Q, l" m8 `9 x% U) a
3. use account;
   ! ?7 z9 z2 f1 c# u. L
4. DELETE FROM C_IP_BAN;
   
5. DELETE FROM C_IP_PERMIT;
   1 {  f8 H4 t% j$ K
6. DELETE FROM C_IP_PWD;
   
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   
8. DELETE FROM C_SEQUENCE;
   + N1 i- i& |5 ^" `# E2 w
9. DELETE FROM CP_USER_PROFILE;
   
10. DELETE FROM MB_USR_IP;
    
11. DELETE FROM MB_USR_PUN;
    9 n9 |% P+ C3 o, E4 i4 D7 Q
12. DELETE FROM Tbl_user;
    
13. DELETE FROM USER_CONNLOG_KEY;
    5 R- n; M. `- S( Y+ ~; v9 k5 s
14. DELETE FROM USER_PROFILE;
    : T" y2 U6 x2 U) i+ i8 L
15. GO
    % E/ h0 }# p3 v* g# Y+ o- ]
16. use billing;
    ! `4 z1 K! |! m2 N* O( _$ z4 e
17. DELETE FROM bl_error_log;
    - s( H  R, P% K8 Y
18. DELETE FROM c_sequence;
    6 V8 r6 i. j8 B" e$ N1 n
19. DELETE FROM dba_online_daily;
    
20. DELETE FROM dba_online_daily_notok;
    / g, y! F( W6 Z9 k( h
21. DELETE FROM Tbl_KeepId;
    
22. DELETE FROM user_account;
    % M9 ^& ]+ o0 ?
23. DELETE FROM user_account;
    , I/ W7 T. `( ?' x7 l+ E) e2 M; O
24. DELETE FROM user_charge_log;
    $ U. h* F* y- y7 {. W9 K
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;
    1 L3 [, F' L% ]( D7 Z
29. GO
    0 p6 |! J& B0 H& u" U* s
30. use cash;
    0 z' f  w; V" Z4 i  x( a, z7 X
31. DELETE FROM bl_error_log;
      f" P1 `% x  E* }
32. DELETE FROM Tbl_Cash_zj;
    
33. DELETE FROM user_cash;
    
34. DELETE FROM user_charge_log;
    
35. DELETE FROM user_use_log;
    
36. GO
    7 U+ _. r; Q/ _& u- ?* @
37. use character;
    
38. DELETE FROM C_EVENT_ITEM_OP
    
39. DELETE FROM c_restword;
    8 V: G+ K7 V. f( e: @
40. DELETE FROM char_connlog;
    , W& I& e; X! {' P
41. DELETE FROM CHAR_CONNLOG_KEY;
    . o1 z7 [$ Y' r7 P! E
42. DELETE FROM DEL_USER_CHAR_LIST;
    
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    8 b1 t; g$ n+ l: \$ j# t
44. DELETE FROM GM_ITEM_MST;
    6 N' V4 v' @) c; Y$ d6 l
45. DELETE FROM GUILD_CHAR_INFO;
    % C0 s1 J/ l/ z" z) Q! y
46. DELETE FROM GUILD_INFO
    " O7 S9 M) ~- f: j6 [
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    2 f! g  a: B$ a6 y
48. DELETE FROM GUILD_INFO_SECEDE;
    2 p) U- y' i0 [5 ?7 A9 N  }% ~
49. DELETE FROM GUILD_PEERAGE
    / l; w3 y4 @: i2 M
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    
51. DELETE FROM MSSNGR_CHAR_LIST;
    
52. DELETE FROM SIEGE_INFO;
    
53. DELETE FROM SIEGE_RESULT_LOG;
    
54. DELETE FROM user_bag
    
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    
56. DELETE FROM user_bag_copy;
    $ H% y! o3 h  }1 p
57. DELETE FROM user_bag_secede;
    
58. DELETE FROM user_character
    + z. M4 Y! |1 O
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    . s+ D! m* [1 M9 R/ ^
60. DELETE FROM user_character_secede;
    
61. DELETE FROM USER_POSTBOX;
    " U- H* r  N; _! p
62. DELETE FROM USER_POSTBOX_SECEDE;
    
63. DELETE FROM User_Quest_Doing;
    " }* A8 p% ~9 t8 w! ]$ w
64. DELETE FROM user_quest_doing_secede;
    " ]/ X( Z% {" u4 s& R8 W) P8 ?* P
65. DELETE FROM User_Quest_Done;
    
66. DELETE FROM user_quest_done_secede;
    
67. DELETE FROM user_skill
    
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';
    6 [' b+ H' R( k0 y: l/ \# e# O
72. DELETE FROM user_storage;
    * |" ~: E' O, d6 x# b
73. DELETE FROM user_storage_copy;
    
74. DELETE FROM USER_STORE;
    
75. DELETE FROM USER_STORE_copy;
    , v' d; K; ?5 Q0 r# _7 [- I' r, y
76. DELETE FROM USER_STORE_SECEDE;
    
77. DELETE FROM user_suit
    % m3 x" L7 K* V# |8 A! U
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    
79. DELETE FROM user_suit_copy;
    
80. DELETE FROM user_suit_secede;
    
81. GO

复制代码

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

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

" r' N# D( ]" D2 N" `5 K帖子里面有复制功能