数据库清档SQL语句

admin

1. 
   ! k, J$ H1 I/ b- ~3 b8 J( o- |
2. 
   # K* b! z* P( d* m
3. use account;
   / f1 o1 [2 Q# {* {4 s1 r" C
4. DELETE FROM C_IP_BAN;
   7 w) ?7 o- S$ C' |# n
5. DELETE FROM C_IP_PERMIT;
   
6. DELETE FROM C_IP_PWD;
   
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   
8. DELETE FROM C_SEQUENCE;
   
9. DELETE FROM CP_USER_PROFILE;
   
10. DELETE FROM MB_USR_IP;
    6 E. Z, h" e0 l: y. V
11. DELETE FROM MB_USR_PUN;
    4 t* t5 w  L& a1 K) i
12. DELETE FROM Tbl_user;
    " n. _1 h+ i' \# f' B% A* A
13. DELETE FROM USER_CONNLOG_KEY;
    2 j: l3 T, r# C* P# u$ u) S' ^
14. DELETE FROM USER_PROFILE;
    
15. GO
    
16. use billing;
    
17. DELETE FROM bl_error_log;
    ) z7 s: [& D4 i
18. DELETE FROM c_sequence;
    * R; a. B* @/ F* ^. r8 l
19. DELETE FROM dba_online_daily;
    
20. DELETE FROM dba_online_daily_notok;
    % O" @- ]" d' C9 Z7 D
21. DELETE FROM Tbl_KeepId;
    ) _/ C$ R* F+ m: ]* g1 J9 \( `
22. DELETE FROM user_account;
    * S+ x4 J+ H9 H0 @' D
23. DELETE FROM user_account;
    
24. DELETE FROM user_charge_log;
    & L3 j3 g% G2 D
25. DELETE FROM user_everyday_use_info;
    + D( u1 Y$ W9 B
26. DELETE FROM user_give_log;
    4 }& [3 G1 x4 \) m5 \9 K
27. DELETE FROM user_use_log;
    
28. DELETE FROM user_use_log_bk;
    - v8 S. j9 e9 ]) G( E" q0 I. p
29. GO
    + h" U% ]" K; O6 L
30. use cash;
    0 |6 I  D( A* n# y# R
31. DELETE FROM bl_error_log;
    1 c4 i  M" S  B
32. DELETE FROM Tbl_Cash_zj;
    ( |  G8 A: G4 Z/ r
33. DELETE FROM user_cash;
    . l' X7 V' N, ~( c5 ?: M) q
34. DELETE FROM user_charge_log;
    
35. DELETE FROM user_use_log;
    
36. GO
    
37. use character;
    5 X# {8 e, q5 _. E9 F, l5 I7 X! X
38. DELETE FROM C_EVENT_ITEM_OP
    7 R) W/ n4 f$ W, q0 S" F7 W% h( A
39. DELETE FROM c_restword;
    
40. DELETE FROM char_connlog;
    + w5 y+ y- @8 U" _
41. DELETE FROM CHAR_CONNLOG_KEY;
    2 }2 [  _: e5 l8 k. G
42. DELETE FROM DEL_USER_CHAR_LIST;
    
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    
44. DELETE FROM GM_ITEM_MST;
    + X' r# a5 C9 O  s5 i. C$ n" C
45. DELETE FROM GUILD_CHAR_INFO;
    2 h4 y5 ~( a( F# M, S/ V( Z
46. DELETE FROM GUILD_INFO
    
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    ' c( D. d" P) m' U* d
48. DELETE FROM GUILD_INFO_SECEDE;
    4 ^3 l1 m/ A: O, A/ O% c' i( y
49. DELETE FROM GUILD_PEERAGE
    
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    $ ^: V0 B8 v& N" f' q& L
51. DELETE FROM MSSNGR_CHAR_LIST;
    % E3 R6 V! b. r2 ?5 z# C) v! L4 q
52. DELETE FROM SIEGE_INFO;
    % G- {$ c, I- d" m, V6 Q, T& j
53. DELETE FROM SIEGE_RESULT_LOG;
    2 J, J7 N  @+ n$ T3 ^, q
54. DELETE FROM user_bag
    
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    : D- `( ]  o# p- }  f! }' q
56. DELETE FROM user_bag_copy;
    
57. DELETE FROM user_bag_secede;
    
58. DELETE FROM user_character
    9 \0 u2 y: \; v2 s( `. L# d# R7 j3 B! i
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    & ?) F  d: o5 f" u
60. DELETE FROM user_character_secede;
    
61. DELETE FROM USER_POSTBOX;
    " \' T. k1 O+ Q
62. DELETE FROM USER_POSTBOX_SECEDE;
    + ?7 j, g& s5 K, @1 u2 y
63. DELETE FROM User_Quest_Doing;
    % w- D' c3 d  O. U9 m. r" `0 i
64. DELETE FROM user_quest_doing_secede;
    / g' Q9 Q3 X- F. e
65. DELETE FROM User_Quest_Done;
    4 M6 t0 j$ C( p/ {. l$ F
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
    0 A: `$ B1 n" [& \
71. WHERE character_no NOT LIKE 'DEKARON_000001';
      u: m+ Z% {$ m( d  `
72. DELETE FROM user_storage;
    
73. DELETE FROM user_storage_copy;
    
74. DELETE FROM USER_STORE;
    4 @* Q& p* K8 g. b* C) g* W, d
75. DELETE FROM USER_STORE_copy;
    
76. DELETE FROM USER_STORE_SECEDE;
    $ Y" E$ }! Z( z( e
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;
    ( V2 y8 g+ Y% Z4 B3 T( ~; G) T
81. GO

复制代码

6 f: r4 m9 s' h% f

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

大张 发表于 2024-10-16 14:56
- L0 e! S. e4 m1 K3 {语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~！

# f5 ?: y4 b1 z0 I7 V帖子里面有复制功能