数据库清档SQL语句

admin

1. 
   
2. 
   . X7 Z: @1 t  y, S2 H  V. d0 |
3. use account;
   3 ?. G( d9 c# |: `3 j
4. DELETE FROM C_IP_BAN;
   9 P( Y- d% W- b7 G$ ]) r6 x
5. DELETE FROM C_IP_PERMIT;
   + \* o* K/ R$ C3 j/ Z% E+ J
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;
    
12. DELETE FROM Tbl_user;
    
13. DELETE FROM USER_CONNLOG_KEY;
    / p) g* I, T- d1 |, H% Y& z* Q
14. DELETE FROM USER_PROFILE;
    - {) }% [: e/ n) {  V1 _' w
15. GO
    
16. use billing;
    
17. DELETE FROM bl_error_log;
    
18. DELETE FROM c_sequence;
    ( E' l/ f$ c* J7 I6 \9 @
19. DELETE FROM dba_online_daily;
    . |9 y, [( y0 Z) v# w3 e2 q5 U
20. DELETE FROM dba_online_daily_notok;
    " [4 e  E( Z+ K9 f0 k
21. DELETE FROM Tbl_KeepId;
    
22. DELETE FROM user_account;
    % K6 Z: q7 n2 q9 ?8 N, U0 n
23. DELETE FROM user_account;
    & j3 K2 e; _* Z  ~8 B
24. DELETE FROM user_charge_log;
    
25. DELETE FROM user_everyday_use_info;
    ' @2 m- k+ ?4 \/ \8 b# A: W# C
26. DELETE FROM user_give_log;
    
27. DELETE FROM user_use_log;
    & Z& S  e" S3 ?. Q
28. DELETE FROM user_use_log_bk;
    ) O! {9 M' t2 ~5 T# |
29. GO
    8 h& Y! s$ Q' ~; g( ?8 B7 z
30. use cash;
    ! g7 x8 I& b. M  `9 c2 r9 H
31. DELETE FROM bl_error_log;
    " n/ t1 C- {7 ]! U
32. DELETE FROM Tbl_Cash_zj;
    8 h. D, |. m6 Y7 o7 }! r
33. DELETE FROM user_cash;
    
34. DELETE FROM user_charge_log;
    ) ]' o  _1 [  |- V6 y
35. DELETE FROM user_use_log;
    
36. GO
    
37. use character;
    
38. DELETE FROM C_EVENT_ITEM_OP
    ; B+ ?( t7 j' n9 A6 G
39. DELETE FROM c_restword;
    
40. DELETE FROM char_connlog;
    / A- `  m" J7 k
41. DELETE FROM CHAR_CONNLOG_KEY;
    + K3 N0 y6 p3 W4 c
42. DELETE FROM DEL_USER_CHAR_LIST;
    
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    4 s5 _, w0 T4 q, ]9 ^. Q
44. DELETE FROM GM_ITEM_MST;
    0 S: e: ?  ^9 z& ?5 Y
45. DELETE FROM GUILD_CHAR_INFO;
    9 \7 q  e- v( [9 }
46. DELETE FROM GUILD_INFO
    
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    3 F7 j: U7 {: ~5 Y9 \% s1 c; N
48. DELETE FROM GUILD_INFO_SECEDE;
    
49. DELETE FROM GUILD_PEERAGE
    . `; o# b" x% K2 m( _6 l2 a$ r
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    # d/ Y# J. V5 U. w
51. DELETE FROM MSSNGR_CHAR_LIST;
    
52. DELETE FROM SIEGE_INFO;
    4 Y3 ~! e& g- E
53. DELETE FROM SIEGE_RESULT_LOG;
    , A3 L5 G$ S& i# j
54. DELETE FROM user_bag
    $ m* ^% X& _* O# K
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    % [' [1 V' H/ Q, p2 h, n# e0 k& c
56. DELETE FROM user_bag_copy;
    
57. DELETE FROM user_bag_secede;
    $ ?/ c1 {0 ~" g0 i( H" G" x9 A
58. DELETE FROM user_character
    % ^& R6 K3 v" c& y& y" Y
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    
60. DELETE FROM user_character_secede;
    , D; N" Q; K) u1 |
61. DELETE FROM USER_POSTBOX;
    3 _8 m5 \6 D4 ~% u3 n- Y( I5 Z  n! }
62. DELETE FROM USER_POSTBOX_SECEDE;
    
63. DELETE FROM User_Quest_Doing;
    $ K* ]8 _/ D7 M4 T% O, x) L# {
64. DELETE FROM user_quest_doing_secede;
    
65. DELETE FROM User_Quest_Done;
    
66. DELETE FROM user_quest_done_secede;
    ; l% [  r9 B- A+ j4 E3 x, c8 S
67. DELETE FROM user_skill
    3 G' b4 X9 D6 g% ?
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    0 ~6 u4 V- M( b1 G  p' V+ S
69. DELETE FROM user_skill_secede
    
70. DELETE FROM user_slot
    ( q$ M! |4 |# S  w
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    
72. DELETE FROM user_storage;
    
73. DELETE FROM user_storage_copy;
    
74. DELETE FROM USER_STORE;
    
75. DELETE FROM USER_STORE_copy;
    
76. DELETE FROM USER_STORE_SECEDE;
    
77. DELETE FROM user_suit
    $ B# J+ z0 T3 U  ?3 d1 m
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    
79. DELETE FROM user_suit_copy;
    ) w3 R# @+ H) L, n
80. DELETE FROM user_suit_secede;
    + v8 ?6 O5 C( g; N- D8 F  i
81. GO

复制代码

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

大张 发表于 2024-10-16 14:56
) p; H& z: G% V9 V6 s6 s! K语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~！

, I% x3 O" v% q1 S, A: z帖子里面有复制功能