数据库清档SQL语句

admin

1. 
   
2. 
   
3. use account;
   
4. DELETE FROM C_IP_BAN;
   : w' e1 {* _: u, }/ y
5. DELETE FROM C_IP_PERMIT;
   / D* q  J* |, `
6. DELETE FROM C_IP_PWD;
   
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   * C% Q# |+ a2 Z' Z- l4 r
8. DELETE FROM C_SEQUENCE;
   ! d5 O% J, c5 J2 P
9. DELETE FROM CP_USER_PROFILE;
   ; N3 d0 K! j, B
10. DELETE FROM MB_USR_IP;
    . `: e3 X$ ^- c& r/ e# V
11. DELETE FROM MB_USR_PUN;
    0 n1 \, I8 D8 ^- u0 a
12. DELETE FROM Tbl_user;
    , i9 g. l) c. o4 U& O. S
13. DELETE FROM USER_CONNLOG_KEY;
    
14. DELETE FROM USER_PROFILE;
    
15. GO
    
16. use billing;
      k, R% o) s! x8 Y
17. DELETE FROM bl_error_log;
    1 O4 i$ B0 o: \! ^$ T
18. DELETE FROM c_sequence;
    0 \/ W+ q& k* n
19. DELETE FROM dba_online_daily;
    
20. DELETE FROM dba_online_daily_notok;
    
21. DELETE FROM Tbl_KeepId;
    6 \" O" D1 u- }) A
22. DELETE FROM user_account;
    ! `8 Z. P0 Z4 h: P
23. DELETE FROM user_account;
    5 R0 e' g9 q7 x1 I
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;
    $ y% E. d" S+ q7 A! ?' d9 K- |
28. DELETE FROM user_use_log_bk;
    
29. GO
    
30. use cash;
    ! E" `; j5 y& I* [: t
31. DELETE FROM bl_error_log;
    
32. DELETE FROM Tbl_Cash_zj;
    
33. DELETE FROM user_cash;
    0 O2 L% Z7 F: @( u6 Z+ ^/ w
34. DELETE FROM user_charge_log;
    ) [. f: A9 _$ p& |" u2 ]; K# K  S
35. DELETE FROM user_use_log;
    9 ?. ^7 M- O/ \  c4 F! B
36. GO
    6 x( U2 {# O$ s4 g2 J/ Z
37. use character;
    
38. DELETE FROM C_EVENT_ITEM_OP
    
39. DELETE FROM c_restword;
    % Q% C6 H6 S# k
40. DELETE FROM char_connlog;
    
41. DELETE FROM CHAR_CONNLOG_KEY;
    
42. DELETE FROM DEL_USER_CHAR_LIST;
    * y9 \6 d4 q/ p& V% w
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    
44. DELETE FROM GM_ITEM_MST;
    # H+ h4 O+ M/ h* a
45. DELETE FROM GUILD_CHAR_INFO;
    % \; q( w5 L4 Q
46. DELETE FROM GUILD_INFO
    * U! T! k  F( \' o
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    1 k, [. f2 h$ M9 |# Q4 c
48. DELETE FROM GUILD_INFO_SECEDE;
    
49. DELETE FROM GUILD_PEERAGE
    
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    
51. DELETE FROM MSSNGR_CHAR_LIST;
    * V; {2 j6 @8 O& v- v, c/ h
52. DELETE FROM SIEGE_INFO;
    
53. DELETE FROM SIEGE_RESULT_LOG;
    % [' P) U* ^' k' M
54. DELETE FROM user_bag
    
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    
56. DELETE FROM user_bag_copy;
    
57. DELETE FROM user_bag_secede;
    
58. DELETE FROM user_character
      h4 `) k, g0 ?% h+ r! f- a
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    
60. DELETE FROM user_character_secede;
    6 p5 Z5 G! X) R- l; R; ^
61. DELETE FROM USER_POSTBOX;
    
62. DELETE FROM USER_POSTBOX_SECEDE;
    / |, {9 U9 y( y
63. DELETE FROM User_Quest_Doing;
    : |4 L* W6 w, H- }5 u& g
64. DELETE FROM user_quest_doing_secede;
    3 I- M8 O/ ?0 S; u, ?4 K  d
65. DELETE FROM User_Quest_Done;
    
66. DELETE FROM user_quest_done_secede;
    ) e' E5 n. p! f/ u) u- C
67. DELETE FROM user_skill
    
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    
69. DELETE FROM user_skill_secede
    ) v, O8 p% C1 z
70. DELETE FROM user_slot
    
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    " y2 A( u6 g5 _& Q( W
72. DELETE FROM user_storage;
    : j( i4 T2 W8 o" x+ P$ K& v
73. DELETE FROM user_storage_copy;
    
74. DELETE FROM USER_STORE;
    
75. DELETE FROM USER_STORE_copy;
    0 ^$ |3 ?$ ?( h
76. DELETE FROM USER_STORE_SECEDE;
    $ }3 U' i  ^# H3 L3 Q8 |
77. DELETE FROM user_suit
    
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    / K; c* @* c. o" E5 V
79. DELETE FROM user_suit_copy;
    3 C' Y; k6 c+ N- z
80. DELETE FROM user_suit_secede;
    
81. GO

复制代码

$ _; n6 n' t  T7 H+ _
3 d2 E  z/ k7 x7 P/ \+ [0 T6 p

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

大张 发表于 2024-10-16 14:56
$ y3 Y2 Z, ^4 R4 l' P语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~！

, P3 @$ p, f, A+ T3 k" N帖子里面有复制功能