数据库清档SQL语句

admin

1. 
   
2. 
   
3. use account;
   4 k1 ^9 Q: a, a0 V8 j
4. DELETE FROM C_IP_BAN;
   
5. DELETE FROM C_IP_PERMIT;
   
6. DELETE FROM C_IP_PWD;
   
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   3 @; |+ W; u( _3 m- O3 N
8. DELETE FROM C_SEQUENCE;
   
9. DELETE FROM CP_USER_PROFILE;
   
10. DELETE FROM MB_USR_IP;
    
11. DELETE FROM MB_USR_PUN;
    ( Z! Q* E1 H. p; V
12. DELETE FROM Tbl_user;
    8 u, |  D. a+ L% q( W: C, w. [
13. DELETE FROM USER_CONNLOG_KEY;
    
14. DELETE FROM USER_PROFILE;
    ) n3 ]# s! k0 @$ a; X
15. GO
    
16. use billing;
    . _& O: b) S; {) j, K: z
17. DELETE FROM bl_error_log;
    * }. _# o/ T3 U9 m: D# s
18. DELETE FROM c_sequence;
    : B3 J4 l$ t. |8 G' @" R
19. DELETE FROM dba_online_daily;
    " h- q" p4 B2 a# U  c) T: B
20. DELETE FROM dba_online_daily_notok;
    3 C+ S7 c5 I. V# q7 @
21. DELETE FROM Tbl_KeepId;
    
22. DELETE FROM user_account;
    ( Z3 }8 d: G1 H- I0 W9 K% b+ l* f1 p
23. DELETE FROM user_account;
    
24. DELETE FROM user_charge_log;
    
25. DELETE FROM user_everyday_use_info;
    " G0 G! J" K+ F  [4 Q1 {# G
26. DELETE FROM user_give_log;
    
27. DELETE FROM user_use_log;
    7 N( {. U6 N# N% q9 [8 e
28. DELETE FROM user_use_log_bk;
    8 K4 N9 e/ b- ^( ~0 k8 \$ e4 m
29. GO
    
30. use cash;
    4 X8 H0 x' z& w9 F) ]' K8 ^% K( a
31. DELETE FROM bl_error_log;
    3 g! j; U, W& `; ~0 j
32. DELETE FROM Tbl_Cash_zj;
    " `. V3 s) u8 J5 e; i/ F% b
33. DELETE FROM user_cash;
    9 T* A% a, z% u, K" P. X( e
34. DELETE FROM user_charge_log;
    5 H; }4 R' i8 }, E" g
35. DELETE FROM user_use_log;
    
36. GO
    * T4 N0 c, ], C" m9 q: ^& b: g% y( b* s
37. use character;
    
38. DELETE FROM C_EVENT_ITEM_OP
    
39. DELETE FROM c_restword;
    
40. DELETE FROM char_connlog;
    ( F% _7 T$ O3 w" D1 a& u0 ~* f3 C2 p( M' x
41. DELETE FROM CHAR_CONNLOG_KEY;
    $ y" [; I+ `0 y) R+ a
42. DELETE FROM DEL_USER_CHAR_LIST;
    7 x0 M7 _1 K0 `( j' c8 T
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    
44. DELETE FROM GM_ITEM_MST;
    
45. DELETE FROM GUILD_CHAR_INFO;
    
46. DELETE FROM GUILD_INFO
    
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    
48. DELETE FROM GUILD_INFO_SECEDE;
    : J* k# [; d( X
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
    
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    5 B4 ]; `: h; D
56. DELETE FROM user_bag_copy;
    ) u1 Q- \% I7 g/ a' c
57. DELETE FROM user_bag_secede;
    1 ~4 c, {% X1 ^( i# e
58. DELETE FROM user_character
    6 E$ c9 m2 n/ m! D& M
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    
60. DELETE FROM user_character_secede;
    5 u4 Q5 B& ~6 M( ?& C/ ~
61. DELETE FROM USER_POSTBOX;
    # q- b: P* d  ~2 \; J
62. DELETE FROM USER_POSTBOX_SECEDE;
    
63. DELETE FROM User_Quest_Doing;
    8 v0 x6 t8 {% D) H7 k: q" F, @" D
64. DELETE FROM user_quest_doing_secede;
    
65. DELETE FROM User_Quest_Done;
    
66. DELETE FROM user_quest_done_secede;
    2 t# s/ V  k: y: K* t
67. DELETE FROM user_skill
    6 J# e3 _. W* ]7 c- @; v) s
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    
69. DELETE FROM user_skill_secede
    - p, i" x( \% _4 o. B* B3 D
70. DELETE FROM user_slot
    
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    
72. DELETE FROM user_storage;
    7 a9 b, h* t0 i4 [( a
73. DELETE FROM user_storage_copy;
    , ~& N7 I8 X" j2 ^$ O! c) w
74. DELETE FROM USER_STORE;
    & S/ H! {. o' f2 `/ r  x3 B, e% N  b# H# B
75. DELETE FROM USER_STORE_copy;
    
76. DELETE FROM USER_STORE_SECEDE;
    
77. DELETE FROM user_suit
    
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    
79. DELETE FROM user_suit_copy;
    
80. DELETE FROM user_suit_secede;
    8 V8 ?; o* [0 ~3 C* ~
81. GO

复制代码

5 {* B: T  O2 O+ w+ R
3 T# a, c+ ?0 k

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

大张 发表于 2024-10-16 14:56
8 H$ X# _3 i2 n- D7 B- n* U; G& ~) C语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~！

帖子里面有复制功能