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

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

[复制链接]

150

主题

310

回帖

5316

积分

管理员

积分
5316
金钱
1706
贡献
3150
注册时间
2023-11-3
QQ
发表于 2024-1-28 20:00:01 | 显示全部楼层 |阅读模式
  1. ; s" V& J$ R9 Y% R# E8 }
  2. * g8 Z2 j; I9 k0 G
  3. use account;
    & R! ^/ R# w; d3 K
  4. DELETE FROM C_IP_BAN;
    # Y8 ~  v  F) I; w, I  @& q
  5. DELETE FROM C_IP_PERMIT;- [3 \' t$ m" k+ m4 E
  6. DELETE FROM C_IP_PWD;3 D; i% }$ w& }. m  |5 w- f6 x) H
  7. DELETE FROM C_LOGINIPBLOCK_LOG;
    / z7 q4 A+ f& Y* A; u7 b
  8. DELETE FROM C_SEQUENCE;7 c! s1 W" E/ t' w
  9. DELETE FROM CP_USER_PROFILE;/ Y6 g% }, c# ^4 k+ x, x3 e
  10. DELETE FROM MB_USR_IP;( M9 s5 U; d, t* p5 p+ U
  11. DELETE FROM MB_USR_PUN;) k# \, M) {; P, L0 }8 l! N0 I
  12. DELETE FROM Tbl_user;  |0 g( V% n/ W' w; x
  13. DELETE FROM USER_CONNLOG_KEY;5 K! y; _' u6 W$ a. p
  14. DELETE FROM USER_PROFILE;
    , M7 d* V& v( ^& \( k) a8 p' A
  15. GO
    ( W: L+ E& Z6 K: x: k; Z2 r; O+ V3 G
  16. use billing;) o# Z) }$ ~/ b- T4 @" z
  17. DELETE FROM bl_error_log;: [6 r5 R* F( l+ P  @5 g3 v
  18. DELETE FROM c_sequence;  _) K2 P8 M; N2 }/ c" Q
  19. DELETE FROM dba_online_daily;
    " g+ C/ ]& c, U" E' J' M) S! g
  20. DELETE FROM dba_online_daily_notok;$ _5 d7 {) o+ Q) d4 D( l( A
  21. DELETE FROM Tbl_KeepId;
    7 g: m8 `: b- N; P
  22. DELETE FROM user_account;3 I: }  B3 w1 l# }- N
  23. DELETE FROM user_account;
    ) e8 r6 E: u" W* }3 C( I( g" m3 x
  24. DELETE FROM user_charge_log;
    ' }6 i% N" j1 |3 F3 {
  25. DELETE FROM user_everyday_use_info;
    . s5 ^. N/ x% @' w2 c4 i# Z
  26. DELETE FROM user_give_log;' a! ]: b) W% f' N) X
  27. DELETE FROM user_use_log;
    4 ]& U- E! B- s
  28. DELETE FROM user_use_log_bk;
    ( `% b: t+ k' r0 F
  29. GO& G0 Y/ B" Q- |% f# h
  30. use cash;/ c; V) X! c5 F- ?  S; d) r
  31. DELETE FROM bl_error_log;
    - g0 T: H- _! J! M
  32. DELETE FROM Tbl_Cash_zj;
    1 N) X, c7 C5 H% y4 V
  33. DELETE FROM user_cash;2 F& Z8 m# B; i' T( P% h
  34. DELETE FROM user_charge_log;0 q/ `4 ]6 X8 |! y, H+ J" Z
  35. DELETE FROM user_use_log;0 }. m; I% }9 Z  E, J
  36. GO8 R" w+ O( P: r6 ^% \; [+ V4 o
  37. use character;
    $ k: g( V9 [" |: y
  38. DELETE FROM C_EVENT_ITEM_OP
    % M' J4 J! @4 ^; ?
  39. DELETE FROM c_restword;
    * Y2 Q3 @  |# D" L( F
  40. DELETE FROM char_connlog;
    % `7 ^. X, r+ m7 i
  41. DELETE FROM CHAR_CONNLOG_KEY;$ N: J. ^! q( B$ ^- O
  42. DELETE FROM DEL_USER_CHAR_LIST;0 m+ n" @( j# Y. a: c
  43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;. s$ w  R2 W" C, x9 L6 h) \
  44. DELETE FROM GM_ITEM_MST;
    2 C2 O" W5 C+ y! I, U) E
  45. DELETE FROM GUILD_CHAR_INFO;8 g1 H8 b( W9 K: o' p- K
  46. DELETE FROM GUILD_INFO0 c3 V! o! ~( U$ O( O
  47. WHERE guild_code NOT LIKE 'MASTERCODE';
    $ Z( ^! `, c# C: {5 R
  48. DELETE FROM GUILD_INFO_SECEDE;( d* ~0 \+ ~2 q* W7 a7 D
  49. DELETE FROM GUILD_PEERAGE
    8 R. ]8 E$ x  N0 G6 c+ ]" o. O
  50. WHERE guild_code NOT LIKE 'MASTERCODE';6 \) j& ]1 f4 o+ L& j/ c
  51. DELETE FROM MSSNGR_CHAR_LIST;
    4 I: p4 A9 W/ ?7 p7 G$ V
  52. DELETE FROM SIEGE_INFO;
    4 [3 Z; V" B6 R$ y! m# x  C
  53. DELETE FROM SIEGE_RESULT_LOG;
    + e$ G$ ^8 y4 Y: _
  54. DELETE FROM user_bag
    * H6 t! b, t) a% T
  55. WHERE character_no NOT LIKE 'DEKARON_000001';# T! Q$ x3 `, }0 `+ ?) c
  56. DELETE FROM user_bag_copy;/ K2 J& \  b+ d
  57. DELETE FROM user_bag_secede;3 a' L8 `) K) a
  58. DELETE FROM user_character
    ! B0 g2 M2 W$ O) o: T
  59. WHERE character_no NOT LIKE 'DEKARON_000001';4 u! g' u/ Z- L& E
  60. DELETE FROM user_character_secede;
    % U" z. v1 ]7 q" U
  61. DELETE FROM USER_POSTBOX;
    " _5 w/ h8 Z9 @- \' s" w; v* g$ l
  62. DELETE FROM USER_POSTBOX_SECEDE;
    7 C. h+ k' Q1 ~6 ~1 g
  63. DELETE FROM User_Quest_Doing;
    - h4 s; V- C6 [8 _# b0 X
  64. DELETE FROM user_quest_doing_secede;; G$ w! h( b5 J3 s  B
  65. DELETE FROM User_Quest_Done;
    1 y/ [* a& A$ {- g7 N& o" J
  66. DELETE FROM user_quest_done_secede;4 L! T: J2 R- `, Y/ a5 j% L5 O( X
  67. DELETE FROM user_skill9 |- d. v0 d) p( Y' l7 T% d; w
  68. WHERE character_no NOT LIKE 'DEKARON_000001';2 K( Q# n* R: G
  69. DELETE FROM user_skill_secede
    6 N2 x9 k' C7 j1 q- _1 B  M. G8 q
  70. DELETE FROM user_slot6 g9 d' u7 l8 t2 n2 k1 E
  71. WHERE character_no NOT LIKE 'DEKARON_000001';) V( Q7 u+ W) V
  72. DELETE FROM user_storage;
    . R: ^' X6 |) D* k4 y, s# `
  73. DELETE FROM user_storage_copy;
    9 t' C5 Z( U9 T2 o
  74. DELETE FROM USER_STORE;9 d$ F2 k) v% e4 f. ?
  75. DELETE FROM USER_STORE_copy;
    * W& V- L, ~/ ~% P
  76. DELETE FROM USER_STORE_SECEDE;6 p" q' m' g8 L8 Z- i" J
  77. DELETE FROM user_suit
    ! O6 C) \1 Y# {+ |
  78. WHERE character_no NOT LIKE 'DEKARON_000001';
    ; }0 X8 p' j' O
  79. DELETE FROM user_suit_copy;- j8 ]5 `3 I/ |- d+ @& |# [
  80. DELETE FROM user_suit_secede;
    8 D" N/ n! v5 k8 r  Z7 a9 }
  81. GO
复制代码

+ p. A, h5 B& q+ n5 ]  E7 O$ u1 s! u* W* S) B
商业服务端 登录器 网站 出售

13

主题

249

回帖

1176

积分

高级会员

积分
1176
金钱
746
贡献
163
注册时间
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

回帖

4870

积分

金牌会员

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

150

主题

310

回帖

5316

积分

管理员

积分
5316
金钱
1706
贡献
3150
注册时间
2023-11-3
QQ
 楼主| 发表于 2024-10-16 16:39:16 | 显示全部楼层
大张 发表于 2024-10-16 14:569 l! t. G, N+ I1 ^; N( c% U
语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~!
& I5 n$ ]! ^: ?
帖子里面有复制功能
商业服务端 登录器 网站 出售
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则


Archiver|小黑屋|EGameol

GMT+8, 2025-10-10 11:15 , Processed in 0.082662 second(s), 23 queries .

Powered by Discuz! X3.5

Copyright © 2001-2020, Tencent Cloud.

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