数据库清档SQL语句

admin

1. 
   
2. 
   : L/ v$ c* {) p
3. use account;
   6 l$ k! }$ M! a1 f0 q
4. DELETE FROM C_IP_BAN;
   ! D% {" E/ y, Z5 e+ ~
5. DELETE FROM C_IP_PERMIT;
   
6. DELETE FROM C_IP_PWD;
   * R, b/ v$ A: L
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   
8. DELETE FROM C_SEQUENCE;
   . k! ~8 z. c. s; g0 ~
9. DELETE FROM CP_USER_PROFILE;
   8 N6 W3 B& [! B" [' v% p3 `
10. DELETE FROM MB_USR_IP;
    ( R$ ^) P2 J/ W- ~
11. DELETE FROM MB_USR_PUN;
    
12. DELETE FROM Tbl_user;
    $ O- y, v  v" j% N% x* a) }/ P
13. DELETE FROM USER_CONNLOG_KEY;
    
14. DELETE FROM USER_PROFILE;
    
15. GO
    
16. use billing;
    1 b: f4 v$ v. b! z; m  M& ?
17. DELETE FROM bl_error_log;
    
18. DELETE FROM c_sequence;
    
19. DELETE FROM dba_online_daily;
    : N; X# v) h+ x
20. DELETE FROM dba_online_daily_notok;
    
21. DELETE FROM Tbl_KeepId;
    
22. DELETE FROM user_account;
    0 s  X0 W& e/ G. Y& M9 }
23. DELETE FROM user_account;
    
24. DELETE FROM user_charge_log;
    - K6 Y' `) L: }  k$ _6 }
25. DELETE FROM user_everyday_use_info;
    $ W, N/ E0 P+ [# U0 Y9 T( o
26. DELETE FROM user_give_log;
    ) S# K4 M2 E( A! d; l( Z+ A
27. DELETE FROM user_use_log;
      m+ \: Y, l6 G5 j% {$ P7 X
28. DELETE FROM user_use_log_bk;
    ! {- j3 ?$ J, l  Y/ m1 o1 l
29. GO
    
30. use cash;
    
31. DELETE FROM bl_error_log;
    ) k, n, n3 p6 D+ ^$ P& j
32. DELETE FROM Tbl_Cash_zj;
    1 u0 t& s5 t  Q) \4 N5 Z# p
33. DELETE FROM user_cash;
    1 I2 ~4 f- Q9 Q
34. DELETE FROM user_charge_log;
    9 u, @% o$ ~7 F. M$ u, H; \
35. DELETE FROM user_use_log;
    # @6 z7 t4 u: U7 L0 D, v
36. GO
    
37. use character;
    4 R4 R2 N& H: M" u9 Q0 b
38. DELETE FROM C_EVENT_ITEM_OP
    , ]6 i! v! Z5 L
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;
    
44. DELETE FROM GM_ITEM_MST;
    ; r) B: e- A2 d" l9 q7 M# S0 \
45. DELETE FROM GUILD_CHAR_INFO;
    
46. DELETE FROM GUILD_INFO
    . k" R- T; k; p* a9 c4 g' Y
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    5 H0 H- P, I$ o$ n
48. DELETE FROM GUILD_INFO_SECEDE;
      G  x; n4 N# I) L8 E
49. DELETE FROM GUILD_PEERAGE
    ' ^6 s4 w) s7 Q! \
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    % P3 V+ a% @8 |+ P5 ?
51. DELETE FROM MSSNGR_CHAR_LIST;
    # ^- k5 k9 |  G7 w7 v7 ~
52. DELETE FROM SIEGE_INFO;
    
53. DELETE FROM SIEGE_RESULT_LOG;
    
54. DELETE FROM user_bag
    % E: ^- G$ G3 a/ A# L
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    4 X5 O  q( H/ B1 j2 R
56. DELETE FROM user_bag_copy;
    ) G& x% M) x! X
57. DELETE FROM user_bag_secede;
    * t: p  K# |2 c& X; `9 E9 q0 C
58. DELETE FROM user_character
    
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    / e% m& U) P- r. z/ V; \* }6 e
60. DELETE FROM user_character_secede;
    + r9 J9 H: r! O) \$ \
61. DELETE FROM USER_POSTBOX;
    
62. DELETE FROM USER_POSTBOX_SECEDE;
    
63. DELETE FROM User_Quest_Doing;
    : |' J( N( X, e7 V2 K5 P
64. DELETE FROM user_quest_doing_secede;
    
65. DELETE FROM User_Quest_Done;
    - _: `3 R0 B6 `9 ?+ q6 }
66. DELETE FROM user_quest_done_secede;
    
67. DELETE FROM user_skill
    ' q' L) O- I0 b$ U5 C; y
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';
    * n2 N$ ?; f& P
72. DELETE FROM user_storage;
    
73. DELETE FROM user_storage_copy;
    
74. DELETE FROM USER_STORE;
    
75. DELETE FROM USER_STORE_copy;
    
76. DELETE FROM USER_STORE_SECEDE;
    / E3 s' ?6 t( `6 ]9 ^/ m7 U/ O
77. DELETE FROM user_suit
    4 J5 x3 S" d4 h, e9 i; i" p
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    , B+ G9 n) }# u: }5 t1 `
79. DELETE FROM user_suit_copy;
    
80. DELETE FROM user_suit_secede;
    
81. GO

复制代码

9 H5 x8 p! C5 n  A, v* F1 g

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

大张 发表于 2024-10-16 14:56
) @7 U: k9 w* U4 `( T语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~！

帖子里面有复制功能