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

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

[复制链接]

157

主题

362

回帖

6843

积分

管理员

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

  1. " d8 p* F0 [- C( u# F" V
  2. / C; }6 X# W+ T8 e# x9 ^" f2 K
  3. use account;* ?7 P. }3 A8 m' S3 n0 k6 Y/ L
  4. DELETE FROM C_IP_BAN;
    & |5 ]1 [. H; `0 o* n6 Z' k- Z
  5. DELETE FROM C_IP_PERMIT;
    $ D  {# m* ?. k: _" A) l$ w
  6. DELETE FROM C_IP_PWD;) ]& c; g1 C  M
  7. DELETE FROM C_LOGINIPBLOCK_LOG;9 b0 Q3 n! L) s; r* h4 V; F1 H" f
  8. DELETE FROM C_SEQUENCE;; r9 T7 u+ a2 |* ~
  9. DELETE FROM CP_USER_PROFILE;0 w% \* u8 @0 T* D( u) m; R) |% Q3 R
  10. DELETE FROM MB_USR_IP;- f- @: L/ g+ H
  11. DELETE FROM MB_USR_PUN;
    * K  I4 ?$ ]# q* S7 k2 L
  12. DELETE FROM Tbl_user;9 G8 P6 [3 x3 ]' z& R
  13. DELETE FROM USER_CONNLOG_KEY;
    + R+ ?/ P! _1 B
  14. DELETE FROM USER_PROFILE;
    8 v& Y3 E6 i0 `) @
  15. GO+ a- W4 |& N0 w) [1 h# c
  16. use billing;% d" B1 E+ e; [8 ]& O
  17. DELETE FROM bl_error_log;4 [- P9 a, Q9 Z: n  p" h
  18. DELETE FROM c_sequence;" o' I# m. q$ z
  19. DELETE FROM dba_online_daily;# Y+ u5 r5 z. k% X
  20. DELETE FROM dba_online_daily_notok;
    ) L5 Y: }# Q- s# R
  21. DELETE FROM Tbl_KeepId;
    ; H1 n2 ?! i% j; x# H
  22. DELETE FROM user_account;
    ) M7 Z+ c8 q2 b" k( e& ~! w$ l* y
  23. DELETE FROM user_account;2 K  L6 v  |! V& e
  24. DELETE FROM user_charge_log;- o, K0 d7 w% [: u6 ?5 J; X' P; J
  25. DELETE FROM user_everyday_use_info;
    # _  ~/ b* L  K% ^
  26. DELETE FROM user_give_log;
    ( q4 o$ s2 M' ^( I( F- O8 L
  27. DELETE FROM user_use_log;
    + Y, p* n% z  r* T+ U6 A8 |
  28. DELETE FROM user_use_log_bk;! L% n2 |6 Q4 I* c7 O6 W
  29. GO
    ! {! E1 R9 r1 T  M; O
  30. use cash;. p2 L+ C. V, O  y6 X1 w
  31. DELETE FROM bl_error_log;
    7 S6 T9 `' w: {* o5 A, ~' h3 O9 d
  32. DELETE FROM Tbl_Cash_zj;
    7 F6 _4 R5 C' k% B6 c4 O9 S
  33. DELETE FROM user_cash;  e" Q; O5 R6 X
  34. DELETE FROM user_charge_log;( j& Y  m# B% j) T
  35. DELETE FROM user_use_log;; I4 n+ k$ |, D# f, C- R3 [
  36. GO
    ; U3 x+ S! r- V4 y5 o. Z
  37. use character;! b. s# O+ A2 }4 |" W( B( }" N
  38. DELETE FROM C_EVENT_ITEM_OP4 v' J2 G" m8 K
  39. DELETE FROM c_restword;" D5 b) t3 t% j5 ~; n
  40. DELETE FROM char_connlog;
    # Z$ Y# [3 N, o1 @& ?: V5 i
  41. DELETE FROM CHAR_CONNLOG_KEY;% ?) J1 `  ]. k# P
  42. DELETE FROM DEL_USER_CHAR_LIST;" e% d4 u" _2 [  n% f, P, o, g, o
  43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;' }# b4 B8 s3 Z/ Y/ `
  44. DELETE FROM GM_ITEM_MST;
    ! E3 N! d; j, A9 _7 }( C
  45. DELETE FROM GUILD_CHAR_INFO;* M1 a2 [. n3 V. c. x: J
  46. DELETE FROM GUILD_INFO
    . s7 v; C0 E" U. M! v) a9 Z
  47. WHERE guild_code NOT LIKE 'MASTERCODE';  @/ Z1 \" A/ r& \3 r
  48. DELETE FROM GUILD_INFO_SECEDE;/ f6 E# t; M' }" Y3 K1 O9 H
  49. DELETE FROM GUILD_PEERAGE7 k9 J9 r! y4 T/ z% I, C
  50. WHERE guild_code NOT LIKE 'MASTERCODE';, `6 ~. F' U! a2 O- F( [( y
  51. DELETE FROM MSSNGR_CHAR_LIST;
    ! k: j9 r* N7 I) i& Q
  52. DELETE FROM SIEGE_INFO;
    / y. ?7 O: q& `- A7 e1 g! B
  53. DELETE FROM SIEGE_RESULT_LOG;
    ! _" I: c4 m# U/ D2 \1 N
  54. DELETE FROM user_bag; `4 o7 N5 J" I  Q! e2 }, g
  55. WHERE character_no NOT LIKE 'DEKARON_000001';/ R$ C( f- s/ t8 _
  56. DELETE FROM user_bag_copy;
    : B8 g3 y# G  P  K6 k" d; m
  57. DELETE FROM user_bag_secede;. [/ k) O: u# q  x' K5 f6 N
  58. DELETE FROM user_character* F/ R, E3 Q) }/ f- w' H) O6 n
  59. WHERE character_no NOT LIKE 'DEKARON_000001';
    + D- b2 r& c3 y+ i4 ]
  60. DELETE FROM user_character_secede;2 t; |. [$ R  p8 M; [1 F6 o
  61. DELETE FROM USER_POSTBOX;* U4 e6 H: ~3 a- A
  62. DELETE FROM USER_POSTBOX_SECEDE;
    + w; p8 Y! q* A9 z$ \" G, u# D
  63. DELETE FROM User_Quest_Doing;8 w; P; L0 f  p" T! h
  64. DELETE FROM user_quest_doing_secede;
    % J) F$ k- ]* R
  65. DELETE FROM User_Quest_Done;% i  d+ V; ]0 L8 N7 L
  66. DELETE FROM user_quest_done_secede;
    7 r! N1 y, a$ t" f; o
  67. DELETE FROM user_skill! \' i2 `& F% t+ E$ H& Z
  68. WHERE character_no NOT LIKE 'DEKARON_000001';
    & {3 Q8 A& Z/ k
  69. DELETE FROM user_skill_secede$ J/ Z# p+ X6 p5 c+ @
  70. DELETE FROM user_slot
    ( n/ c2 B# N. s; S7 w4 A
  71. WHERE character_no NOT LIKE 'DEKARON_000001';
    ! Z4 C. S7 e% x/ c# e/ ]! P
  72. DELETE FROM user_storage;
    7 @) `2 n2 y- _( @) s% R
  73. DELETE FROM user_storage_copy;' H# W* j8 M" d1 r! Z9 Y' @
  74. DELETE FROM USER_STORE;
    4 `% k; b) @6 u9 a8 U9 F: M
  75. DELETE FROM USER_STORE_copy;/ n6 ]: A3 b$ p  e4 S5 U
  76. DELETE FROM USER_STORE_SECEDE;0 j* v% L# y% n+ ]- m( S2 E
  77. DELETE FROM user_suit
    7 z# [" a& \/ m, E/ x0 ~+ H& ~
  78. WHERE character_no NOT LIKE 'DEKARON_000001';
    ) i* D/ i( M- d# q! }4 e3 b
  79. DELETE FROM user_suit_copy;* F5 B9 {0 j) u% \0 V
  80. DELETE FROM user_suit_secede;  v2 J) u) p; A8 q* n
  81. GO
复制代码
5 l9 V& k7 _2 ]8 B
4 V) l0 n" e, w9 \
商业服务端 登录器 网站 出售

15

主题

256

回帖

1271

积分

金牌会员

积分
1271
金钱
873
贡献
122
注册时间
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

回帖

7401

积分

论坛元老

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

157

主题

362

回帖

6843

积分

管理员

积分
6843
金钱
1944
贡献
4380
注册时间
2023-11-3
QQ
 楼主| 发表于 2024-10-16 16:39:16 | 显示全部楼层
大张 发表于 2024-10-16 14:56" d4 X7 i$ j; s5 c. P
语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~!

- H( m0 R8 X& `( o帖子里面有复制功能
商业服务端 登录器 网站 出售
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则


Archiver|小黑屋|EGameol

GMT+8, 2026-2-16 10:43 , Processed in 0.053069 second(s), 23 queries .

Powered by Discuz! X3.5

Copyright © 2001-2020, Tencent Cloud.

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