数据库清档SQL语句

admin

1. 
   2 K6 z8 ]# n4 Y$ L
2. 
   ' X0 a# t$ W* N5 f- h2 n# _3 f1 v
3. use account;
   
4. DELETE FROM C_IP_BAN;
   & ~9 o# l1 ]% ~, h, j+ U
5. DELETE FROM C_IP_PERMIT;
   
6. DELETE FROM C_IP_PWD;
   9 n9 k1 J; u0 S( S
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   
8. DELETE FROM C_SEQUENCE;
   
9. DELETE FROM CP_USER_PROFILE;
   1 l6 D, @3 ?# c
10. DELETE FROM MB_USR_IP;
    
11. DELETE FROM MB_USR_PUN;
    7 T6 p" U4 `- Z1 R8 C4 n! [8 K
12. DELETE FROM Tbl_user;
    
13. DELETE FROM USER_CONNLOG_KEY;
    
14. DELETE FROM USER_PROFILE;
    7 B* \( K" z5 }- b1 N. r& p7 u
15. GO
    : L. O9 s( W5 N6 n! Q5 H- B
16. use billing;
    2 Z' x+ z. h+ y% {# r
17. DELETE FROM bl_error_log;
    
18. DELETE FROM c_sequence;
    : @* z/ O7 _1 C
19. DELETE FROM dba_online_daily;
    
20. DELETE FROM dba_online_daily_notok;
    
21. DELETE FROM Tbl_KeepId;
    # t9 `! b' t+ _/ t- s
22. DELETE FROM user_account;
    . m7 ^# r* L) r5 d& Y( G% g
23. DELETE FROM user_account;
    ( M8 l9 w) V' g& N( m0 L; [8 |
24. DELETE FROM user_charge_log;
    7 D) B/ \. H$ q8 }" R
25. DELETE FROM user_everyday_use_info;
    ( B1 ~# g/ H& X) w6 @) o9 `( S4 t
26. DELETE FROM user_give_log;
    : u, ^# ~! b& d  O! O
27. DELETE FROM user_use_log;
    3 i7 L  U; m7 T+ B7 P7 q6 X
28. DELETE FROM user_use_log_bk;
      n" [7 r' Z1 \) a; o
29. GO
    ; {: z" y4 d# Y$ O# x9 f
30. use cash;
    * e3 J6 s3 I+ t
31. DELETE FROM bl_error_log;
    4 k2 |9 Q, j# f& r* t
32. DELETE FROM Tbl_Cash_zj;
    , W% o! C( r) S; S3 u" \9 _7 p0 _( }
33. DELETE FROM user_cash;
    
34. DELETE FROM user_charge_log;
    - A4 n* S/ d3 o
35. DELETE FROM user_use_log;
    
36. GO
    & c) [/ Z: J3 e3 h
37. use character;
    
38. DELETE FROM C_EVENT_ITEM_OP
    ( z2 x; K% p$ p* v
39. DELETE FROM c_restword;
    
40. DELETE FROM char_connlog;
    
41. DELETE FROM CHAR_CONNLOG_KEY;
    
42. DELETE FROM DEL_USER_CHAR_LIST;
    
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    6 Q5 s& W3 u* l- k/ P; b2 R) W7 t
44. DELETE FROM GM_ITEM_MST;
    * j$ h% N: ]* E- F
45. DELETE FROM GUILD_CHAR_INFO;
    9 t& b4 a# H4 c/ z. u
46. DELETE FROM GUILD_INFO
    % z- E7 d6 l( g7 ^/ M# r( e! t
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    $ X. k$ ^4 p/ c$ K
48. DELETE FROM GUILD_INFO_SECEDE;
    
49. DELETE FROM GUILD_PEERAGE
    
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
    2 F" F* o. A4 C3 _
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    
56. DELETE FROM user_bag_copy;
    
57. DELETE FROM user_bag_secede;
    4 G% d  V' e5 j) f1 G/ E: h
58. DELETE FROM user_character
    
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    5 q1 [+ p, _$ C7 O  l+ t
60. DELETE FROM user_character_secede;
    
61. DELETE FROM USER_POSTBOX;
    
62. DELETE FROM USER_POSTBOX_SECEDE;
    ! g7 E9 \6 }- w5 j& m# o1 \
63. DELETE FROM User_Quest_Doing;
    
64. DELETE FROM user_quest_doing_secede;
    3 Z+ N9 Q5 x8 R' {, p5 V
65. DELETE FROM User_Quest_Done;
    + H1 q% B. e, h9 c
66. DELETE FROM user_quest_done_secede;
    
67. DELETE FROM user_skill
    5 i2 {# A) `  b
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    + r+ j8 L; {1 B7 ]
69. DELETE FROM user_skill_secede
    ; q4 v( v( A* G' T, f' D7 C
70. DELETE FROM user_slot
    # }% v/ h3 O# F- y1 P( a
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    
72. DELETE FROM user_storage;
    
73. DELETE FROM user_storage_copy;
    
74. DELETE FROM USER_STORE;
    5 ^( E8 L5 G& y' o; b3 ?9 E
75. DELETE FROM USER_STORE_copy;
    6 a- o* f2 g7 u2 k/ }
76. DELETE FROM USER_STORE_SECEDE;
    
77. DELETE FROM user_suit
    
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    1 P* ~; E, O0 z  a; P
79. DELETE FROM user_suit_copy;
    
80. DELETE FROM user_suit_secede;
    
81. GO

复制代码

# F' ^# G6 p3 Y6 n* ^

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

大张 发表于 2024-10-16 14:56
7 d8 e! m1 H' @1 L3 W" I语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~！

2 d# V' u( l; X1 ]/ Q7 K帖子里面有复制功能