数据库清档SQL语句

admin

1. 
   5 A# n. Q' w' y+ d' }
2. 
   - K, H6 l$ ?0 L; L' T6 d  d
3. use account;
   
4. DELETE FROM C_IP_BAN;
   
5. DELETE FROM C_IP_PERMIT;
   8 E" ~/ i7 k, {6 X# U# l2 m
6. DELETE FROM C_IP_PWD;
   
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   - |3 d. K" H8 n: u4 s
8. DELETE FROM C_SEQUENCE;
   " K, e) [5 Z# X( T$ f4 @0 Z9 X
9. DELETE FROM CP_USER_PROFILE;
   
10. DELETE FROM MB_USR_IP;
    
11. DELETE FROM MB_USR_PUN;
    ( y" q. D# i$ k- b- r
12. DELETE FROM Tbl_user;
    
13. DELETE FROM USER_CONNLOG_KEY;
    1 V" I1 o) v9 j: H: E
14. DELETE FROM USER_PROFILE;
    ) {( U8 E: x- l7 l9 u  q
15. GO
    
16. use billing;
    
17. DELETE FROM bl_error_log;
    
18. DELETE FROM c_sequence;
    ! R7 a' T+ l- \
19. DELETE FROM dba_online_daily;
    
20. DELETE FROM dba_online_daily_notok;
    
21. DELETE FROM Tbl_KeepId;
    
22. DELETE FROM user_account;
    
23. DELETE FROM user_account;
    
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;
    
28. DELETE FROM user_use_log_bk;
    
29. GO
    1 K9 P* e. q5 |' F) L3 K/ C9 [
30. use cash;
    
31. DELETE FROM bl_error_log;
    * i5 k# V. B$ T- }; ]5 c/ c) u) _
32. DELETE FROM Tbl_Cash_zj;
    - ~4 }8 U( W" |
33. DELETE FROM user_cash;
    
34. DELETE FROM user_charge_log;
    & t4 V  p# P3 J4 A$ a
35. DELETE FROM user_use_log;
    : [* D- ^: p6 |0 A# q% I8 F
36. GO
    1 ?% d; h! n6 y4 o; c* G, P, A' k/ s
37. use character;
    2 U. b5 w; k& d+ \4 _
38. DELETE FROM C_EVENT_ITEM_OP
    
39. DELETE FROM c_restword;
    ) }4 E5 b1 I8 K, ~8 _8 \7 ^
40. DELETE FROM char_connlog;
    / z" ?2 k6 P, t
41. DELETE FROM CHAR_CONNLOG_KEY;
    
42. DELETE FROM DEL_USER_CHAR_LIST;
    1 M: Y' ~" }/ V" }
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    ! v0 K& P* F5 G3 \3 _4 R
44. DELETE FROM GM_ITEM_MST;
    # x3 j; t5 m0 Z( L
45. DELETE FROM GUILD_CHAR_INFO;
    ) a: N) C' F* V/ Y1 z
46. DELETE FROM GUILD_INFO
    
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    : C( G$ i! k! t1 F( L7 z+ N3 f, Z
48. DELETE FROM GUILD_INFO_SECEDE;
    
49. DELETE FROM GUILD_PEERAGE
    - B  M' X6 X" d* w3 {4 E
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    9 Z3 ]4 G+ l. ?' G
51. DELETE FROM MSSNGR_CHAR_LIST;
    
52. DELETE FROM SIEGE_INFO;
    % K+ L: o3 [" _3 V
53. DELETE FROM SIEGE_RESULT_LOG;
    
54. DELETE FROM user_bag
    ) J& u$ o, ]& x5 ?/ o4 p1 y. n
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    2 S6 {" t' g: T( m3 S3 G
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';
    
60. DELETE FROM user_character_secede;
    ( ?) v; t2 E( L0 |
61. DELETE FROM USER_POSTBOX;
    
62. DELETE FROM USER_POSTBOX_SECEDE;
    
63. DELETE FROM User_Quest_Doing;
    
64. DELETE FROM user_quest_doing_secede;
    
65. DELETE FROM User_Quest_Done;
    
66. DELETE FROM user_quest_done_secede;
    ; Y! s9 Q* B" ^' q
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';
    
72. DELETE FROM user_storage;
    
73. DELETE FROM user_storage_copy;
      ^, D+ Y: q$ _: g. C) s
74. DELETE FROM USER_STORE;
    ! O7 [) m; l' _( t) T
75. DELETE FROM USER_STORE_copy;
    
76. DELETE FROM USER_STORE_SECEDE;
    9 {' r" @( v+ Z: K
77. DELETE FROM user_suit
    , Z! T& S# [  ^" U  F: N
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    3 K$ O- i' g* y4 W- h( c
79. DELETE FROM user_suit_copy;
    
80. DELETE FROM user_suit_secede;
    $ w5 X" e( ?% h  r9 _0 _
81. GO

复制代码

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

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

- H: J+ Z0 z2 t' }帖子里面有复制功能