数据库清档SQL语句

admin

1. 
   
2. 
   & f$ }  W# a- Z
3. use account;
   
4. DELETE FROM C_IP_BAN;
   / T1 {- I' @1 W7 |7 m
5. DELETE FROM C_IP_PERMIT;
   
6. DELETE FROM C_IP_PWD;
   
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   
8. DELETE FROM C_SEQUENCE;
   1 h- {) d- J% y
9. DELETE FROM CP_USER_PROFILE;
   
10. DELETE FROM MB_USR_IP;
    ; F; O# E- a- c3 {  e. h
11. DELETE FROM MB_USR_PUN;
    
12. DELETE FROM Tbl_user;
    + W- h7 a2 _" e9 Y1 V3 n
13. DELETE FROM USER_CONNLOG_KEY;
    / I, E3 k' T% X9 K
14. DELETE FROM USER_PROFILE;
    
15. GO
    
16. use billing;
    
17. DELETE FROM bl_error_log;
    
18. DELETE FROM c_sequence;
    . X8 Z& [7 T& B* I. ]6 |5 f. ]4 d
19. DELETE FROM dba_online_daily;
    ) P& u0 m# I3 p3 g+ Y
20. DELETE FROM dba_online_daily_notok;
    
21. DELETE FROM Tbl_KeepId;
    ; A3 J- F! E4 o
22. DELETE FROM user_account;
    1 Z" x/ e6 t- A4 x0 b
23. DELETE FROM user_account;
    9 {+ W: a7 q  G# C' r4 Y
24. DELETE FROM user_charge_log;
    
25. DELETE FROM user_everyday_use_info;
    & H7 ]1 N! L; A0 b2 {/ J$ Y
26. DELETE FROM user_give_log;
    4 B1 S# \- v& P3 J6 o
27. DELETE FROM user_use_log;
    # d2 B5 g7 M5 h8 u# e9 R* ]1 Y3 `
28. DELETE FROM user_use_log_bk;
    # f2 o' @) ^. D- [
29. GO
    # v( [2 v2 t6 P- c2 M
30. use cash;
    8 B! d1 n! y' P* B  y
31. DELETE FROM bl_error_log;
    
32. DELETE FROM Tbl_Cash_zj;
    
33. DELETE FROM user_cash;
    
34. DELETE FROM user_charge_log;
    5 u  g# u$ v; |
35. DELETE FROM user_use_log;
    
36. GO
    + q6 s/ {& P% C
37. use character;
    & |' Q1 G0 }" f
38. DELETE FROM C_EVENT_ITEM_OP
    
39. DELETE FROM c_restword;
    ! d# j- R+ X. }4 \
40. DELETE FROM char_connlog;
    1 N9 O) y, u6 F1 T, v+ ]
41. DELETE FROM CHAR_CONNLOG_KEY;
    3 \6 Q% X3 Q2 W+ P" E+ w7 W/ S
42. DELETE FROM DEL_USER_CHAR_LIST;
    ; l6 m) U& _: q# R" b- E
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    
44. DELETE FROM GM_ITEM_MST;
    + C* I) t' o6 V0 d
45. DELETE FROM GUILD_CHAR_INFO;
    
46. DELETE FROM GUILD_INFO
    
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    8 ]8 a& s+ [" C
48. DELETE FROM GUILD_INFO_SECEDE;
    
49. DELETE FROM GUILD_PEERAGE
    
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    
51. DELETE FROM MSSNGR_CHAR_LIST;
    / c1 ~( w8 w! s3 _/ R! z( c
52. DELETE FROM SIEGE_INFO;
    : }7 P; X/ I. U* K& X
53. DELETE FROM SIEGE_RESULT_LOG;
    ( g/ R8 s8 k5 a
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;
    
58. DELETE FROM user_character
    
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    
60. DELETE FROM user_character_secede;
    8 `3 x4 j) m' y- h% V' ?8 P
61. DELETE FROM USER_POSTBOX;
    
62. DELETE FROM USER_POSTBOX_SECEDE;
    
63. DELETE FROM User_Quest_Doing;
    $ E: H. Y. J( u1 s6 B) x- n) h
64. DELETE FROM user_quest_doing_secede;
    $ ]& [  S& I9 S5 |
65. DELETE FROM User_Quest_Done;
    
66. DELETE FROM user_quest_done_secede;
    
67. DELETE FROM user_skill
    1 L5 P( n0 x5 D7 D
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    $ [, [3 p$ T  {! p
69. DELETE FROM user_skill_secede
    
70. DELETE FROM user_slot
    
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    ) W' r8 O5 X* V# d$ w# G! `) Y; _2 ~
72. DELETE FROM user_storage;
    0 O6 g. R' [6 `- ]  F) N$ }4 L
73. DELETE FROM user_storage_copy;
    ) [$ \  |" b( b3 b1 {; t7 _
74. DELETE FROM USER_STORE;
    
75. DELETE FROM USER_STORE_copy;
    
76. DELETE FROM USER_STORE_SECEDE;
    4 \' ~8 [) O9 Y$ ~! {+ L  E
77. DELETE FROM user_suit
    5 \( Y4 _: _( \0 `- {1 O& j
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    
79. DELETE FROM user_suit_copy;
    5 f4 [% v, z7 c/ s7 q9 \( f8 y
80. DELETE FROM user_suit_secede;
    5 e' S8 X8 b4 k" A7 f# I3 ~3 T5 m
81. GO

复制代码

: D4 B. O# A0 M- \5 G2 d

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

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

- Q7 r6 ~* D% O6 ]帖子里面有复制功能