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

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

[复制链接]

134

主题

166

回帖

2947

积分

管理员

积分
2947
金钱
980
贡献
1667
注册时间
2023-11-3
QQ
发表于 2024-1-28 20:00:01 | 显示全部楼层 |阅读模式
  1. 8 ~9 F% y, M2 t/ \' x9 o2 A0 H& [

  2. ; Q8 ~) p8 ^+ {% O0 _4 o( [2 O, R6 X
  3. use account;2 m! S! x/ a. [5 P8 e) m
  4. DELETE FROM C_IP_BAN;
    ) ~5 t" ~# w- W
  5. DELETE FROM C_IP_PERMIT;% Q0 {! n. w# T- A+ |% W  N
  6. DELETE FROM C_IP_PWD;( ~0 G7 J/ m/ U# J" s
  7. DELETE FROM C_LOGINIPBLOCK_LOG;' ^6 h2 v6 I! D
  8. DELETE FROM C_SEQUENCE;
    3 J, O  J' k: }9 x" h
  9. DELETE FROM CP_USER_PROFILE;9 g4 ?$ t. i/ B  w: f+ b  v
  10. DELETE FROM MB_USR_IP;/ C( n5 \- |" d5 x; j  I/ l
  11. DELETE FROM MB_USR_PUN;
    ! {: B& f/ |3 N$ l8 Q, \
  12. DELETE FROM Tbl_user;5 K" o/ F$ u4 M* u* `
  13. DELETE FROM USER_CONNLOG_KEY;
    ; R: p- o4 i, P' G+ ^
  14. DELETE FROM USER_PROFILE;
    3 f! y  h& ~: h. |
  15. GO  F* g: }# M* s& F; o5 c6 {! |
  16. use billing;
    5 |+ [0 G8 a3 a3 v, d
  17. DELETE FROM bl_error_log;
    : ]# Q6 K& V+ F3 f0 O
  18. DELETE FROM c_sequence;) P6 v' `, ^- [; a# i
  19. DELETE FROM dba_online_daily;+ }9 E5 E4 }7 K" Y5 b
  20. DELETE FROM dba_online_daily_notok;
    $ p! v0 T( P" o3 k- j& S
  21. DELETE FROM Tbl_KeepId;
    1 C8 e5 y1 ^# L7 W
  22. DELETE FROM user_account;$ D9 E( Z5 T) t$ f5 a# j3 I! o3 Z2 ]# T
  23. DELETE FROM user_account;
    5 [8 u; _! w8 t' |' ^6 O1 ^
  24. DELETE FROM user_charge_log;
    ! ~7 p/ t9 P& G5 t1 \, `. R
  25. DELETE FROM user_everyday_use_info;. h) p% Z3 B* i6 p( f0 A
  26. DELETE FROM user_give_log;
    $ ^' R; g4 [2 T& v6 A
  27. DELETE FROM user_use_log;8 |+ ?% f0 s; t4 G+ D1 s+ i$ ^
  28. DELETE FROM user_use_log_bk;2 g9 N3 `3 n. }1 T9 D
  29. GO
    2 e4 @4 U0 c3 I9 _
  30. use cash;
    " _8 T, n8 z! t! M
  31. DELETE FROM bl_error_log;
    : ~. U9 J1 M" O0 M
  32. DELETE FROM Tbl_Cash_zj;
    " z1 L9 Y3 C5 w/ W
  33. DELETE FROM user_cash;
    . A' r. o2 _1 ]0 N# z0 J; D7 l# x
  34. DELETE FROM user_charge_log;7 c8 T1 Z7 }/ x
  35. DELETE FROM user_use_log;
    $ ^- P2 S- M5 Y( Q
  36. GO
    & l+ v: A( s" A/ a' {6 V
  37. use character;( ?' A+ ^0 Q/ i- U
  38. DELETE FROM C_EVENT_ITEM_OP3 W3 G1 F0 I& u% \
  39. DELETE FROM c_restword;
    0 P2 T7 u5 i) E& ]5 |1 V
  40. DELETE FROM char_connlog;4 |* Q  H- K3 I& ?$ o) X, |
  41. DELETE FROM CHAR_CONNLOG_KEY;$ A* b, f: X, E! {% p7 x* d
  42. DELETE FROM DEL_USER_CHAR_LIST;% o1 O# ~8 B. v6 G8 z9 K7 f
  43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    6 q8 k$ m2 i- Y
  44. DELETE FROM GM_ITEM_MST;
    : o6 _& B$ k+ i! J: E
  45. DELETE FROM GUILD_CHAR_INFO;. b6 a# U5 B* k% V
  46. DELETE FROM GUILD_INFO. S. o0 E4 e6 |0 @$ w! G+ E# h% @
  47. WHERE guild_code NOT LIKE 'MASTERCODE';* b+ z/ t: b4 L% U- W) ~: q
  48. DELETE FROM GUILD_INFO_SECEDE;
    6 ?' E0 i. [$ v# Y5 b3 y
  49. DELETE FROM GUILD_PEERAGE
    0 T6 \, y3 w$ C' ]; ]
  50. WHERE guild_code NOT LIKE 'MASTERCODE';% B- g! `7 A  v
  51. DELETE FROM MSSNGR_CHAR_LIST;
    : o5 e1 A% B  c0 w  p: B2 k& C0 b
  52. DELETE FROM SIEGE_INFO;
    0 @- l! k9 Q2 |, N
  53. DELETE FROM SIEGE_RESULT_LOG;" ~. {3 ^3 n' m# A
  54. DELETE FROM user_bag( g0 L8 U7 H2 Y% P5 g
  55. WHERE character_no NOT LIKE 'DEKARON_000001';
    , [. K: Q& c% ]7 }
  56. DELETE FROM user_bag_copy;
    : V% C3 V) P- x  k9 M; A* @/ [7 Z
  57. DELETE FROM user_bag_secede;
    9 p" {. R0 O! `6 i7 D
  58. DELETE FROM user_character
    + H% G; O: ?$ s3 N! d6 s
  59. WHERE character_no NOT LIKE 'DEKARON_000001';
    0 _4 S( {$ u# T( x
  60. DELETE FROM user_character_secede;
    . B& M& f% d: R3 v+ w! }  @
  61. DELETE FROM USER_POSTBOX;4 ]; K: M3 e0 z# S
  62. DELETE FROM USER_POSTBOX_SECEDE;
    3 @2 b. E' l. o) ~1 @7 V) S
  63. DELETE FROM User_Quest_Doing;
    4 H% x4 S9 Q; ~! C( i$ A
  64. DELETE FROM user_quest_doing_secede;
    + _$ U( H/ K" p
  65. DELETE FROM User_Quest_Done;
    " }* W# e  C$ G
  66. DELETE FROM user_quest_done_secede;
    $ b6 r% A, A6 L; w$ ?* C
  67. DELETE FROM user_skill
    7 R  Z# P! @; O0 S, u7 D
  68. WHERE character_no NOT LIKE 'DEKARON_000001';& Z3 ]9 V, O7 Q! d4 O% j
  69. DELETE FROM user_skill_secede
    9 w6 T1 @4 n) g" h
  70. DELETE FROM user_slot  Z3 d  I1 [2 D
  71. WHERE character_no NOT LIKE 'DEKARON_000001';
    & I: N2 d  ^1 M; N; U9 B+ e+ R1 s
  72. DELETE FROM user_storage;' P' f0 x0 @  [
  73. DELETE FROM user_storage_copy;0 Y, `+ U) K2 ^1 ]0 k# T7 `0 ?0 a
  74. DELETE FROM USER_STORE;
    % v: u/ Y; Y3 j4 K( S1 o" Y8 B
  75. DELETE FROM USER_STORE_copy;
    + T" b" m% f3 `) s
  76. DELETE FROM USER_STORE_SECEDE;) `' y; q; [6 A" N
  77. DELETE FROM user_suit
    2 L: c, k$ o0 _: L! n5 m) ?
  78. WHERE character_no NOT LIKE 'DEKARON_000001';* O( m4 l% h. o1 v; T2 C
  79. DELETE FROM user_suit_copy;0 S9 _, \0 U& D; W5 F5 |2 x
  80. DELETE FROM user_suit_secede;8 T+ A" N; Y- J& z% b
  81. GO
复制代码
; B) j6 [" h( v
* _! c0 J+ X( z  E3 T* o
商业服务端 登录器 网站 出售

8

主题

228

回帖

783

积分

高级会员

积分
783
金钱
451
贡献
91
注册时间
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

主题

125

回帖

445

积分

中级会员

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

0

主题

64

回帖

1166

积分

高级会员

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

134

主题

166

回帖

2947

积分

管理员

积分
2947
金钱
980
贡献
1667
注册时间
2023-11-3
QQ
 楼主| 发表于 2024-10-16 16:39:16 | 显示全部楼层
大张 发表于 2024-10-16 14:56
+ K2 h3 i- t2 r8 k5 U' G( F语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~!
$ g( f8 A$ K; J  z! S
帖子里面有复制功能
商业服务端 登录器 网站 出售
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

Archiver|手机版|小黑屋|EGameol

GMT+8, 2025-1-18 15:43 , Processed in 0.051836 second(s), 21 queries .

Powered by Discuz! X3.5

Copyright © 2001-2020, Tencent Cloud.

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