数据库清档SQL语句

admin

1. 
   , `7 h; U  u0 ~1 U7 f% }! H, j. ]6 a; d
2. 
   
3. use account;
   
4. DELETE FROM C_IP_BAN;
   : _+ Y# n6 r& \- R: ^4 i. d: H
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;
    
11. DELETE FROM MB_USR_PUN;
    & a7 C9 Q7 i" G9 f4 {$ F1 ]; M
12. DELETE FROM Tbl_user;
    
13. DELETE FROM USER_CONNLOG_KEY;
    
14. DELETE FROM USER_PROFILE;
    
15. GO
    
16. use billing;
    
17. DELETE FROM bl_error_log;
    5 r$ T2 F3 s# \6 M+ t  x4 ]
18. DELETE FROM c_sequence;
    
19. DELETE FROM dba_online_daily;
    
20. DELETE FROM dba_online_daily_notok;
    0 R6 v3 [; n! l5 E6 t
21. DELETE FROM Tbl_KeepId;
    ) k& X* l6 Q" x. [$ c; H
22. DELETE FROM user_account;
    
23. DELETE FROM user_account;
    6 d9 c) z: v; W( u) |$ |, y
24. DELETE FROM user_charge_log;
    8 P2 }3 {5 Z! l
25. DELETE FROM user_everyday_use_info;
    ; V. R3 @! ^& w- W$ q
26. DELETE FROM user_give_log;
    : o% Q9 N' i6 L/ N* ?# Q6 l$ c0 ~
27. DELETE FROM user_use_log;
    
28. DELETE FROM user_use_log_bk;
    8 C; i) v: Y# [1 r9 n0 [, ?% c8 M! ?- P
29. GO
    
30. use cash;
    7 x4 N1 Z6 J' z: p, S
31. DELETE FROM bl_error_log;
    
32. DELETE FROM Tbl_Cash_zj;
    8 c6 q# S# [7 g- G
33. DELETE FROM user_cash;
    . f! R) }: Z; C" R  h# F& G; K
34. DELETE FROM user_charge_log;
    
35. DELETE FROM user_use_log;
      d  Z' F) k6 P* U
36. GO
    
37. use character;
    
38. DELETE FROM C_EVENT_ITEM_OP
    
39. DELETE FROM c_restword;
    
40. DELETE FROM char_connlog;
    
41. DELETE FROM CHAR_CONNLOG_KEY;
    
42. DELETE FROM DEL_USER_CHAR_LIST;
    . e; M/ a! a7 `
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    
44. DELETE FROM GM_ITEM_MST;
    
45. DELETE FROM GUILD_CHAR_INFO;
    . e. s8 Z& Q4 a# R* A2 m- Q0 K3 b* I& c
46. DELETE FROM GUILD_INFO
    5 v; z/ s' {$ w& b
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    / U0 z- s, u  k' H* b( a& L
48. DELETE FROM GUILD_INFO_SECEDE;
    7 M1 a; N% H1 P# u# F9 D
49. DELETE FROM GUILD_PEERAGE
    5 ^1 h0 L$ z' b& y" M" m
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    . d% f" z5 \* t, x4 M4 g
51. DELETE FROM MSSNGR_CHAR_LIST;
    
52. DELETE FROM SIEGE_INFO;
    
53. DELETE FROM SIEGE_RESULT_LOG;
    
54. DELETE FROM user_bag
    
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    7 F+ ]" `2 I) i9 o
56. DELETE FROM user_bag_copy;
    
57. DELETE FROM user_bag_secede;
    
58. DELETE FROM user_character
    6 ^2 M) i" n7 H# K3 b2 N
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    
60. DELETE FROM user_character_secede;
    
61. DELETE FROM USER_POSTBOX;
    2 J- M% R+ r+ b- S
62. DELETE FROM USER_POSTBOX_SECEDE;
    8 s, F  `: @& v0 W' e
63. DELETE FROM User_Quest_Doing;
    7 }1 S+ ~7 e7 A
64. DELETE FROM user_quest_doing_secede;
    $ |: J3 P8 @. F* a! S! _& U* j
65. DELETE FROM User_Quest_Done;
    
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
    2 T0 q2 v1 K% a; }) g
70. DELETE FROM user_slot
    + x3 ?9 h2 f' B  @
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    
72. DELETE FROM user_storage;
    
73. DELETE FROM user_storage_copy;
    0 ]9 k, e2 u, i+ ~3 Y
74. DELETE FROM USER_STORE;
    
75. DELETE FROM USER_STORE_copy;
    ! B& T6 K# c1 N. @. h/ g8 S
76. DELETE FROM USER_STORE_SECEDE;
    4 b2 r+ ^% w1 E% }6 n2 d+ o
77. DELETE FROM user_suit
    
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    ( W5 z- l) a1 \& F
79. DELETE FROM user_suit_copy;
    0 I) V  O7 ~$ N5 z
80. DELETE FROM user_suit_secede;
    
81. GO

复制代码

2 C8 x2 G# i! `  U$ Y8 q& t/ a

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

大张 发表于 2024-10-16 14:56
! W' s) N+ o8 ]' h" |% T语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~！

. q; J- N3 p! _/ U帖子里面有复制功能