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

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

[复制链接]

151

主题

322

回帖

5559

积分

管理员

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

  1. 2 U( B6 f" ~  i8 @8 u; a
  2. # W9 |0 X9 s* K% c3 H
  3. use account;$ i5 j- T. E3 b6 f
  4. DELETE FROM C_IP_BAN;8 M9 ?/ o+ i! N( D3 f. }) V8 B- s
  5. DELETE FROM C_IP_PERMIT;
    + T: u" O" O, @3 N
  6. DELETE FROM C_IP_PWD;0 g. J3 ~* D4 E6 A* S2 Z4 q* U
  7. DELETE FROM C_LOGINIPBLOCK_LOG;4 m6 L+ M8 u$ U9 d5 `
  8. DELETE FROM C_SEQUENCE;% x9 |" @2 C3 }, W! h  F6 P
  9. DELETE FROM CP_USER_PROFILE;
    % L2 Z1 b! W! v: n
  10. DELETE FROM MB_USR_IP;# v+ P  A/ U( Q9 D& F2 ^! T5 C
  11. DELETE FROM MB_USR_PUN;2 I: h2 u( S# a
  12. DELETE FROM Tbl_user;
    1 F$ f: s. b6 [* x) C! d
  13. DELETE FROM USER_CONNLOG_KEY;
    ' \3 J, {. {7 r& t) T. l6 z
  14. DELETE FROM USER_PROFILE;* e: f. F7 m3 G0 }' j* i
  15. GO6 P( C. ?" s% t
  16. use billing;8 j9 a/ f1 N1 u; {/ L
  17. DELETE FROM bl_error_log;' J! q( t" E, F6 c
  18. DELETE FROM c_sequence;
    / p% G# v  u- }
  19. DELETE FROM dba_online_daily;
    0 ?; @, R+ w9 T; m, h
  20. DELETE FROM dba_online_daily_notok;9 M% S9 F, [6 O4 k, \
  21. DELETE FROM Tbl_KeepId;6 n$ f  n7 U+ P9 i
  22. DELETE FROM user_account;" g+ D8 Y; z" M2 q) |. a& ~0 C% |2 O8 u
  23. DELETE FROM user_account;/ Y% ~2 `9 w/ t/ d1 ?
  24. DELETE FROM user_charge_log;8 L5 c- s6 @8 s5 |" u/ F2 y3 I& W
  25. DELETE FROM user_everyday_use_info;
    6 j& y7 E: h( p3 F+ ^) G
  26. DELETE FROM user_give_log;6 a$ m6 k& K9 z: w4 _& H7 s
  27. DELETE FROM user_use_log;( R; U' }) Z2 `3 k
  28. DELETE FROM user_use_log_bk;, D, z2 R$ c8 h7 N/ X
  29. GO
    " h2 H& ]. I8 [, [$ |
  30. use cash;8 I) |3 C1 \$ q' o, r' ?
  31. DELETE FROM bl_error_log;7 _6 f6 h8 j4 E/ v" W2 ^1 u1 |& F
  32. DELETE FROM Tbl_Cash_zj;
    : h& H6 f! V0 F) K# }
  33. DELETE FROM user_cash;, j1 p4 D3 @! c7 b( F
  34. DELETE FROM user_charge_log;
    " n5 ?/ {) l3 ^
  35. DELETE FROM user_use_log;
    " Z' m% f$ V) x1 X9 a6 ?
  36. GO) s& E# e, ?7 z/ d
  37. use character;
    / G- s# w- i4 T0 Y( g7 A/ g
  38. DELETE FROM C_EVENT_ITEM_OP, a; P9 r5 U3 y4 u1 v8 X
  39. DELETE FROM c_restword;
    + H4 \6 v9 D4 ~& Y( O0 m+ s: Q
  40. DELETE FROM char_connlog;
      y+ ^! H3 K6 y" j0 k& C
  41. DELETE FROM CHAR_CONNLOG_KEY;
    $ J. d: A9 L* ^/ b$ Z! s) J. {
  42. DELETE FROM DEL_USER_CHAR_LIST;
    4 D: M" V6 ]- F: }7 b6 q+ g  @  C# s
  43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;4 G+ s* j* u6 M3 k/ c0 j9 Y; s: J
  44. DELETE FROM GM_ITEM_MST;
    $ N- t: i. O, N
  45. DELETE FROM GUILD_CHAR_INFO;
    ' H" }2 [7 f, q5 c* \8 X9 R" @% |
  46. DELETE FROM GUILD_INFO1 e2 r& W: r# \. g
  47. WHERE guild_code NOT LIKE 'MASTERCODE';
    9 P1 m& w- F: v1 C( o" w
  48. DELETE FROM GUILD_INFO_SECEDE;6 r* g* n4 D+ l  z) p# j2 f9 l6 m
  49. DELETE FROM GUILD_PEERAGE( z; A- a7 K; @5 z8 q, ]% ^) R
  50. WHERE guild_code NOT LIKE 'MASTERCODE';. n) n0 E" r2 J3 g8 E1 U
  51. DELETE FROM MSSNGR_CHAR_LIST;
    . r) X6 u2 e" p2 C4 d1 `
  52. DELETE FROM SIEGE_INFO;0 {/ Z! b0 e$ N$ }( X
  53. DELETE FROM SIEGE_RESULT_LOG;
    , {4 J' [' [3 h( }, Q
  54. DELETE FROM user_bag
    ' a7 D, |. T2 i1 w# y( f
  55. WHERE character_no NOT LIKE 'DEKARON_000001';4 ~) q+ `( {9 R/ d
  56. DELETE FROM user_bag_copy;
    4 x: |9 R; e6 l2 v5 b1 j& }. F% p
  57. DELETE FROM user_bag_secede;) ^4 f# G0 A% s
  58. DELETE FROM user_character9 q# [3 f$ g9 q9 g8 f/ f5 B
  59. WHERE character_no NOT LIKE 'DEKARON_000001';
    * W$ n" Y/ O! I# Z
  60. DELETE FROM user_character_secede;. ~+ l' U% R( E: }$ s4 k: h
  61. DELETE FROM USER_POSTBOX;. `+ a2 y) O0 h  V$ W" ?% X
  62. DELETE FROM USER_POSTBOX_SECEDE;
    + e! H* r! ^% O  n$ J
  63. DELETE FROM User_Quest_Doing;
    7 c3 r' g# L" G$ N
  64. DELETE FROM user_quest_doing_secede;  H/ Z: j: c  W# E  }- J
  65. DELETE FROM User_Quest_Done;1 P: C0 K! ]5 n* T& b" f$ h4 R
  66. DELETE FROM user_quest_done_secede;
    * E3 V/ I1 V) L$ o
  67. DELETE FROM user_skill$ o" ]/ M! a% y0 L; C  D
  68. WHERE character_no NOT LIKE 'DEKARON_000001';
    / x5 _' n6 _; ^
  69. DELETE FROM user_skill_secede
    - a2 L* V0 A; [. T* D
  70. DELETE FROM user_slot6 V  \' s' k$ a' ~  U
  71. WHERE character_no NOT LIKE 'DEKARON_000001';0 j# }1 \* |3 X2 Q
  72. DELETE FROM user_storage;
    , w! u+ k' `' E
  73. DELETE FROM user_storage_copy;
    ( X6 O/ ]) b$ f( [
  74. DELETE FROM USER_STORE;2 ]4 D) F5 }$ V; W
  75. DELETE FROM USER_STORE_copy;, C" w$ `6 n8 ]3 U' l$ u+ c3 r
  76. DELETE FROM USER_STORE_SECEDE;7 X& A) x& x* h; G$ P6 h
  77. DELETE FROM user_suit. {8 h1 V" u  r/ y
  78. WHERE character_no NOT LIKE 'DEKARON_000001';
    6 n3 p! t- E1 {
  79. DELETE FROM user_suit_copy;/ H% ]/ `7 J$ y5 M" C" V0 L
  80. DELETE FROM user_suit_secede;, L6 v- u3 E" o! H& d2 v
  81. GO
复制代码

' R$ m" A! d1 I2 B9 F0 T; R* g% \
商业服务端 登录器 网站 出售

13

主题

250

回帖

1193

积分

高级会员

积分
1193
金钱
761
贡献
164
注册时间
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

回帖

5242

积分

论坛元老

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

151

主题

322

回帖

5559

积分

管理员

积分
5559
金钱
1760
贡献
3326
注册时间
2023-11-3
QQ
 楼主| 发表于 2024-10-16 16:39:16 | 显示全部楼层
大张 发表于 2024-10-16 14:56
9 C7 O( G0 T! ~语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~!
% |! Q3 L( \& H: k
帖子里面有复制功能
商业服务端 登录器 网站 出售
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则


Archiver|小黑屋|EGameol

GMT+8, 2025-10-31 01:52 , Processed in 0.057699 second(s), 23 queries .

Powered by Discuz! X3.5

Copyright © 2001-2020, Tencent Cloud.

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