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

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

[复制链接]

161

主题

394

回帖

7560

积分

管理员

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

  1. 4 n0 V; F7 s* i3 R$ n

  2. 5 n& h6 c) b* k  Q. |; K
  3. use account;
    4 y0 z6 u$ x: K1 b) R# B  u( m3 W
  4. DELETE FROM C_IP_BAN;. _. A) G% f  M3 m5 L/ a
  5. DELETE FROM C_IP_PERMIT;
    ; _2 j6 M' H2 A
  6. DELETE FROM C_IP_PWD;* w0 _& c5 P9 R! V/ V/ D0 U
  7. DELETE FROM C_LOGINIPBLOCK_LOG;
    3 I6 t( M- T" ?5 t+ `9 K( T' k
  8. DELETE FROM C_SEQUENCE;- |! Y9 G1 \, c. ?
  9. DELETE FROM CP_USER_PROFILE;
    , [" I1 O1 W3 b4 W% t0 y
  10. DELETE FROM MB_USR_IP;4 h! o: U0 ]# L6 k7 c2 b2 |# {
  11. DELETE FROM MB_USR_PUN;; w% v( Y* R# d: d
  12. DELETE FROM Tbl_user;4 T( X  L  q- C/ ?
  13. DELETE FROM USER_CONNLOG_KEY;) [7 k3 ]& I5 d- Y& j
  14. DELETE FROM USER_PROFILE;
    4 F; `; M4 j# ^
  15. GO
    2 K/ F& I6 S9 W0 A: g9 T! w
  16. use billing;
    2 M7 \6 D$ p' k: e
  17. DELETE FROM bl_error_log;( J5 y8 K2 \  j9 ^: D
  18. DELETE FROM c_sequence;5 U6 F6 z# e0 X  h$ v# D! t
  19. DELETE FROM dba_online_daily;! m( O5 T9 u9 \+ v6 Q% T
  20. DELETE FROM dba_online_daily_notok;
    6 f# e. n+ h) z) b+ e3 O
  21. DELETE FROM Tbl_KeepId;
    0 i5 N/ y: D6 P3 x  W
  22. DELETE FROM user_account;
    : y/ [5 \- I7 y$ C8 _; j# v- H
  23. DELETE FROM user_account;. @* v: n, N- d1 Z# G1 k
  24. DELETE FROM user_charge_log;
    6 j+ v; j2 [6 M" \  z1 U7 q0 y
  25. DELETE FROM user_everyday_use_info;* I: L& Q' j5 o& Q2 _5 D; R
  26. DELETE FROM user_give_log;
    5 U$ {/ W" {* y0 D
  27. DELETE FROM user_use_log;5 S1 k+ i, y" K! B. h0 t+ w
  28. DELETE FROM user_use_log_bk;" L  ]  M! R3 }9 a% x
  29. GO0 {7 A! R) ~% K, G/ C
  30. use cash;
    + E# L0 A% ?& K( m- A0 i
  31. DELETE FROM bl_error_log;' c2 |4 d) c6 p7 }; z
  32. DELETE FROM Tbl_Cash_zj;' _9 O3 z+ \: P! H& [8 F3 Y" U3 w2 n6 B
  33. DELETE FROM user_cash;( w: q1 U; H7 k* G( ?5 \
  34. DELETE FROM user_charge_log;( K, z, o/ i, k) \/ Z  e
  35. DELETE FROM user_use_log;
    2 F; X) i( z1 W- u: G: N$ d% c
  36. GO4 e6 f- Y2 n# Z! o, c
  37. use character;
    7 g# R7 V+ w# t
  38. DELETE FROM C_EVENT_ITEM_OP  }  r+ D8 z& V) X" `. e% {
  39. DELETE FROM c_restword;1 D% w& I+ z, V" I) k9 {8 _
  40. DELETE FROM char_connlog;
    $ @' ~/ h# J; d) C2 P- V$ X
  41. DELETE FROM CHAR_CONNLOG_KEY;
    1 c. z2 s/ W5 L$ @% j3 Z
  42. DELETE FROM DEL_USER_CHAR_LIST;2 E( i' V% J( k1 v% [8 Z
  43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;1 g5 V$ `7 i; s* }2 z
  44. DELETE FROM GM_ITEM_MST;# f* a8 P3 z- X1 A1 j: _
  45. DELETE FROM GUILD_CHAR_INFO;
    6 Z1 U3 X$ a! R
  46. DELETE FROM GUILD_INFO* d7 q- \" t" @
  47. WHERE guild_code NOT LIKE 'MASTERCODE';" u( o8 O  v! L. X6 E+ F2 }( S
  48. DELETE FROM GUILD_INFO_SECEDE;; u1 |  I% E5 V6 F! S9 B
  49. DELETE FROM GUILD_PEERAGE4 L0 A4 K' `) D$ c* s0 o0 Q
  50. WHERE guild_code NOT LIKE 'MASTERCODE';
    ; e, E' O' z3 ~
  51. DELETE FROM MSSNGR_CHAR_LIST;4 N, _8 x, m7 T8 _* F4 r
  52. DELETE FROM SIEGE_INFO;
    $ t/ d  G' u3 X
  53. DELETE FROM SIEGE_RESULT_LOG;! {9 q  w3 P. u
  54. DELETE FROM user_bag
    , ^+ A$ |  g( m! b
  55. WHERE character_no NOT LIKE 'DEKARON_000001';& d5 @2 w& c' `1 u7 v8 j
  56. DELETE FROM user_bag_copy;
    5 j# T% v6 r2 F8 k- C- ?
  57. DELETE FROM user_bag_secede;5 M5 b5 Y( `  K
  58. DELETE FROM user_character
    6 a4 B# e- f* @
  59. WHERE character_no NOT LIKE 'DEKARON_000001';
    9 s- J' d, W! Y- |4 ^4 t, H
  60. DELETE FROM user_character_secede;/ G: j. E, w6 g' u6 H* O" f$ ?
  61. DELETE FROM USER_POSTBOX;
    4 h5 y" L6 k7 N# ?" t; Z
  62. DELETE FROM USER_POSTBOX_SECEDE;
    " _. ^$ v: {8 o9 Q6 Y$ p: w
  63. DELETE FROM User_Quest_Doing;% S7 g7 |7 D9 p, _  j
  64. DELETE FROM user_quest_doing_secede;
    8 I* b) {! \2 P1 A% K; q
  65. DELETE FROM User_Quest_Done;
    4 s8 R' \9 |& k" e/ C3 C
  66. DELETE FROM user_quest_done_secede;2 a2 K+ G2 i& F
  67. DELETE FROM user_skill8 |* n) k* C4 _( s; o
  68. WHERE character_no NOT LIKE 'DEKARON_000001';, x  ~5 \! j# ]. g1 S2 [/ c+ a/ A
  69. DELETE FROM user_skill_secede& I5 I* M" s0 m& j( g
  70. DELETE FROM user_slot
    . ~# h% k, Y4 Q! g1 G
  71. WHERE character_no NOT LIKE 'DEKARON_000001';9 d2 G1 ~$ h" {
  72. DELETE FROM user_storage;$ v& M" Q; j# p$ M# m! X: N
  73. DELETE FROM user_storage_copy;
    $ {: t: p. H6 A5 W$ D
  74. DELETE FROM USER_STORE;
    & s. P8 _. v$ }
  75. DELETE FROM USER_STORE_copy;) X; l9 c! P8 j% K' @  ?
  76. DELETE FROM USER_STORE_SECEDE;( ?. Z& G% P. G% K# z8 l
  77. DELETE FROM user_suit
    - M* e  Y3 g! H: H: S8 R/ ~- s9 {
  78. WHERE character_no NOT LIKE 'DEKARON_000001';
    " w. z! q8 J+ f: n, U
  79. DELETE FROM user_suit_copy;$ a. Z- ^# n; z& L1 ]/ c- }' J
  80. DELETE FROM user_suit_secede;3 m8 h2 W! Z( H6 |9 T+ y
  81. GO
复制代码
& O$ J) A- V! ~7 h% ^

  M/ p4 A5 I# q. L. S7 e6 s
商业服务端 登录器 网站 出售

15

主题

260

回帖

1322

积分

金牌会员

积分
1322
金钱
951
贡献
91
注册时间
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

主题

70

回帖

9215

积分

论坛元老

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

161

主题

394

回帖

7560

积分

管理员

积分
7560
金钱
2182
贡献
4823
注册时间
2023-11-3
QQ
 楼主| 发表于 2024-10-16 16:39:16 | 显示全部楼层
大张 发表于 2024-10-16 14:56
8 ]. Z7 z, x& P- W. N语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~!

) S4 z* d2 d# L. P( F; o4 i: o+ f帖子里面有复制功能
商业服务端 登录器 网站 出售
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则


Archiver|小黑屋|EGameol

GMT+8, 2026-5-23 15:52 , Processed in 0.038433 second(s), 23 queries .

Powered by Discuz! X3.5

Copyright © 2001-2020, Tencent Cloud.

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