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

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

[复制链接]

167

主题

431

回帖

8422

积分

管理员

积分
8422
金钱
2429
贡献
5395
注册时间
2023-11-3
QQ
发表于 2024-1-28 20:00:01 | 显示全部楼层 |阅读模式
  1. % m6 V. K! n( a

  2. ; h8 R) Y9 D" @1 u! {: i
  3. use account;7 e7 W* M1 ^) k. I! X- ^
  4. DELETE FROM C_IP_BAN;
    2 ]$ l$ S3 J" M! g, j) o
  5. DELETE FROM C_IP_PERMIT;! V9 r7 k# q- }
  6. DELETE FROM C_IP_PWD;& n. ?0 F2 p3 H; Y# ?& a. a
  7. DELETE FROM C_LOGINIPBLOCK_LOG;
    * A8 G# O! t1 s2 Z. I& @
  8. DELETE FROM C_SEQUENCE;
    ; w6 K4 c( O# z# M; \; @# k5 N! @
  9. DELETE FROM CP_USER_PROFILE;7 Z' N" |2 p' K6 l
  10. DELETE FROM MB_USR_IP;
    ; }5 ]% j3 j; q& r
  11. DELETE FROM MB_USR_PUN;9 b$ Z9 h7 t4 t- G+ s8 d8 I0 p8 m" U
  12. DELETE FROM Tbl_user;' V) f' d' {& E% }5 Q& n. R0 n
  13. DELETE FROM USER_CONNLOG_KEY;
    ( C; \9 f" [4 A
  14. DELETE FROM USER_PROFILE;/ ^+ A& |  G1 x7 c4 L7 g+ s
  15. GO
    3 D& o2 h- F5 X! |9 a
  16. use billing;7 n$ ^! a: w6 f* e
  17. DELETE FROM bl_error_log;
    ; P5 h4 n; i9 d; `/ ^
  18. DELETE FROM c_sequence;' q9 w+ C+ U6 ?0 Q; |. C; U
  19. DELETE FROM dba_online_daily;2 e5 S) z6 _( @: W7 U8 y
  20. DELETE FROM dba_online_daily_notok;7 [7 Z- T9 Y; w
  21. DELETE FROM Tbl_KeepId;2 A4 F3 J7 w6 C% u
  22. DELETE FROM user_account;+ e: D5 V/ q  @/ n  I' Y
  23. DELETE FROM user_account;8 M+ ]- A7 l; P) m( c
  24. DELETE FROM user_charge_log;
    ( |; h( Y; A  l3 t/ u
  25. DELETE FROM user_everyday_use_info;4 \% `: X% m+ t3 i! g0 U
  26. DELETE FROM user_give_log;
    / W, R; x! ?' U, f# R
  27. DELETE FROM user_use_log;
    . t* J+ ^# P( B" F
  28. DELETE FROM user_use_log_bk;
    ! S) u. b& i: n/ {% ~4 d  J
  29. GO
    1 f: L3 M& p1 R5 W
  30. use cash;
    8 T! U" {% `' ?1 f/ W$ P  `7 z
  31. DELETE FROM bl_error_log;
    4 Z* \; L; }) B* B# [$ @. k
  32. DELETE FROM Tbl_Cash_zj;& k& v" }4 ^$ i8 A4 K- c
  33. DELETE FROM user_cash;
    8 z! D0 v7 U# n2 X7 S. z
  34. DELETE FROM user_charge_log;
    ' x" Z! O; E' E+ n
  35. DELETE FROM user_use_log;
    / y: R7 i; K2 X
  36. GO
    . c1 B1 R7 G5 i' e
  37. use character;& }% }7 ], o5 A( \
  38. DELETE FROM C_EVENT_ITEM_OP
    . F# s' [& X, f: ^. W: n
  39. DELETE FROM c_restword;* t7 \" K% e% i6 V
  40. DELETE FROM char_connlog;
    % E2 f+ w" b9 Z4 D+ ]
  41. DELETE FROM CHAR_CONNLOG_KEY;
    & D  h. A1 w: {3 b
  42. DELETE FROM DEL_USER_CHAR_LIST;  K0 W# O  K/ N
  43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    & a  O' a0 N- q  n
  44. DELETE FROM GM_ITEM_MST;
    & b: {3 @7 r8 v; P# Q
  45. DELETE FROM GUILD_CHAR_INFO;
    . C$ j6 f, m0 V% f  ?- S+ h* m9 V
  46. DELETE FROM GUILD_INFO
    / c3 z  X2 e' \* M- Q* A  s' O
  47. WHERE guild_code NOT LIKE 'MASTERCODE';6 N  C5 K) U8 e& E6 x9 _
  48. DELETE FROM GUILD_INFO_SECEDE;
    , D9 B1 T$ S" s/ B
  49. DELETE FROM GUILD_PEERAGE+ T( f9 ?& b3 N- I8 a
  50. WHERE guild_code NOT LIKE 'MASTERCODE';
    ; q+ n3 _) E8 N/ T1 K( r' e# Z
  51. DELETE FROM MSSNGR_CHAR_LIST;. W- b: g8 Y& L( E; v: k+ I8 [
  52. DELETE FROM SIEGE_INFO;  g  ^5 _' M4 o; _, X* g. ~& l0 p
  53. DELETE FROM SIEGE_RESULT_LOG;
    / {. j3 ~" {9 b- {
  54. DELETE FROM user_bag
    ' K# B1 M9 _& o* i8 }' R
  55. WHERE character_no NOT LIKE 'DEKARON_000001';3 D, {/ V% Z: p- s" X
  56. DELETE FROM user_bag_copy;
    * Z2 }, U0 O7 {& `  W4 n; s
  57. DELETE FROM user_bag_secede;( y: U/ e$ W4 {% W
  58. DELETE FROM user_character8 b- {0 Q9 U% j
  59. WHERE character_no NOT LIKE 'DEKARON_000001';/ S. G  f0 e' u6 K
  60. DELETE FROM user_character_secede;) X0 T- V/ {( R4 T
  61. DELETE FROM USER_POSTBOX;9 r' j/ p( B9 ~4 F
  62. DELETE FROM USER_POSTBOX_SECEDE;
    " P& v1 Y! L% s- X
  63. DELETE FROM User_Quest_Doing;6 n; f! I8 A, N, v# i" r; g) l
  64. DELETE FROM user_quest_doing_secede;0 z5 ^. ]4 r' f: ^! q$ l# L8 q
  65. DELETE FROM User_Quest_Done;* V& I; O  G( z# v
  66. DELETE FROM user_quest_done_secede;
    ' J. ^  a2 a7 n4 ]8 h* _
  67. DELETE FROM user_skill- @9 ~& t( O/ p5 R
  68. WHERE character_no NOT LIKE 'DEKARON_000001';
    * A& i4 X- Z3 w! K$ W% S
  69. DELETE FROM user_skill_secede
    " O% _7 p# o! i+ ]7 K" S
  70. DELETE FROM user_slot  j% \4 J' I5 }1 S
  71. WHERE character_no NOT LIKE 'DEKARON_000001';' D$ g9 R* ?( z) J0 s' ~3 v
  72. DELETE FROM user_storage;
    0 B) t6 T" }. }. f
  73. DELETE FROM user_storage_copy;
    1 F9 S$ n& `1 x
  74. DELETE FROM USER_STORE;% i$ q% A, A8 `4 E- ?& U  ]
  75. DELETE FROM USER_STORE_copy;* A5 i) n( G8 `* Z8 Z' f( a
  76. DELETE FROM USER_STORE_SECEDE;- ^6 X# M3 P* `. @
  77. DELETE FROM user_suit
    ! ~# D" Y: B( Q/ ~; ~, g$ C% r
  78. WHERE character_no NOT LIKE 'DEKARON_000001';
    : |! [8 g/ x2 p- y6 n# A) z, C
  79. DELETE FROM user_suit_copy;
    " F  A, v4 Y* j% `$ D8 `
  80. DELETE FROM user_suit_secede;6 R( l* S$ B# e- i# w7 ~
  81. GO
复制代码

% }) ?2 W! Z# u3 n7 n+ I5 x' Q( L! A) ?+ Y; @; K! p
商业服务端 登录器 网站 出售

16

主题

271

回帖

1616

积分

金牌会员

积分
1616
金钱
1168
贡献
156
注册时间
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

主题

73

回帖

1万

积分

论坛元老

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

167

主题

431

回帖

8422

积分

管理员

积分
8422
金钱
2429
贡献
5395
注册时间
2023-11-3
QQ
发表于 2024-10-16 16:39:16 | 显示全部楼层
大张 发表于 2024-10-16 14:56
8 F+ b: a) ~. A# k- t" A+ v语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~!
: T" a7 k* b: ]1 F
帖子里面有复制功能
商业服务端 登录器 网站 出售
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则


Archiver|小黑屋|EGameol

GMT+8, 2026-11-19 10:25 , Processed in 0.073310 second(s), 26 queries .

Powered by Discuz! X3.5

© 2001-2026 Discuz! Team.

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