数据库清档SQL语句

admin

1. 
   6 }# q7 j5 r) j
2. 
   
3. use account;
   
4. DELETE FROM C_IP_BAN;
   
5. DELETE FROM C_IP_PERMIT;
     i  m: [, D: j0 M
6. DELETE FROM C_IP_PWD;
   # `* D/ z+ [: K7 u. _# ~
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   
8. DELETE FROM C_SEQUENCE;
   3 n4 t2 P1 T# r  q% g% H* f8 L
9. DELETE FROM CP_USER_PROFILE;
     H* s' B; K, o  x
10. DELETE FROM MB_USR_IP;
    
11. DELETE FROM MB_USR_PUN;
    " W% J) j% W3 J  h1 {) g
12. DELETE FROM Tbl_user;
    3 |0 g( V- h0 b, K1 E- g3 D
13. DELETE FROM USER_CONNLOG_KEY;
    
14. DELETE FROM USER_PROFILE;
    $ t) i2 j/ e' Q
15. GO
    ! Z/ G) Z& b5 c; B8 _- d: Q
16. use billing;
    
17. DELETE FROM bl_error_log;
    
18. DELETE FROM c_sequence;
    - U% {: r& k9 M5 C
19. DELETE FROM dba_online_daily;
    
20. DELETE FROM dba_online_daily_notok;
    
21. DELETE FROM Tbl_KeepId;
    
22. DELETE FROM user_account;
    * p; d" L4 Y8 l, ~, C- r% {& A
23. DELETE FROM user_account;
    
24. DELETE FROM user_charge_log;
    
25. DELETE FROM user_everyday_use_info;
    ( u% Q# O3 u6 D( S! ]
26. DELETE FROM user_give_log;
    
27. DELETE FROM user_use_log;
    
28. DELETE FROM user_use_log_bk;
    2 \2 b! d5 v6 m# E* T$ ]1 s- Q$ g
29. GO
    
30. use cash;
    
31. DELETE FROM bl_error_log;
      I. H2 x3 w6 c- K
32. DELETE FROM Tbl_Cash_zj;
    
33. DELETE FROM user_cash;
    
34. DELETE FROM user_charge_log;
    
35. DELETE FROM user_use_log;
    9 @3 C7 w8 ]8 s: L/ a
36. GO
    9 F1 H4 a7 L$ x. m3 c+ J( C$ _
37. use character;
    - V- m% a0 v, D% K$ ^( r; d  D- p
38. DELETE FROM C_EVENT_ITEM_OP
    
39. DELETE FROM c_restword;
    % b; ?% {# |& C) X% t% b% h
40. DELETE FROM char_connlog;
    9 @* u) M- s) V( ~- B
41. DELETE FROM CHAR_CONNLOG_KEY;
    
42. DELETE FROM DEL_USER_CHAR_LIST;
    
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    2 y  g5 R* j  c7 n: S6 `7 u1 V
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;
    / i9 G' c: b) s- m+ g
49. DELETE FROM GUILD_PEERAGE
    
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    + L5 H( ]+ C$ J2 W' A8 L
51. DELETE FROM MSSNGR_CHAR_LIST;
    2 T, V4 D" J3 }6 p
52. DELETE FROM SIEGE_INFO;
    
53. DELETE FROM SIEGE_RESULT_LOG;
    
54. DELETE FROM user_bag
    
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    " P% a) u5 |% R3 t0 G* T# l
56. DELETE FROM user_bag_copy;
    % \( K! @1 x: B+ K2 F7 L% L
57. DELETE FROM user_bag_secede;
    3 J) m  [. I+ [3 J& @5 h- g
58. DELETE FROM user_character
    
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    ( E% I/ f8 Y' o/ z
60. DELETE FROM user_character_secede;
    
61. DELETE FROM USER_POSTBOX;
    0 l( x% n! ?, E3 m
62. DELETE FROM USER_POSTBOX_SECEDE;
      n4 ~, |4 ^& c8 p8 o$ R1 }# ?
63. DELETE FROM User_Quest_Doing;
    
64. DELETE FROM user_quest_doing_secede;
    
65. DELETE FROM User_Quest_Done;
    
66. DELETE FROM user_quest_done_secede;
    ; G, O; G. o7 p% H# B0 q) `
67. DELETE FROM user_skill
    
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    
69. DELETE FROM user_skill_secede
    + p! E. h+ n7 Z+ A! O5 j
70. DELETE FROM user_slot
    5 P5 q8 q* S) D9 {9 ?& O2 H) m+ `
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    
72. DELETE FROM user_storage;
    : C* U9 k3 g/ s8 ~, d
73. DELETE FROM user_storage_copy;
    
74. DELETE FROM USER_STORE;
    ! f" b4 V- m: E) ?0 r8 s$ [
75. DELETE FROM USER_STORE_copy;
    8 j% [7 U1 C9 k
76. DELETE FROM USER_STORE_SECEDE;
    
77. DELETE FROM user_suit
    3 U: t' P3 {% I! T$ d0 G9 i! {: y
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    
79. DELETE FROM user_suit_copy;
    " s* I0 e' C: [# k) \
80. DELETE FROM user_suit_secede;
    ) e' O% }. e+ Z4 s
81. GO

复制代码

# x" W9 M0 z4 s* u% K6 o  L

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

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

帖子里面有复制功能