数据库清档SQL语句

admin

1. 
   
2. 
   ) A! |% v7 r; w% V8 O2 Y  j% w
3. use account;
   & Z- Z6 n" F. h( h
4. DELETE FROM C_IP_BAN;
   3 m' @" i$ `  U4 Y4 a9 h  G
5. DELETE FROM C_IP_PERMIT;
   * X0 X" o) L- j+ l* U% A
6. DELETE FROM C_IP_PWD;
   
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   
8. DELETE FROM C_SEQUENCE;
   
9. DELETE FROM CP_USER_PROFILE;
   7 }% i& K1 P5 |4 I3 `, t7 S! c
10. DELETE FROM MB_USR_IP;
    
11. DELETE FROM MB_USR_PUN;
    , m2 A9 I) f- j6 ]: O
12. DELETE FROM Tbl_user;
    
13. DELETE FROM USER_CONNLOG_KEY;
    
14. DELETE FROM USER_PROFILE;
    
15. GO
    1 R1 ~; {! ]/ H! F. N: a
16. use billing;
    
17. DELETE FROM bl_error_log;
    
18. DELETE FROM c_sequence;
    2 T# D* s$ A: ^5 A# n! e/ Z( H
19. DELETE FROM dba_online_daily;
    
20. DELETE FROM dba_online_daily_notok;
    ! J- l' o' K/ B
21. DELETE FROM Tbl_KeepId;
    ! U4 s- q+ O( c, x
22. DELETE FROM user_account;
    3 _; v0 L7 i; D) W5 H! @
23. DELETE FROM user_account;
    
24. DELETE FROM user_charge_log;
    
25. DELETE FROM user_everyday_use_info;
    , x( u+ q" k6 R
26. DELETE FROM user_give_log;
    
27. DELETE FROM user_use_log;
    ! C/ a- v" ]0 R" g
28. DELETE FROM user_use_log_bk;
    6 {( [/ k! ?# T. j6 h
29. GO
    ( J0 i; [# v* A1 \
30. use cash;
    
31. DELETE FROM bl_error_log;
    
32. DELETE FROM Tbl_Cash_zj;
    
33. DELETE FROM user_cash;
    
34. DELETE FROM user_charge_log;
    8 ]( u' s, C8 R! n$ z  K
35. DELETE FROM user_use_log;
    
36. GO
    
37. use character;
    # n; P" k( t2 I' E& ~$ u0 }. n
38. DELETE FROM C_EVENT_ITEM_OP
    / Z! ^3 N6 l  o- Y5 U/ f
39. DELETE FROM c_restword;
    
40. DELETE FROM char_connlog;
    ( w& {" d' [, W) E0 f0 _) E. v
41. DELETE FROM CHAR_CONNLOG_KEY;
    
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;
    
46. DELETE FROM GUILD_INFO
    " b8 B) \4 e* z  Q7 t) M
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    ) h) u% _# P/ q1 e' f
48. DELETE FROM GUILD_INFO_SECEDE;
    
49. DELETE FROM GUILD_PEERAGE
    
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    
51. DELETE FROM MSSNGR_CHAR_LIST;
    2 D) z5 \. }8 X: n( V( \
52. DELETE FROM SIEGE_INFO;
    
53. DELETE FROM SIEGE_RESULT_LOG;
    
54. DELETE FROM user_bag
    # a! E; }* t6 k1 s2 i
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    
56. DELETE FROM user_bag_copy;
    
57. DELETE FROM user_bag_secede;
    ) E0 U) K1 [/ Z: |9 Y2 B7 r
58. DELETE FROM user_character
    # I: [$ S# g7 v3 A- i
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    
60. DELETE FROM user_character_secede;
    
61. DELETE FROM USER_POSTBOX;
    
62. DELETE FROM USER_POSTBOX_SECEDE;
    
63. DELETE FROM User_Quest_Doing;
    8 i! w* @; H7 ]( w" b
64. DELETE FROM user_quest_doing_secede;
    
65. DELETE FROM User_Quest_Done;
    * i' F) H# X: e
66. DELETE FROM user_quest_done_secede;
    . g+ h; Y7 Y8 [. y: u4 h. X. g
67. DELETE FROM user_skill
    
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    7 [7 l7 @+ m. [" {& E
69. DELETE FROM user_skill_secede
    
70. DELETE FROM user_slot
    9 R# s$ x& ~' T: S/ G) s
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    : F- b7 I9 v* _& U) a- W1 W! g
72. DELETE FROM user_storage;
    
73. DELETE FROM user_storage_copy;
    9 d3 W' R0 [0 w8 D0 W3 t
74. DELETE FROM USER_STORE;
    
75. DELETE FROM USER_STORE_copy;
    $ G3 O2 e2 ?5 q* r! H8 P
76. DELETE FROM USER_STORE_SECEDE;
    
77. DELETE FROM user_suit
    , J5 W/ [3 a+ |! R7 U6 P4 [' p
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    
79. DELETE FROM user_suit_copy;
    ( Q' h& S/ C) J
80. DELETE FROM user_suit_secede;
    . D1 h8 }' D/ I/ c5 \& q
81. GO

复制代码

# W/ [9 }1 h8 Y1 n, @; O
: k6 Q7 B) a; G7 g3 R1 g6 ?' `

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

大张 发表于 2024-10-16 14:56
0 {$ c2 c' \& L% z, D语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~！

帖子里面有复制功能