数据库清档SQL语句

admin

1. 
   
2. 
   
3. use account;
   " {0 A, ^' E+ @$ l
4. DELETE FROM C_IP_BAN;
   ) o/ s& X" \2 m4 V1 l, g
5. DELETE FROM C_IP_PERMIT;
   . H+ F6 L1 Z' \0 m6 B2 m# P: `
6. DELETE FROM C_IP_PWD;
   6 m; K! r  p; l6 S& X7 ]
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   
8. DELETE FROM C_SEQUENCE;
   : Z. i# {* J5 r$ H! x+ ~
9. DELETE FROM CP_USER_PROFILE;
   , ~$ M7 w7 w5 \
10. DELETE FROM MB_USR_IP;
      K/ {: `; S: Z: ]4 W
11. DELETE FROM MB_USR_PUN;
    
12. DELETE FROM Tbl_user;
    * _  K/ j: _; {  ]+ J. q' _
13. DELETE FROM USER_CONNLOG_KEY;
      Z( U) y9 `6 h
14. DELETE FROM USER_PROFILE;
    
15. GO
    
16. use billing;
    ! o+ |+ }) A6 @5 r& p
17. DELETE FROM bl_error_log;
    
18. DELETE FROM c_sequence;
    
19. DELETE FROM dba_online_daily;
    
20. DELETE FROM dba_online_daily_notok;
    3 m2 n3 ~' d0 ^" B" L0 C9 `
21. DELETE FROM Tbl_KeepId;
    
22. DELETE FROM user_account;
    
23. DELETE FROM user_account;
    ; k2 ?: L* I7 y
24. DELETE FROM user_charge_log;
    
25. DELETE FROM user_everyday_use_info;
    # H5 w/ K( G7 y; {; m7 H" y+ B6 V
26. DELETE FROM user_give_log;
    
27. DELETE FROM user_use_log;
    
28. DELETE FROM user_use_log_bk;
    4 C7 w" n) |9 n7 n$ _/ J
29. GO
    1 y0 u  c( Q$ D. k* C+ ~
30. use cash;
    
31. DELETE FROM bl_error_log;
    
32. DELETE FROM Tbl_Cash_zj;
    
33. DELETE FROM user_cash;
    2 n. x% Q) U2 V8 }
34. DELETE FROM user_charge_log;
    
35. DELETE FROM user_use_log;
    6 s9 Z4 P) W/ o
36. GO
      d& H1 e: m9 x2 D
37. use character;
    9 G! U  E: ]+ ^
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;
    
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    $ m( l& ?6 {# F
44. DELETE FROM GM_ITEM_MST;
    : Q% V" u5 ~2 k$ s0 u+ G
45. DELETE FROM GUILD_CHAR_INFO;
    * c$ ^, M2 n8 H5 p) ]* y" k% c
46. DELETE FROM GUILD_INFO
    
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    9 v1 R3 |0 Y" A. R' e
48. DELETE FROM GUILD_INFO_SECEDE;
    
49. DELETE FROM GUILD_PEERAGE
    " l# P$ d5 O9 X0 l0 [- O
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    
51. DELETE FROM MSSNGR_CHAR_LIST;
    
52. DELETE FROM SIEGE_INFO;
    
53. DELETE FROM SIEGE_RESULT_LOG;
    
54. DELETE FROM user_bag
    7 ~4 y* O- h" I0 A  |
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    
56. DELETE FROM user_bag_copy;
    
57. DELETE FROM user_bag_secede;
    9 j8 ]7 _5 v" ]) x( ?" M- _
58. DELETE FROM user_character
      G+ K# `3 f5 Y
59. WHERE character_no NOT LIKE 'DEKARON_000001';
      }% D5 W$ N( |- n% M3 y
60. DELETE FROM user_character_secede;
    3 X+ _4 w, B1 ]" a9 c* z# X
61. DELETE FROM USER_POSTBOX;
    ! |' Z8 g2 Q7 e3 ?3 j
62. DELETE FROM USER_POSTBOX_SECEDE;
    $ t$ i- a! c7 V( c6 l. Y9 X8 Y
63. DELETE FROM User_Quest_Doing;
    
64. DELETE FROM user_quest_doing_secede;
    4 O/ \/ }% Y& c* x* F' x
65. DELETE FROM User_Quest_Done;
    
66. DELETE FROM user_quest_done_secede;
    * J. L$ J  w) b  B& R
67. DELETE FROM user_skill
    
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    " c" x/ D; m0 k7 T  |# a; l
69. DELETE FROM user_skill_secede
    
70. DELETE FROM user_slot
    2 C! t& ?* `: ?% R; c+ `' R
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    ; }9 C$ r: `- J3 {- ]
72. DELETE FROM user_storage;
    
73. DELETE FROM user_storage_copy;
    5 J9 n3 W5 I* D0 U* [( I& g) ~  u
74. DELETE FROM USER_STORE;
    4 l2 g( B& L1 L( a0 s
75. DELETE FROM USER_STORE_copy;
    
76. DELETE FROM USER_STORE_SECEDE;
    
77. DELETE FROM user_suit
    
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    ) O; v5 ^. {8 r! ~0 O0 |1 P/ s
79. DELETE FROM user_suit_copy;
    & ?3 j$ K5 x( h0 h5 \* C* u
80. DELETE FROM user_suit_secede;
    
81. GO

复制代码

8 h4 c* u1 j: s2 h% T# O) h& h, o; f( d

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

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

帖子里面有复制功能