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

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

[复制链接]

155

主题

348

回帖

6179

积分

管理员

积分
6179
金钱
1868
贡献
3808
注册时间
2023-11-3
QQ
发表于 2024-1-28 20:00:01 | 显示全部楼层 |阅读模式
  1. 9 N- b# I2 S5 H4 t! d6 U% d4 t

  2. , M  k8 G" a8 D$ v8 i- J
  3. use account;. H* v6 h; {5 f% @6 E
  4. DELETE FROM C_IP_BAN;
    8 n" L$ |# w% m( q! [6 S6 {( a0 W/ o. k
  5. DELETE FROM C_IP_PERMIT;1 s5 t& t5 e! [" R
  6. DELETE FROM C_IP_PWD;
    2 X2 [! I' }0 i9 L$ d
  7. DELETE FROM C_LOGINIPBLOCK_LOG;
    / m4 t/ `2 `% z( E' W
  8. DELETE FROM C_SEQUENCE;
    " T; z' I+ V! O, a, C8 `: u7 G
  9. DELETE FROM CP_USER_PROFILE;9 m& w# b& Q. K/ h
  10. DELETE FROM MB_USR_IP;" o: W6 t- Z, b7 X
  11. DELETE FROM MB_USR_PUN;
    ) A  s: ~& C7 g" [' X: A- H$ |( |
  12. DELETE FROM Tbl_user;
    ; l8 `0 o! Y: z) b
  13. DELETE FROM USER_CONNLOG_KEY;
    ( q! v: M2 D1 I0 w. E3 s: T) w
  14. DELETE FROM USER_PROFILE;
    * B( x, w7 a4 B7 n
  15. GO
    7 @" H3 Y6 c3 C4 X, ^$ |
  16. use billing;
    7 q( ?  L* E0 Z, E; c* Y( E( L
  17. DELETE FROM bl_error_log;3 x& m1 r/ i2 q. y
  18. DELETE FROM c_sequence;) D1 B% u1 M% p; p: m+ E
  19. DELETE FROM dba_online_daily;
    - O5 M! |" c  v( F6 L* M& ^6 h
  20. DELETE FROM dba_online_daily_notok;
    , u8 q7 @  J- [8 D5 }
  21. DELETE FROM Tbl_KeepId;( b/ ~2 O; Z) l! u# b
  22. DELETE FROM user_account;5 a9 m! w/ b4 e3 q
  23. DELETE FROM user_account;
    ) d$ I, T% x$ B* F" a* i( s8 V, H, I5 ?4 s& q
  24. DELETE FROM user_charge_log;( k& L# a) k6 b$ `& R; E
  25. DELETE FROM user_everyday_use_info;
    ; Q0 j- V: s7 d8 u+ n8 h; w3 V
  26. DELETE FROM user_give_log;
    6 t! Z' `9 b1 o  w$ W0 n( M
  27. DELETE FROM user_use_log;$ F' U( m; C! ?/ v+ m8 L3 q3 l* x
  28. DELETE FROM user_use_log_bk;
    ! J' A* B; V7 u" o  S2 Y' C8 z* l
  29. GO: E2 a1 g( ?+ F6 Q! A& {7 C
  30. use cash;
    - w" m  k! R5 l8 K
  31. DELETE FROM bl_error_log;
    * [  I( f0 x4 P: p! n: J
  32. DELETE FROM Tbl_Cash_zj;
    & k) F/ B& L# j( b5 A
  33. DELETE FROM user_cash;
    / A$ ~5 h# K5 v4 r  l8 w8 V  T2 p
  34. DELETE FROM user_charge_log;7 O& n! z3 X- h/ d
  35. DELETE FROM user_use_log;
    9 A. g7 S( F, j# n0 H5 k9 m
  36. GO; F6 d. _' ?+ I8 S% O/ S$ J  y% n$ u
  37. use character;
    7 o' q  J: N7 Y" C: I
  38. DELETE FROM C_EVENT_ITEM_OP  j; j, w4 Y1 ]7 T5 r
  39. DELETE FROM c_restword;# ?6 j5 L) J& ?. U  x% R$ q
  40. DELETE FROM char_connlog;
    7 G" ^$ q  p$ k5 k2 H
  41. DELETE FROM CHAR_CONNLOG_KEY;2 B$ b  h! N$ A4 Y- }$ T
  42. DELETE FROM DEL_USER_CHAR_LIST;
    # ?8 u& O$ J2 x$ E: ]
  43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;6 x) F0 ]' x" }5 X( ~1 ]! G) H  ?
  44. DELETE FROM GM_ITEM_MST;
    * m  V" I& B$ g
  45. DELETE FROM GUILD_CHAR_INFO;
    : t9 ]! z) F5 ~  d
  46. DELETE FROM GUILD_INFO" x$ G  Z8 \5 k: m, S
  47. WHERE guild_code NOT LIKE 'MASTERCODE';8 f% l/ z0 ^" E0 E, r- J
  48. DELETE FROM GUILD_INFO_SECEDE;) B2 C2 C# t& ~9 r2 V* d6 Y8 U: V7 ?
  49. DELETE FROM GUILD_PEERAGE
    % [, j/ a' y2 h
  50. WHERE guild_code NOT LIKE 'MASTERCODE';
    4 d' R( B. d1 G6 e2 q9 T: s
  51. DELETE FROM MSSNGR_CHAR_LIST;) `4 p- T( ^" x- \
  52. DELETE FROM SIEGE_INFO;9 b& _# Z7 V8 p4 d# K$ m! t
  53. DELETE FROM SIEGE_RESULT_LOG;
    # k( S9 R" }+ O5 ?+ N4 k
  54. DELETE FROM user_bag
    - @6 X& ~- n+ Y3 z2 I
  55. WHERE character_no NOT LIKE 'DEKARON_000001';, O2 r' G3 u7 @- G9 ?
  56. DELETE FROM user_bag_copy;8 H0 o9 T% }6 j. |" R, D
  57. DELETE FROM user_bag_secede;
    % S; G" n' B) ^' T1 l9 c
  58. DELETE FROM user_character
    , |4 J% y; r) y7 \7 t
  59. WHERE character_no NOT LIKE 'DEKARON_000001';
    . T0 R$ f3 s* s3 N1 t: w/ d: D
  60. DELETE FROM user_character_secede;; u4 C+ M$ j! s: P7 q) i% r
  61. DELETE FROM USER_POSTBOX;
    . H, s$ L- ~. l
  62. DELETE FROM USER_POSTBOX_SECEDE;/ a+ d! L' T0 S5 v' n
  63. DELETE FROM User_Quest_Doing;6 ?2 {2 q* [" L# m! w
  64. DELETE FROM user_quest_doing_secede;) L& F; O. Y. _" a
  65. DELETE FROM User_Quest_Done;
    : \3 _$ e  M3 @% F% z
  66. DELETE FROM user_quest_done_secede;
    * m6 `- R! U% p. g
  67. DELETE FROM user_skill
    2 o4 t( u' j- w: W
  68. WHERE character_no NOT LIKE 'DEKARON_000001';
    & n! S7 N8 f6 O1 n$ K
  69. DELETE FROM user_skill_secede3 q/ \$ N; `4 e, I. S9 l. N
  70. DELETE FROM user_slot8 E  g! O% {2 {8 Z
  71. WHERE character_no NOT LIKE 'DEKARON_000001';) m$ y0 l) g5 p% _: X# M
  72. DELETE FROM user_storage;) L# S! P( J+ T, C% k) O2 R: j
  73. DELETE FROM user_storage_copy;/ X% ^: B9 z1 x2 F$ G) ^
  74. DELETE FROM USER_STORE;
    : c& d( Y+ i+ h$ y. [
  75. DELETE FROM USER_STORE_copy;7 l3 @2 Z1 Z7 p
  76. DELETE FROM USER_STORE_SECEDE;/ C, Y' N" p/ W/ |. M) j% T& G6 \
  77. DELETE FROM user_suit
    # S7 s% z( N# O1 i' k
  78. WHERE character_no NOT LIKE 'DEKARON_000001';
    9 P3 s1 \) ^8 K
  79. DELETE FROM user_suit_copy;& [; Q$ L4 V0 {# o& m6 K
  80. DELETE FROM user_suit_secede;9 Y7 F" ?# P6 h7 E
  81. GO
复制代码
( g' h( A/ x! q
$ Y' I$ }5 S- A/ D% I! a9 U, s# u
商业服务端 登录器 网站 出售

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:56
3 `8 @0 U# d- i9 Y语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~!
# W; b' A% _. ?: p/ m* S
帖子里面有复制功能
商业服务端 登录器 网站 出售
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则


Archiver|小黑屋|EGameol

GMT+8, 2026-1-1 15:09 , Processed in 0.069424 second(s), 23 queries .

Powered by Discuz! X3.5

Copyright © 2001-2020, Tencent Cloud.

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