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

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

[复制链接]

151

主题

321

回帖

5508

积分

管理员

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

  1. 0 D1 V0 u' ]7 J; f' L$ X

  2. 8 z) j5 ~0 j- B& O! s
  3. use account;  V  T6 g7 l1 D1 M- Y
  4. DELETE FROM C_IP_BAN;
    5 w& Y) {$ P4 s$ W- Y7 d
  5. DELETE FROM C_IP_PERMIT;
    3 ~0 Z, c0 L- j& A9 g) O
  6. DELETE FROM C_IP_PWD;
    1 w; M. y+ Z( p6 U: v
  7. DELETE FROM C_LOGINIPBLOCK_LOG;  @5 J$ d& `2 w7 {) Z' L
  8. DELETE FROM C_SEQUENCE;6 \! ~7 y+ y( S5 Z
  9. DELETE FROM CP_USER_PROFILE;
    , l. i0 d$ Z2 W
  10. DELETE FROM MB_USR_IP;' v; P: i+ t6 _' i0 u% N
  11. DELETE FROM MB_USR_PUN;, k0 I' v* f  E+ H" |
  12. DELETE FROM Tbl_user;6 \5 t% N/ H5 n: _5 F$ g
  13. DELETE FROM USER_CONNLOG_KEY;+ t2 C  v% q+ ]/ _9 h2 b
  14. DELETE FROM USER_PROFILE;
    0 s* u6 G2 j9 \0 U
  15. GO
    : q# ^  X' Q& D7 F+ ]
  16. use billing;
    ! w7 a7 k) d) R
  17. DELETE FROM bl_error_log;) \! Y% U6 L. T. H. F! h
  18. DELETE FROM c_sequence;
    ' ~5 k6 v3 y) y' c, P
  19. DELETE FROM dba_online_daily;2 R3 I) U& n- _
  20. DELETE FROM dba_online_daily_notok;) u- v7 ^8 Y9 d4 v
  21. DELETE FROM Tbl_KeepId;, N" m0 L1 Y6 a
  22. DELETE FROM user_account;
    4 {" o* k' q. x
  23. DELETE FROM user_account;
    0 w: E4 a+ E; Y$ {  R
  24. DELETE FROM user_charge_log;
    . @1 r7 y+ s9 r/ o/ Q
  25. DELETE FROM user_everyday_use_info;
    " f! [3 |7 b% F& Z) t& n% \
  26. DELETE FROM user_give_log;% W- k: w2 |/ D/ s7 s
  27. DELETE FROM user_use_log;
    , b; [+ t7 k2 z3 S; Y* Z3 {0 s
  28. DELETE FROM user_use_log_bk;
    ( b' f& {* O. d) `
  29. GO
    * G/ b5 i. R, X
  30. use cash;
    3 o4 ]7 N: R: p( W
  31. DELETE FROM bl_error_log;
    + U; j/ H  w/ x# h6 o* Y
  32. DELETE FROM Tbl_Cash_zj;' |# j% F: h: E, f. k9 Z& J
  33. DELETE FROM user_cash;6 ]6 a. e2 F/ ]. O
  34. DELETE FROM user_charge_log;
    " m$ E5 Q* p7 U" O
  35. DELETE FROM user_use_log;
    ; y. e; }' s9 N  O, L1 P8 J4 U
  36. GO
    7 V3 ~6 G3 O/ A% g5 ?) b1 e$ J+ Y
  37. use character;7 X8 l6 ~4 I& c9 E2 Y; L
  38. DELETE FROM C_EVENT_ITEM_OP% {& _. h, j: [, C" j$ @& H
  39. DELETE FROM c_restword;0 U: ~8 q) L. o
  40. DELETE FROM char_connlog;
    7 ^' ^3 |" ?! `. r1 c# |
  41. DELETE FROM CHAR_CONNLOG_KEY;% N3 y6 s  g/ Q1 b# ~$ T$ N
  42. DELETE FROM DEL_USER_CHAR_LIST;
    0 w, R2 `) I- S' }2 n3 G6 Y- q
  43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;+ \8 \6 P* H( U7 Y0 N# @9 x
  44. DELETE FROM GM_ITEM_MST;
    5 @! G; @* W9 d! }9 L7 W9 [
  45. DELETE FROM GUILD_CHAR_INFO;% p9 T2 x3 _8 Q/ y
  46. DELETE FROM GUILD_INFO+ A9 d9 l, A7 M' j0 }
  47. WHERE guild_code NOT LIKE 'MASTERCODE';
    * K1 B" @  q: w& ^0 i6 g6 r
  48. DELETE FROM GUILD_INFO_SECEDE;! w8 P0 t' x' G) K( F) _
  49. DELETE FROM GUILD_PEERAGE' d5 Y. [$ |- ~3 R7 A! U
  50. WHERE guild_code NOT LIKE 'MASTERCODE';4 q3 r8 ]) |3 t9 K
  51. DELETE FROM MSSNGR_CHAR_LIST;- j6 c! x5 g- E
  52. DELETE FROM SIEGE_INFO;! x; d, U. n( Z3 _. G: Y% Z3 d
  53. DELETE FROM SIEGE_RESULT_LOG;8 B' E2 Y$ L8 ~. @" U5 J" p
  54. DELETE FROM user_bag
    0 N6 l0 ^! a+ |& }6 U
  55. WHERE character_no NOT LIKE 'DEKARON_000001';9 M/ w3 A" c% F0 L$ p
  56. DELETE FROM user_bag_copy;( m- u2 Y$ V- g: F" x
  57. DELETE FROM user_bag_secede;
    5 u2 Z0 v4 m9 A6 t
  58. DELETE FROM user_character
    / a. Q6 a( z) A& O3 _4 |9 m: S7 Z7 y
  59. WHERE character_no NOT LIKE 'DEKARON_000001';
    6 m- n. e6 u5 {$ {$ _( k
  60. DELETE FROM user_character_secede;- z. z0 q" E) v* ~- h6 S' F
  61. DELETE FROM USER_POSTBOX;
    , M/ x5 v+ l3 l5 I3 U. H
  62. DELETE FROM USER_POSTBOX_SECEDE;: L$ Z4 j( A/ F& j& a) o
  63. DELETE FROM User_Quest_Doing;
    : R' P& d: G2 W  f
  64. DELETE FROM user_quest_doing_secede;
    , B0 |- }% Q4 R9 F( B1 S" b9 q8 A
  65. DELETE FROM User_Quest_Done;3 d+ J# D$ x- l; N( v' D
  66. DELETE FROM user_quest_done_secede;. U4 @  s, Y  l, S/ g
  67. DELETE FROM user_skill
    9 o, t5 B: x. r# V! g: K% i
  68. WHERE character_no NOT LIKE 'DEKARON_000001';
    . D4 R8 h, d! C9 F
  69. DELETE FROM user_skill_secede; r* w" }2 b: a# g! Y
  70. DELETE FROM user_slot9 ~3 L5 B( l. [& X& ?( f
  71. WHERE character_no NOT LIKE 'DEKARON_000001';' N7 Z& F, B  Q' D9 Y8 ^
  72. DELETE FROM user_storage;
    8 W+ m1 E& y$ u+ x4 [& H2 b
  73. DELETE FROM user_storage_copy;2 w3 x: t: w8 V' {* ^7 s
  74. DELETE FROM USER_STORE;- W2 J. `) v3 G3 }6 l* b
  75. DELETE FROM USER_STORE_copy;2 H3 o0 D& Z1 ^! S, a
  76. DELETE FROM USER_STORE_SECEDE;7 J8 o1 L$ C9 I
  77. DELETE FROM user_suit
    $ _8 x8 F% c, a$ A+ x
  78. WHERE character_no NOT LIKE 'DEKARON_000001';
    0 U# O5 O# p- v3 [
  79. DELETE FROM user_suit_copy;! b7 a, {7 ]# `4 O+ K# B
  80. DELETE FROM user_suit_secede;0 y6 K" [, A+ j; w
  81. GO
复制代码
7 T, {+ J4 @! P

$ ?# |4 H+ r6 i
商业服务端 登录器 网站 出售

13

主题

250

回帖

1189

积分

高级会员

积分
1189
金钱
757
贡献
164
注册时间
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

回帖

624

积分

高级会员

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

0

主题

67

回帖

5162

积分

论坛元老

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

151

主题

321

回帖

5508

积分

管理员

积分
5508
金钱
1753
贡献
3283
注册时间
2023-11-3
QQ
 楼主| 发表于 2024-10-16 16:39:16 | 显示全部楼层
大张 发表于 2024-10-16 14:56
  @8 I4 X/ V2 X, n* d- j* F! P6 n语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~!

2 x' @1 F( m! ^0 }7 H8 X帖子里面有复制功能
商业服务端 登录器 网站 出售
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则


Archiver|小黑屋|EGameol

GMT+8, 2025-10-27 01:00 , Processed in 0.064466 second(s), 23 queries .

Powered by Discuz! X3.5

Copyright © 2001-2020, Tencent Cloud.

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