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

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

[复制链接]

155

主题

348

回帖

6179

积分

管理员

积分
6179
金钱
1868
贡献
3808
注册时间
2023-11-3
QQ
发表于 2024-1-28 20:00:01 | 显示全部楼层 |阅读模式
  1. 0 O! n; H! W$ S# [3 _

  2. - W4 ?3 c: Z, Q& _# O2 I- s+ b2 J
  3. use account;
    : I) C; K% j. I7 }0 _
  4. DELETE FROM C_IP_BAN;0 S7 Q4 Q) M# |3 D) k0 r* f
  5. DELETE FROM C_IP_PERMIT;: `5 f7 W* a; p! s2 D1 j
  6. DELETE FROM C_IP_PWD;( T) x$ }! ^# \3 m5 D2 v; _  l
  7. DELETE FROM C_LOGINIPBLOCK_LOG;) E+ P$ o0 Y- s8 y2 g
  8. DELETE FROM C_SEQUENCE;( O. _# V6 ]4 y6 n4 A. z9 U5 J4 H3 ]
  9. DELETE FROM CP_USER_PROFILE;. i; ]+ N/ v# T  H: G4 @- n- Q
  10. DELETE FROM MB_USR_IP;
    & x8 K, T9 c3 V" m2 G
  11. DELETE FROM MB_USR_PUN;
    6 Y: S. ], T( D5 A/ i& ^0 C* l7 E
  12. DELETE FROM Tbl_user;
    / Y7 C( X$ q' F' L/ e6 w/ N
  13. DELETE FROM USER_CONNLOG_KEY;- c: d$ [3 [6 D) k3 u5 G) }
  14. DELETE FROM USER_PROFILE;
      u+ L+ D+ c9 b9 Q) L( s" r: J
  15. GO
    1 S& f' l0 H& I& O8 e& _$ M
  16. use billing;
    , b' j  n- r0 f1 ]' \) w, d/ Q
  17. DELETE FROM bl_error_log;$ D- K3 `0 G6 f1 U$ ^
  18. DELETE FROM c_sequence;/ z5 i+ K8 W( e' J. |3 |# }  O8 c
  19. DELETE FROM dba_online_daily;3 i& p) O4 c) x2 {1 i# ?$ {
  20. DELETE FROM dba_online_daily_notok;
    7 A/ z3 v4 f  f8 g2 Y
  21. DELETE FROM Tbl_KeepId;6 D& y6 h" \4 W, S; c. R, }
  22. DELETE FROM user_account;
    0 T& B  u: w+ H. X
  23. DELETE FROM user_account;
    : K, o; Y. M, u1 r% B! p# f
  24. DELETE FROM user_charge_log;4 j4 Z" v3 z# E# n
  25. DELETE FROM user_everyday_use_info;4 u# u1 K3 ~$ Q8 ^* x+ X3 q
  26. DELETE FROM user_give_log;+ x* x7 ~9 |$ M
  27. DELETE FROM user_use_log;
    # T# h3 z4 t. w, r2 Q
  28. DELETE FROM user_use_log_bk;
    . H9 h! i# y5 _8 U0 V
  29. GO
      x+ E- e2 K) P* T1 g* i
  30. use cash;
    8 g2 v2 h" c2 A+ u
  31. DELETE FROM bl_error_log;" E" n* ~  h: A
  32. DELETE FROM Tbl_Cash_zj;) o  U5 y8 u0 K$ D9 c. t$ I
  33. DELETE FROM user_cash;
    " t+ D2 Z0 Q- J+ K
  34. DELETE FROM user_charge_log;" ?1 [# o  w4 T7 [5 T8 E
  35. DELETE FROM user_use_log;
    7 d: {. S! J# k+ h( Z* N  l
  36. GO. ?$ O. v6 S  o4 Y3 \- m6 J2 T
  37. use character;0 D! D: ]3 g, N
  38. DELETE FROM C_EVENT_ITEM_OP0 w1 P/ Q1 w8 K/ H% h! @& L/ j
  39. DELETE FROM c_restword;/ I2 j9 [3 }& J
  40. DELETE FROM char_connlog;" j) l( T) I* w. E: k7 s
  41. DELETE FROM CHAR_CONNLOG_KEY;/ O/ B) d% i/ N% r/ }3 H3 L) u
  42. DELETE FROM DEL_USER_CHAR_LIST;
    . B. q5 c" }1 `1 ?& P  j/ `
  43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    6 }2 _& M; {& [" C4 J6 C$ s
  44. DELETE FROM GM_ITEM_MST;
    $ A" |3 C" p1 G+ o( ^! @6 N# d
  45. DELETE FROM GUILD_CHAR_INFO;! R7 V; a( x8 ~- }9 _: R# W4 G
  46. DELETE FROM GUILD_INFO+ ^2 G0 B+ H1 P  @! H
  47. WHERE guild_code NOT LIKE 'MASTERCODE';
    5 p2 F5 M0 Y) U8 F
  48. DELETE FROM GUILD_INFO_SECEDE;
    & L/ R* E3 {' P3 r/ x
  49. DELETE FROM GUILD_PEERAGE; e/ b4 z$ T1 j2 f# t. m
  50. WHERE guild_code NOT LIKE 'MASTERCODE';; q" ?5 i% X0 L5 Q
  51. DELETE FROM MSSNGR_CHAR_LIST;
    ; v. }3 L5 G  Y9 Y1 y" A2 K1 Q
  52. DELETE FROM SIEGE_INFO;
    + z9 O% x1 u' m1 G1 u2 y9 y0 V4 k
  53. DELETE FROM SIEGE_RESULT_LOG;
    + m/ o& Z5 j( |7 h& |3 \
  54. DELETE FROM user_bag9 M0 p, \5 b/ R
  55. WHERE character_no NOT LIKE 'DEKARON_000001';
    : i- I, ^5 |0 x
  56. DELETE FROM user_bag_copy;
    ( e; F2 |; H2 x, H7 ^0 N% s7 J
  57. DELETE FROM user_bag_secede;/ A7 b; O9 G# {% k1 b( M( S9 x' u
  58. DELETE FROM user_character
    1 o3 I) G  t' q- X
  59. WHERE character_no NOT LIKE 'DEKARON_000001';( }6 j% k: X) ?- r
  60. DELETE FROM user_character_secede;
    6 t% l  p( N. t8 l* w
  61. DELETE FROM USER_POSTBOX;
    $ r  J2 Z& F! E0 y
  62. DELETE FROM USER_POSTBOX_SECEDE;2 f) q* p2 _$ c( l8 P
  63. DELETE FROM User_Quest_Doing;
    # z* `/ h9 b* ^/ s* k' {! T
  64. DELETE FROM user_quest_doing_secede;# V6 s! @9 V( e  W$ e5 M
  65. DELETE FROM User_Quest_Done;
    & i$ A" `# C; ]$ ~8 a0 V
  66. DELETE FROM user_quest_done_secede;
    + m, K2 n, I* X9 ~) C9 c# f
  67. DELETE FROM user_skill6 ^0 ~& W6 \: z- {1 C. `" e# v- T
  68. WHERE character_no NOT LIKE 'DEKARON_000001';
    ; J6 b! \% W) R$ e, M# R/ Q. G1 B
  69. DELETE FROM user_skill_secede
    . Q6 s, t) Y# m+ \& M
  70. DELETE FROM user_slot
    9 s+ ]# p" w' r2 P" c1 g$ z
  71. WHERE character_no NOT LIKE 'DEKARON_000001';" @7 R7 L$ I9 s4 _2 \! t
  72. DELETE FROM user_storage;
    9 K$ d2 |# r; \' g; n6 H$ I( X# N" F
  73. DELETE FROM user_storage_copy;
    2 f5 q* d/ Q& G4 D9 a" g1 z
  74. DELETE FROM USER_STORE;
    ! \8 K2 t, z  |+ K6 e* X
  75. DELETE FROM USER_STORE_copy;& B! K  C( Q, B
  76. DELETE FROM USER_STORE_SECEDE;  y+ V# M" C" T" k/ O% s
  77. DELETE FROM user_suit
    * r; \: T# y& e. E( c7 \3 L. d
  78. WHERE character_no NOT LIKE 'DEKARON_000001';% c9 @* D& |3 b
  79. DELETE FROM user_suit_copy;
    9 [9 Z1 w. t0 o0 y1 _5 K& W4 b# p
  80. DELETE FROM user_suit_secede;
    + K; p& |6 _2 |1 N% z1 l6 h( ?! A, x
  81. GO
复制代码
; p5 L+ ~6 A* p' T
/ V$ R3 R# T8 V( V
商业服务端 登录器 网站 出售

13

主题

251

回帖

1245

积分

金牌会员

积分
1245
金钱
816
贡献
160
注册时间
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

主题

68

回帖

6504

积分

论坛元老

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

155

主题

348

回帖

6179

积分

管理员

积分
6179
金钱
1868
贡献
3808
注册时间
2023-11-3
QQ
 楼主| 发表于 2024-10-16 16:39:16 | 显示全部楼层
大张 发表于 2024-10-16 14:566 [1 I3 F$ K$ m; M$ v
语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~!
* ]3 x9 q; C; t) _1 ~- F
帖子里面有复制功能
商业服务端 登录器 网站 出售
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则


Archiver|小黑屋|EGameol

GMT+8, 2026-1-1 15:03 , Processed in 0.244211 second(s), 22 queries .

Powered by Discuz! X3.5

Copyright © 2001-2020, Tencent Cloud.

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