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

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

[复制链接]

140

主题

248

回帖

4324

积分

管理员

积分
4324
金钱
1520
贡献
2416
注册时间
2023-11-3
QQ
发表于 2024-1-28 20:00:01 | 显示全部楼层 |阅读模式
  1. 5 q) s' ~' R8 t  Z/ C: P8 K& |

  2. + [9 g1 y/ u; F3 C
  3. use account;
      A+ J! U3 N0 F3 J$ `* I9 f
  4. DELETE FROM C_IP_BAN;( F- \3 w. n8 I: y. M/ D$ B8 S
  5. DELETE FROM C_IP_PERMIT;
    $ u& D8 t4 x9 L4 c) F
  6. DELETE FROM C_IP_PWD;' f4 N' D% m: z( F0 t% O
  7. DELETE FROM C_LOGINIPBLOCK_LOG;& V, m0 k# M$ S
  8. DELETE FROM C_SEQUENCE;
    - b0 T4 Q, V& q" a  C: M* I* c3 H
  9. DELETE FROM CP_USER_PROFILE;" a0 g7 Z  |0 _& l. a2 V
  10. DELETE FROM MB_USR_IP;
    : \" L: o4 I. r5 J( O7 l4 |
  11. DELETE FROM MB_USR_PUN;. v- ]) q" b( @8 T  F3 D8 \
  12. DELETE FROM Tbl_user;: O' f' u  r6 t$ V; Q, H
  13. DELETE FROM USER_CONNLOG_KEY;
    + n& x/ N( k) o5 A/ `
  14. DELETE FROM USER_PROFILE;
    7 P: K! [* T8 D  a' w4 `$ c) x
  15. GO
    6 h& r+ x0 r6 |, Q* \. |- E- S4 c
  16. use billing;
    $ ~9 R: k) ~7 h0 ?- \) H
  17. DELETE FROM bl_error_log;! {2 M6 b. h1 ~- j2 a
  18. DELETE FROM c_sequence;
    ' Y! n5 Y) Y: M) |5 V" S
  19. DELETE FROM dba_online_daily;
    8 T; ^& ?# n0 T/ }, e
  20. DELETE FROM dba_online_daily_notok;" W' f% m7 c3 x# H
  21. DELETE FROM Tbl_KeepId;  m4 P* J% L# U% s. F" u
  22. DELETE FROM user_account;! S. X$ b  T9 v: M
  23. DELETE FROM user_account;7 A* k; c/ i" P6 @) C8 b, N
  24. DELETE FROM user_charge_log;
    3 E5 j/ v8 t; z
  25. DELETE FROM user_everyday_use_info;
    . Q" Q9 T' k# u2 }0 E5 U
  26. DELETE FROM user_give_log;. ~4 O% b# p! V! K- C& v& U
  27. DELETE FROM user_use_log;
    " _& \. C, t/ V5 |4 f$ K
  28. DELETE FROM user_use_log_bk;
    - Y5 v$ |- ^8 |& x' R
  29. GO
    ( f+ Z# n5 H/ a) w# ?
  30. use cash;
    ! D6 |  _* `2 B+ A8 t  ^
  31. DELETE FROM bl_error_log;- V) v( D$ X2 n$ s% E3 R2 n* M
  32. DELETE FROM Tbl_Cash_zj;
    & b9 E8 U9 [" R  w% `
  33. DELETE FROM user_cash;. _( a8 Z' o. l) N& ~
  34. DELETE FROM user_charge_log;
    . g. q$ T5 E. m9 a5 \1 ~9 c
  35. DELETE FROM user_use_log;) N" |* g0 I, x* D5 Q
  36. GO) v; I9 O$ U- @5 _( x$ t' V' |
  37. use character;
    7 }" I) x1 @& Z! d' [7 P
  38. DELETE FROM C_EVENT_ITEM_OP: T" O" M7 R+ o+ ~  p
  39. DELETE FROM c_restword;3 ^* {2 X& x2 n' K+ G
  40. DELETE FROM char_connlog;( C) ?' }2 o5 M+ O/ b
  41. DELETE FROM CHAR_CONNLOG_KEY;- d( {7 g  h$ T& u, V
  42. DELETE FROM DEL_USER_CHAR_LIST;
    ; S' |* ^, Q) E' k+ A: |) ^1 T
  43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;/ I" `# D( g% t, s
  44. DELETE FROM GM_ITEM_MST;
    $ @. y( F+ m) V
  45. DELETE FROM GUILD_CHAR_INFO;
    ' d* Q, A7 f" Z) ~
  46. DELETE FROM GUILD_INFO) R$ r* S6 b0 d* W; j- O! ^
  47. WHERE guild_code NOT LIKE 'MASTERCODE';
    & ]* V2 L) [. s. a7 f
  48. DELETE FROM GUILD_INFO_SECEDE;
    " Z& w& s( v9 l, D! N+ s6 L
  49. DELETE FROM GUILD_PEERAGE
    * S# t0 H( s* [& Z  ^0 D  Q* O( m
  50. WHERE guild_code NOT LIKE 'MASTERCODE';3 Z9 i. a; h8 n$ }2 Q. b; g
  51. DELETE FROM MSSNGR_CHAR_LIST;" C, R. g/ c" Q! q2 D- @1 _
  52. DELETE FROM SIEGE_INFO;
    5 y' \, ]# a2 o1 _
  53. DELETE FROM SIEGE_RESULT_LOG;$ m9 P1 r( i3 m5 p' p" [! F5 T% J; F
  54. DELETE FROM user_bag
      R) d& V$ t$ M& C: Y! h
  55. WHERE character_no NOT LIKE 'DEKARON_000001';
    ( y( r# G' x, f: T, u0 C8 |0 u; {. O
  56. DELETE FROM user_bag_copy;: K+ Q5 Y0 q  N' ^6 o9 F2 s* l
  57. DELETE FROM user_bag_secede;
    ! `) L6 k8 u: a
  58. DELETE FROM user_character
    ( t: U( v3 Y/ n+ ]% |
  59. WHERE character_no NOT LIKE 'DEKARON_000001';
    9 w) \, M% R; }1 u" c/ S
  60. DELETE FROM user_character_secede;" ?9 ^" |. @; _2 F# f- s( ]5 L
  61. DELETE FROM USER_POSTBOX;
    1 [' r, `, G# Z* }2 m7 d& K( U+ u
  62. DELETE FROM USER_POSTBOX_SECEDE;( Y, W9 r: r6 y7 ]
  63. DELETE FROM User_Quest_Doing;! C; o' }8 F) }1 U, J
  64. DELETE FROM user_quest_doing_secede;
      V. f" M3 J5 m
  65. DELETE FROM User_Quest_Done;3 L( B) ~$ m2 t
  66. DELETE FROM user_quest_done_secede;5 K  E5 x8 E: @+ i# F
  67. DELETE FROM user_skill/ d  n( K+ ]7 l* u! P
  68. WHERE character_no NOT LIKE 'DEKARON_000001';
    7 T. I- d3 P/ t7 w6 W: ?4 H
  69. DELETE FROM user_skill_secede
    7 c9 ~7 z. c  }# I( x
  70. DELETE FROM user_slot
    5 A0 `, J  I, b7 U+ n* a" @
  71. WHERE character_no NOT LIKE 'DEKARON_000001';* l$ u" n5 g: Z6 G5 u1 p
  72. DELETE FROM user_storage;
    1 Q; p% a" }0 I" A+ z' C1 c0 h
  73. DELETE FROM user_storage_copy;* E$ M$ u# t6 [8 j8 \; o
  74. DELETE FROM USER_STORE;
    . Q9 R2 D8 M; Y- `, p% v, ^
  75. DELETE FROM USER_STORE_copy;
    ' c$ D8 y* {/ W/ T8 E' |6 |
  76. DELETE FROM USER_STORE_SECEDE;
    - z. D8 K  ~$ Q( x
  77. DELETE FROM user_suit8 X; J( o7 C2 i8 q! Q$ o3 |6 r
  78. WHERE character_no NOT LIKE 'DEKARON_000001';
    $ `: ~% Q3 m9 X0 A' y' Q
  79. DELETE FROM user_suit_copy;* I, h$ w" {6 ~4 ?
  80. DELETE FROM user_suit_secede;" x: j0 U2 l0 L
  81. GO
复制代码

: V9 Q0 S  L/ y8 L4 p
2 {% y" n+ t9 ^- u9 ?; R! k
商业服务端 登录器 网站 出售

9

主题

236

回帖

982

积分

高级会员

积分
982
金钱
601
贡献
131
注册时间
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

回帖

618

积分

高级会员

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

0

主题

67

回帖

2944

积分

金牌会员

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

140

主题

248

回帖

4324

积分

管理员

积分
4324
金钱
1520
贡献
2416
注册时间
2023-11-3
QQ
 楼主| 发表于 2024-10-16 16:39:16 | 显示全部楼层
大张 发表于 2024-10-16 14:56& S& C; p+ k$ d( r
语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~!
) n5 A6 I6 ?, _7 `& k
帖子里面有复制功能
商业服务端 登录器 网站 出售
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

Archiver|手机版|小黑屋|EGameol

GMT+8, 2025-6-30 02:37 , Processed in 0.070807 second(s), 21 queries .

Powered by Discuz! X3.5

Copyright © 2001-2020, Tencent Cloud.

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