数据库清档SQL语句

admin

1. 
   4 n0 V; F7 s* i3 R$ n
2. 
   5 n& h6 c) b* k  Q. |; K
3. use account;
   4 y0 z6 u$ x: K1 b) R# B  u( m3 W
4. DELETE FROM C_IP_BAN;
   
5. DELETE FROM C_IP_PERMIT;
   ; _2 j6 M' H2 A
6. DELETE FROM C_IP_PWD;
   
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   3 I6 t( M- T" ?5 t+ `9 K( T' k
8. DELETE FROM C_SEQUENCE;
   
9. DELETE FROM CP_USER_PROFILE;
   , [" I1 O1 W3 b4 W% t0 y
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;
    4 F; `; M4 j# ^
15. GO
    2 K/ F& I6 S9 W0 A: g9 T! w
16. use billing;
    2 M7 \6 D$ p' k: e
17. DELETE FROM bl_error_log;
    
18. DELETE FROM c_sequence;
    
19. DELETE FROM dba_online_daily;
    
20. DELETE FROM dba_online_daily_notok;
    6 f# e. n+ h) z) b+ e3 O
21. DELETE FROM Tbl_KeepId;
    0 i5 N/ y: D6 P3 x  W
22. DELETE FROM user_account;
    : y/ [5 \- I7 y$ C8 _; j# v- H
23. DELETE FROM user_account;
    
24. DELETE FROM user_charge_log;
    6 j+ v; j2 [6 M" \  z1 U7 q0 y
25. DELETE FROM user_everyday_use_info;
    
26. DELETE FROM user_give_log;
    5 U$ {/ W" {* y0 D
27. DELETE FROM user_use_log;
    
28. DELETE FROM user_use_log_bk;
    
29. GO
    
30. use cash;
    + E# L0 A% ?& K( m- A0 i
31. DELETE FROM bl_error_log;
    
32. DELETE FROM Tbl_Cash_zj;
    
33. DELETE FROM user_cash;
    
34. DELETE FROM user_charge_log;
    
35. DELETE FROM user_use_log;
    2 F; X) i( z1 W- u: G: N$ d% c
36. GO
    
37. use character;
    7 g# R7 V+ w# t
38. DELETE FROM C_EVENT_ITEM_OP
    
39. DELETE FROM c_restword;
    
40. DELETE FROM char_connlog;
    $ @' ~/ h# J; d) C2 P- V$ X
41. DELETE FROM CHAR_CONNLOG_KEY;
    1 c. z2 s/ W5 L$ @% j3 Z
42. DELETE FROM DEL_USER_CHAR_LIST;
    
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    
44. DELETE FROM GM_ITEM_MST;
    
45. DELETE FROM GUILD_CHAR_INFO;
    6 Z1 U3 X$ a! R
46. DELETE FROM GUILD_INFO
    
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    
48. DELETE FROM GUILD_INFO_SECEDE;
    
49. DELETE FROM GUILD_PEERAGE
    
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    ; e, E' O' z3 ~
51. DELETE FROM MSSNGR_CHAR_LIST;
    
52. DELETE FROM SIEGE_INFO;
    $ t/ d  G' u3 X
53. DELETE FROM SIEGE_RESULT_LOG;
    
54. DELETE FROM user_bag
    , ^+ A$ |  g( m! b
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    
56. DELETE FROM user_bag_copy;
    5 j# T% v6 r2 F8 k- C- ?
57. DELETE FROM user_bag_secede;
    
58. DELETE FROM user_character
    6 a4 B# e- f* @
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    9 s- J' d, W! Y- |4 ^4 t, H
60. DELETE FROM user_character_secede;
    
61. DELETE FROM USER_POSTBOX;
    4 h5 y" L6 k7 N# ?" t; Z
62. DELETE FROM USER_POSTBOX_SECEDE;
    " _. ^$ v: {8 o9 Q6 Y$ p: w
63. DELETE FROM User_Quest_Doing;
    
64. DELETE FROM user_quest_doing_secede;
    8 I* b) {! \2 P1 A% K; q
65. DELETE FROM User_Quest_Done;
    4 s8 R' \9 |& k" e/ C3 C
66. DELETE FROM user_quest_done_secede;
    
67. DELETE FROM user_skill
    
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    
69. DELETE FROM user_skill_secede
    
70. DELETE FROM user_slot
    . ~# h% k, Y4 Q! g1 G
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    
72. DELETE FROM user_storage;
    
73. DELETE FROM user_storage_copy;
    $ {: t: p. H6 A5 W$ D
74. DELETE FROM USER_STORE;
    & s. P8 _. v$ }
75. DELETE FROM USER_STORE_copy;
    
76. DELETE FROM USER_STORE_SECEDE;
    
77. DELETE FROM user_suit
    - M* e  Y3 g! H: H: S8 R/ ~- s9 {
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    " w. z! q8 J+ f: n, U
79. DELETE FROM user_suit_copy;
    
80. DELETE FROM user_suit_secede;
    
81. GO

复制代码

  M/ p4 A5 I# q. L. S7 e6 s

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

大张 发表于 2024-10-16 14:56
8 ]. Z7 z, x& P- W. N语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~！

) S4 z* d2 d# L. P( F; o4 i: o+ f帖子里面有复制功能