数据库清档SQL语句

admin

1. 
   
2. 
   
3. use account;
   ' P! \4 F  n+ x# E& h; T' }
4. DELETE FROM C_IP_BAN;
   
5. DELETE FROM C_IP_PERMIT;
   # J- N, @' F' h" \. q& F1 M# [/ \% B
6. DELETE FROM C_IP_PWD;
   : a2 [  z7 @' ~, L, o
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   1 U, n. J0 Q3 v4 ~  l
8. DELETE FROM C_SEQUENCE;
   
9. DELETE FROM CP_USER_PROFILE;
   8 |& g* j- b' m- z+ c9 [
10. DELETE FROM MB_USR_IP;
    
11. DELETE FROM MB_USR_PUN;
    
12. DELETE FROM Tbl_user;
    
13. DELETE FROM USER_CONNLOG_KEY;
    
14. DELETE FROM USER_PROFILE;
    
15. GO
    $ b# w6 K$ N; d
16. use billing;
    5 q" ^3 v2 k, o2 r- o: s
17. DELETE FROM bl_error_log;
    8 J1 t7 Q1 E# i0 j7 J6 j
18. DELETE FROM c_sequence;
    
19. DELETE FROM dba_online_daily;
    
20. DELETE FROM dba_online_daily_notok;
    
21. DELETE FROM Tbl_KeepId;
    
22. DELETE FROM user_account;
    / e, M# q* l+ L9 D! z! X6 D
23. DELETE FROM user_account;
    # x0 M) y3 N/ [1 U5 n1 V
24. DELETE FROM user_charge_log;
    ' B1 L4 \4 \" q1 S% ?3 l
25. DELETE FROM user_everyday_use_info;
    
26. DELETE FROM user_give_log;
    9 X5 V& r7 ~, R/ R4 m
27. DELETE FROM user_use_log;
    - V5 W# w) {, s* ], e; X+ c: G4 S
28. DELETE FROM user_use_log_bk;
    
29. GO
    ( w- f+ L* v" n+ V
30. use cash;
    * z" F3 U; s' [" s$ j
31. DELETE FROM bl_error_log;
    8 ]) G- D5 K) u1 R  [& |
32. DELETE FROM Tbl_Cash_zj;
    5 Q" p' K6 x- p
33. DELETE FROM user_cash;
    ' \9 J" Y, i9 B/ z' F7 F) d
34. DELETE FROM user_charge_log;
    1 M! L9 t- D. Z5 {! u
35. DELETE FROM user_use_log;
    
36. GO
    
37. use character;
    4 i) e1 p7 i: B
38. DELETE FROM C_EVENT_ITEM_OP
      L7 a% v( P3 Q
39. DELETE FROM c_restword;
      T( n" l% I0 `4 V* }
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;
    
44. DELETE FROM GM_ITEM_MST;
    6 x6 I: F- `$ ~
45. DELETE FROM GUILD_CHAR_INFO;
    
46. DELETE FROM GUILD_INFO
    * P- ?9 Y& Q" k
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    ) L) Y6 q" i4 Y8 W
48. DELETE FROM GUILD_INFO_SECEDE;
    
49. DELETE FROM GUILD_PEERAGE
    
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    
51. DELETE FROM MSSNGR_CHAR_LIST;
    9 a1 I  |+ h7 P! c. E2 F( I3 l
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;
    
57. DELETE FROM user_bag_secede;
    + B  c0 O: t0 ~- R2 [: h# x
58. DELETE FROM user_character
    
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    
60. DELETE FROM user_character_secede;
    + W1 {* R5 d. F7 R0 X/ N
61. DELETE FROM USER_POSTBOX;
    
62. DELETE FROM USER_POSTBOX_SECEDE;
    9 k9 J, A3 `6 B% U
63. DELETE FROM User_Quest_Doing;
    3 X9 `: Y/ g* H) z% L" e2 J
64. DELETE FROM user_quest_doing_secede;
    5 y- T3 d* X4 }* Q5 N: N# {- S
65. DELETE FROM User_Quest_Done;
    ) {$ y$ g$ H; B: \7 C
66. DELETE FROM user_quest_done_secede;
    
67. DELETE FROM user_skill
    
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    : M3 g6 p5 n: ?# a1 j$ N/ Q) `$ s
69. DELETE FROM user_skill_secede
    7 F2 a$ E" h4 }, v+ F
70. DELETE FROM user_slot
    
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    - P. E, [! t  w; D: x8 f( l# c' p' k
72. DELETE FROM user_storage;
    
73. DELETE FROM user_storage_copy;
    
74. DELETE FROM USER_STORE;
    / g# l9 t& _* a( @) V
75. DELETE FROM USER_STORE_copy;
    0 V2 x7 e/ J" b' O/ s2 [
76. DELETE FROM USER_STORE_SECEDE;
    
77. DELETE FROM user_suit
    / e" l6 ~! ]9 E' ^
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    
79. DELETE FROM user_suit_copy;
    ' l3 G. k: O) m0 ]: x& l. N8 v
80. DELETE FROM user_suit_secede;
    ( V: h4 Y# U  Y+ W
81. GO

复制代码

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

大张 发表于 2024-10-16 14:56
1 T$ N8 @, d. M( X+ C0 k: V& X2 {语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~！

6 O6 y" r" H. c2 O帖子里面有复制功能