数据库清档SQL语句

admin

1. 
   
2. 
   
3. use account;
   : U" L7 R. {" t' u8 R
4. DELETE FROM C_IP_BAN;
   
5. DELETE FROM C_IP_PERMIT;
   % m7 R7 ^4 h- O  P: ?
6. DELETE FROM C_IP_PWD;
   
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   
8. DELETE FROM C_SEQUENCE;
   
9. DELETE FROM CP_USER_PROFILE;
   1 F* `& v+ k1 W/ n1 y
10. DELETE FROM MB_USR_IP;
    1 t, ^. d) j) C
11. DELETE FROM MB_USR_PUN;
    $ q1 Q7 Y3 V* S7 K6 f) Q; L
12. DELETE FROM Tbl_user;
    
13. DELETE FROM USER_CONNLOG_KEY;
    5 e$ k3 p, f* E6 U* n4 G5 E
14. DELETE FROM USER_PROFILE;
    
15. GO
    . m. ]  a% D, r4 N0 T
16. use billing;
    
17. DELETE FROM bl_error_log;
    
18. DELETE FROM c_sequence;
    ; Q1 F; x+ X2 Q/ l8 x
19. DELETE FROM dba_online_daily;
    
20. DELETE FROM dba_online_daily_notok;
    
21. DELETE FROM Tbl_KeepId;
    . a: w# ^: P6 ^. F" M1 ?$ W% }
22. DELETE FROM user_account;
    
23. DELETE FROM user_account;
    , h4 O) n7 D* T( |0 M/ `
24. DELETE FROM user_charge_log;
    
25. DELETE FROM user_everyday_use_info;
    
26. DELETE FROM user_give_log;
    
27. DELETE FROM user_use_log;
    * X& G, b) a6 Z
28. DELETE FROM user_use_log_bk;
    ; X% S) B* w5 J# G) ^3 r1 ]
29. GO
    ! q# g! ]1 `: p- X7 y
30. use cash;
    
31. DELETE FROM bl_error_log;
    ; C% U9 D% M7 x% d. o
32. DELETE FROM Tbl_Cash_zj;
    
33. DELETE FROM user_cash;
    + K1 \; c) M- s3 }& ~# @
34. DELETE FROM user_charge_log;
    & d8 g& G( F6 [5 x
35. DELETE FROM user_use_log;
    ' M$ G3 L* l7 v: \7 y
36. GO
    : ^4 ]8 R7 j1 r  m8 s3 t
37. use character;
    ( I/ }7 v! u0 M- o  J. \) C, i5 m& V
38. DELETE FROM C_EVENT_ITEM_OP
    5 K' V* ?/ n" C9 F) \+ r9 N6 Z: M
39. DELETE FROM c_restword;
    % Y2 ]- W* D6 Y# q1 W/ o
40. DELETE FROM char_connlog;
    
41. DELETE FROM CHAR_CONNLOG_KEY;
    
42. DELETE FROM DEL_USER_CHAR_LIST;
    1 O5 |  H  ^3 K8 V! J9 w3 o/ e
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    ! l" K+ H9 t" w
44. DELETE FROM GM_ITEM_MST;
    
45. DELETE FROM GUILD_CHAR_INFO;
    
46. DELETE FROM GUILD_INFO
    
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    2 y8 x; _4 Y0 E6 j
48. DELETE FROM GUILD_INFO_SECEDE;
    3 p' l* U+ j" n1 ^5 z
49. DELETE FROM GUILD_PEERAGE
    ' @$ [7 b3 P$ x6 D2 c0 {
50. WHERE guild_code NOT LIKE 'MASTERCODE';
      y& \6 ^% @0 L0 g8 V5 H7 y) J
51. DELETE FROM MSSNGR_CHAR_LIST;
    ( K6 e( [& X  x3 R5 |2 H
52. DELETE FROM SIEGE_INFO;
    ' h5 U; E% }9 `
53. DELETE FROM SIEGE_RESULT_LOG;
    
54. DELETE FROM user_bag
    ; u1 u7 y0 R" e
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    7 D$ b: b( I4 h. e6 O' c
56. DELETE FROM user_bag_copy;
    
57. DELETE FROM user_bag_secede;
    . C$ a# O2 ]8 O& M  n  e5 u" `
58. DELETE FROM user_character
    
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    * a$ ?& c2 t) v7 U( V  i
60. DELETE FROM user_character_secede;
    
61. DELETE FROM USER_POSTBOX;
    
62. DELETE FROM USER_POSTBOX_SECEDE;
    
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;
    ) [1 o  l3 ^' ]# _" s0 S- K
67. DELETE FROM user_skill
      |9 y5 e4 c: _
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    
69. DELETE FROM user_skill_secede
    - L, \- O$ a& A9 ~4 l$ ?. T- v
70. DELETE FROM user_slot
    / l: c+ S) x! N) z/ r- @7 |1 l
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    
72. DELETE FROM user_storage;
    0 L( Z. j0 S( q" Q- d! i
73. DELETE FROM user_storage_copy;
    
74. DELETE FROM USER_STORE;
    3 k1 q" x# ?4 i3 F/ ^8 _5 U  @
75. DELETE FROM USER_STORE_copy;
    
76. DELETE FROM USER_STORE_SECEDE;
    . C+ r8 C: c% o/ I' ~4 G+ L, y
77. DELETE FROM user_suit
    / Z3 ?& f* a" I5 A: A3 c
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    * {: a) X  Q" f' J- X% h
79. DELETE FROM user_suit_copy;
    
80. DELETE FROM user_suit_secede;
    , Q" ^8 J, b, d, Z
81. GO

复制代码

9 i' s2 P6 J; g) M, V" H- H+ A
7 b. @! x/ [: O

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

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

6 {9 k7 U( {8 M; l% I9 A帖子里面有复制功能