数据库清档SQL语句

admin

1. 
   
2. 
     f7 j1 n. s1 f* f  p. k0 I* l4 Y
3. use account;
   9 F% f2 U: L; H  M
4. DELETE FROM C_IP_BAN;
   * i1 }. }; w- W4 h( b: w
5. DELETE FROM C_IP_PERMIT;
   
6. DELETE FROM C_IP_PWD;
   
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   
8. DELETE FROM C_SEQUENCE;
   
9. DELETE FROM CP_USER_PROFILE;
   
10. DELETE FROM MB_USR_IP;
    : O9 X3 x! c$ h
11. DELETE FROM MB_USR_PUN;
    
12. DELETE FROM Tbl_user;
    
13. DELETE FROM USER_CONNLOG_KEY;
    
14. DELETE FROM USER_PROFILE;
    
15. GO
    4 U4 T' y+ \0 a1 w1 R
16. use billing;
    - N$ Q. s2 Z6 P- h2 S, M
17. DELETE FROM bl_error_log;
    
18. DELETE FROM c_sequence;
    
19. DELETE FROM dba_online_daily;
    7 L( J$ ~7 K6 ]7 p( m! h, C( T+ `
20. DELETE FROM dba_online_daily_notok;
    
21. DELETE FROM Tbl_KeepId;
    ; H9 H# v- l; J' v, c( f7 e
22. DELETE FROM user_account;
    2 b8 Z( G( y% y
23. DELETE FROM user_account;
    5 f, h* B* {* J+ X+ d( r1 z
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;
    ; @3 a# r. q, K' g
28. DELETE FROM user_use_log_bk;
    
29. GO
    ( P/ q" O; z/ [* X9 `$ Q, q% O
30. use cash;
    
31. DELETE FROM bl_error_log;
    " K  J) E: e7 E: y4 D% I! @
32. DELETE FROM Tbl_Cash_zj;
    
33. DELETE FROM user_cash;
    9 e( d" p8 y, Q+ ?
34. DELETE FROM user_charge_log;
    * b" R% u" |, G) i$ U) |: m
35. DELETE FROM user_use_log;
    
36. GO
    
37. use character;
    8 g  c3 f( ]) n
38. DELETE FROM C_EVENT_ITEM_OP
    0 x2 U9 D0 q0 A
39. DELETE FROM c_restword;
    
40. DELETE FROM char_connlog;
    
41. DELETE FROM CHAR_CONNLOG_KEY;
    % ?1 w' O# c$ R- e: ^, r
42. DELETE FROM DEL_USER_CHAR_LIST;
    ' u0 X; g) e. K7 o( R
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    
44. DELETE FROM GM_ITEM_MST;
    , {) i+ U& b9 ]9 _
45. DELETE FROM GUILD_CHAR_INFO;
    
46. DELETE FROM GUILD_INFO
    9 Q: o1 J3 ^: ?/ h' w
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    
48. DELETE FROM GUILD_INFO_SECEDE;
    " f2 G) P6 U! K$ I
49. DELETE FROM GUILD_PEERAGE
    $ @2 b1 X, l( y8 r
50. WHERE guild_code NOT LIKE 'MASTERCODE';
      C6 ?) h& n! H! y1 x) r
51. DELETE FROM MSSNGR_CHAR_LIST;
    / |6 F! y$ S! ?. ^2 e9 |
52. DELETE FROM SIEGE_INFO;
    - i4 F% ^8 Q) S
53. DELETE FROM SIEGE_RESULT_LOG;
    
54. DELETE FROM user_bag
    & ~0 M1 }. o# P5 C' K
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    
56. DELETE FROM user_bag_copy;
    & E  S# M) ?3 S! I$ s
57. DELETE FROM user_bag_secede;
    
58. DELETE FROM user_character
    ' }( A6 ^6 z2 g. n% n( d
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    5 L2 N& Q& c: m6 _! l
60. DELETE FROM user_character_secede;
    7 F& Y3 s: J9 K, s% S0 p
61. DELETE FROM USER_POSTBOX;
    # X* c+ O9 d0 t0 c1 u% ]4 c: E
62. DELETE FROM USER_POSTBOX_SECEDE;
    
63. DELETE FROM User_Quest_Doing;
    % s1 d0 p/ l% \4 [( t, n
64. DELETE FROM user_quest_doing_secede;
    ; E7 o0 T* h: y4 o' O
65. DELETE FROM User_Quest_Done;
    
66. DELETE FROM user_quest_done_secede;
    $ {- [3 G8 C- j' v) m" E' C% @
67. DELETE FROM user_skill
    . H: S( Z4 m9 e; s' z! E
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    - E8 \8 }4 D* @  u5 {# U
69. DELETE FROM user_skill_secede
    2 ^7 O1 \8 P' W( _! S+ t
70. DELETE FROM user_slot
    
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    
72. DELETE FROM user_storage;
    
73. DELETE FROM user_storage_copy;
    / ^& Z- S5 S: N! ~2 t4 p
74. DELETE FROM USER_STORE;
    * C7 m! H7 @1 h: n  `# o& [
75. DELETE FROM USER_STORE_copy;
    
76. DELETE FROM USER_STORE_SECEDE;
    
77. DELETE FROM user_suit
    
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    
79. DELETE FROM user_suit_copy;
    
80. DELETE FROM user_suit_secede;
    9 @4 D& Z5 a1 X  k8 p, x# j/ t
81. GO

复制代码

- \% Q8 k/ Y* {* m) J$ E

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

大张 发表于 2024-10-16 14:56
0 k- b1 r" F5 ]# l- ^) j语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~！

帖子里面有复制功能