找回密码
 立即注册
查看: 4793|回复: 5

[技术文章] 数据库清档SQL语句

[复制链接]

157

主题

372

回帖

7194

积分

管理员

积分
7194
金钱
2070
贡献
4595
注册时间
2023-11-3
QQ
发表于 2024-1-28 20:00:01 | 显示全部楼层 |阅读模式

  1. 3 s! o; M+ U! r3 y2 U* e7 O+ d) J
  2. 2 U4 C+ ^- u( `! L1 W( S; d
  3. use account;
    . s2 y  M0 {9 X. b" e
  4. DELETE FROM C_IP_BAN;
    & O4 f3 M' J1 b
  5. DELETE FROM C_IP_PERMIT;
    % X: {7 G/ }2 Q/ b1 k  U- U& i
  6. DELETE FROM C_IP_PWD;- u4 X* [8 |) S8 m  o* w
  7. DELETE FROM C_LOGINIPBLOCK_LOG;
    + l; M  U! T9 J! B
  8. DELETE FROM C_SEQUENCE;
    6 m; {1 F6 I$ n
  9. DELETE FROM CP_USER_PROFILE;
    . d% @. P$ U8 X# l
  10. DELETE FROM MB_USR_IP;
    5 p6 K% ~: ]' t
  11. DELETE FROM MB_USR_PUN;( @# K/ @+ [) }" n6 G4 S
  12. DELETE FROM Tbl_user;- w0 _: J- @5 Y/ ^* C
  13. DELETE FROM USER_CONNLOG_KEY;7 b" F4 s. f4 _8 E8 s  N
  14. DELETE FROM USER_PROFILE;5 S9 a* _; P4 R& e/ w
  15. GO
    - |( k. Z, S) Y+ Q' l! s
  16. use billing;6 A* V0 k& D. Y* C7 e
  17. DELETE FROM bl_error_log;
    $ G( F( l) n: m* v7 }3 s: i
  18. DELETE FROM c_sequence;5 O, Z/ @2 L( A9 _  |  o5 v
  19. DELETE FROM dba_online_daily;
    4 D. S. ]6 i- A, O, O9 X& Q% {2 p
  20. DELETE FROM dba_online_daily_notok;6 H2 M2 |! L* n( e' e
  21. DELETE FROM Tbl_KeepId;
    9 ], y1 p8 z  n$ u5 ^
  22. DELETE FROM user_account;4 [& q3 V  ~* s7 v
  23. DELETE FROM user_account;% V( e" ?7 C$ }8 I- W/ t
  24. DELETE FROM user_charge_log;
    8 ]* t2 X! o7 P) h
  25. DELETE FROM user_everyday_use_info;  T" ]/ _1 M! E$ q6 ]
  26. DELETE FROM user_give_log;1 x, b. V' R' c8 ^$ D$ ^
  27. DELETE FROM user_use_log;; s7 m6 ]1 C/ D+ ]. D- K1 a
  28. DELETE FROM user_use_log_bk;
    8 N* V' R) J, S$ T
  29. GO
    0 U0 U; D; O# }; A% Y
  30. use cash;
    ! H. n9 ?3 {4 \1 z+ t6 U# y
  31. DELETE FROM bl_error_log;
    2 l* k( z( U- [0 [# k0 x
  32. DELETE FROM Tbl_Cash_zj;
    ' \) ~# f, s) `# @+ ~0 y2 k
  33. DELETE FROM user_cash;7 V3 J" t5 R' k8 z6 f  c
  34. DELETE FROM user_charge_log;
    % T4 T8 n4 V. g. K0 ~* [
  35. DELETE FROM user_use_log;8 j7 x+ y" B3 g3 B) ~- o7 ]$ X
  36. GO
    4 ~) B) }( y4 Y
  37. use character;
    + v% D0 f9 n) A5 L0 p
  38. DELETE FROM C_EVENT_ITEM_OP
    + S% @  O6 C, X$ Y& C
  39. DELETE FROM c_restword;2 O4 m- A% O) B+ r6 F
  40. DELETE FROM char_connlog;6 F+ \1 w+ h* d! `9 L3 \
  41. DELETE FROM CHAR_CONNLOG_KEY;
    ' I1 V  E8 J- o( q* R$ j
  42. DELETE FROM DEL_USER_CHAR_LIST;
    & U) H5 n5 {! U/ |
  43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
      c$ r  _" A- }# D
  44. DELETE FROM GM_ITEM_MST;# |# c/ ]6 T/ Y: {/ a8 d
  45. DELETE FROM GUILD_CHAR_INFO;& y2 c# E6 v: F3 F( ?3 l- _
  46. DELETE FROM GUILD_INFO
    % H0 E* A; x+ `/ ~+ F* W5 T+ k$ M
  47. WHERE guild_code NOT LIKE 'MASTERCODE';, ^, C$ y3 h+ Q% y+ G) E
  48. DELETE FROM GUILD_INFO_SECEDE;! @* e) M. N3 i
  49. DELETE FROM GUILD_PEERAGE
    ; y: K8 \  I/ ]; q/ E* J2 G" ^
  50. WHERE guild_code NOT LIKE 'MASTERCODE';6 s' y9 q6 P6 S* W; b% P
  51. DELETE FROM MSSNGR_CHAR_LIST;
    , R. j# V- K; f! Q: {0 M  u
  52. DELETE FROM SIEGE_INFO;
    4 r# J( [7 S8 _0 W; `0 K' |* A
  53. DELETE FROM SIEGE_RESULT_LOG;
      k* r1 b" ~: i- N8 ?, [  Z; R( W- ^
  54. DELETE FROM user_bag2 l- D8 V0 M' ]) l+ H5 |
  55. WHERE character_no NOT LIKE 'DEKARON_000001';
    " t, e- _! s0 r! ^$ v
  56. DELETE FROM user_bag_copy;8 Y& {) R# f& D# ^0 P! Z7 n
  57. DELETE FROM user_bag_secede;* m  R( @- }8 K) s: K' I
  58. DELETE FROM user_character  v; p) [* a" h, ^% W6 G) P
  59. WHERE character_no NOT LIKE 'DEKARON_000001';
    % |9 Z) z% O- i( Q3 r+ @
  60. DELETE FROM user_character_secede;
    2 H5 \# f' i! L
  61. DELETE FROM USER_POSTBOX;" f0 i. M- B8 ~$ G/ }+ Q
  62. DELETE FROM USER_POSTBOX_SECEDE;1 i+ ^: k3 C( \. H, g* {2 X
  63. DELETE FROM User_Quest_Doing;* |4 W& |; n7 C, v
  64. DELETE FROM user_quest_doing_secede;
    + J2 S4 s, _# Y" v
  65. DELETE FROM User_Quest_Done;
    , {  h, K9 j3 y: v! W( v
  66. DELETE FROM user_quest_done_secede;& J) G$ M2 c6 Y" q- X
  67. DELETE FROM user_skill
    / ~1 A5 f. |6 b1 e; C! S: v
  68. WHERE character_no NOT LIKE 'DEKARON_000001';$ Y0 J" @, ~* p' q. J9 r
  69. DELETE FROM user_skill_secede
    : }4 {" S1 Q# P
  70. DELETE FROM user_slot
    % Y4 O- F) A2 R1 r. j( L6 `
  71. WHERE character_no NOT LIKE 'DEKARON_000001';
    1 M/ c: e* ^3 Q* ?+ F
  72. DELETE FROM user_storage;
    3 V$ J0 Z2 S$ O0 L
  73. DELETE FROM user_storage_copy;/ F+ _5 Y1 P& m- b4 y
  74. DELETE FROM USER_STORE;
    " s1 k. }3 M6 B( C: t+ p
  75. DELETE FROM USER_STORE_copy;
    " J1 a9 V% I7 E2 z
  76. DELETE FROM USER_STORE_SECEDE;2 B! c) F6 M1 r8 J
  77. DELETE FROM user_suit1 J5 N5 G' U! i
  78. WHERE character_no NOT LIKE 'DEKARON_000001';# a0 L+ F! V. K+ n5 e
  79. DELETE FROM user_suit_copy;. B! Z+ H" _1 J6 v; o" w; j
  80. DELETE FROM user_suit_secede;9 [" f8 i. G( p3 L% n5 p
  81. GO
复制代码

( G: T) p7 i& u2 |5 x. l6 ?2 G$ ]5 o' @/ V5 |/ ?
商业服务端 登录器 网站 出售

15

主题

258

回帖

1251

积分

金牌会员

积分
1251
金钱
907
贡献
66
注册时间
2023-11-10
发表于 2024-1-29 15:23:38 | 显示全部楼层
我是来学习的!

21

主题

378

回帖

1013

积分

高级会员

积分
1013
金钱
445
贡献
169
注册时间
2024-1-20
发表于 2024-1-31 23:10:21 | 显示全部楼层
感谢楼主分享!!

0

主题

129

回帖

630

积分

高级会员

积分
630
金钱
380
贡献
121
注册时间
2024-9-19
发表于 2024-10-15 23:11:27 | 显示全部楼层
干活学习

0

主题

69

回帖

8383

积分

论坛元老

积分
8383
金钱
7710
贡献
604
注册时间
2023-11-23
发表于 2024-10-16 14:56:13 | 显示全部楼层
语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~!

157

主题

372

回帖

7194

积分

管理员

积分
7194
金钱
2070
贡献
4595
注册时间
2023-11-3
QQ
 楼主| 发表于 2024-10-16 16:39:16 | 显示全部楼层
大张 发表于 2024-10-16 14:566 t: w9 [) r* w' z+ Q
语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~!
$ X& s) i) e' Z3 C/ A
帖子里面有复制功能
商业服务端 登录器 网站 出售
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则


Archiver|小黑屋|EGameol

GMT+8, 2026-4-12 09:00 , Processed in 0.184403 second(s), 23 queries .

Powered by Discuz! X3.5

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表