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

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

[复制链接]

139

主题

236

回帖

4114

积分

管理员

积分
4114
金钱
1476
贡献
2263
注册时间
2023-11-3
QQ
发表于 2024-1-28 20:00:01 | 显示全部楼层 |阅读模式
  1.   V7 ?6 H, R) @0 ?$ g2 k. Y
  2. & i! x* `, t9 P/ T
  3. use account;$ z6 u" T( x6 V/ G4 ]5 k
  4. DELETE FROM C_IP_BAN;
    $ d7 R+ C" O, f
  5. DELETE FROM C_IP_PERMIT;
    9 D" u& E; c* N% d
  6. DELETE FROM C_IP_PWD;
    # h5 {5 |* u, u, W+ s
  7. DELETE FROM C_LOGINIPBLOCK_LOG;
    5 V% ?( z4 E% w* _, e
  8. DELETE FROM C_SEQUENCE;
    " f* \' y  P3 ]0 ~0 R
  9. DELETE FROM CP_USER_PROFILE;
    / @4 u& O4 o$ f3 T
  10. DELETE FROM MB_USR_IP;
    + q# C! R' @, X. @
  11. DELETE FROM MB_USR_PUN;& q. c' E( `$ h
  12. DELETE FROM Tbl_user;+ W  B/ N- ~3 O! z
  13. DELETE FROM USER_CONNLOG_KEY;: t: H6 _  i- n  C) Y4 r: d
  14. DELETE FROM USER_PROFILE;: Q7 g& D! t! h4 Z! W# s8 l/ s; K
  15. GO1 R( F3 X3 G# r- b$ W1 N% r2 [
  16. use billing;
    0 B2 l" Q: z1 h: D0 l/ E# y$ T/ h
  17. DELETE FROM bl_error_log;
    ( ^& i* c2 g' _  O8 K
  18. DELETE FROM c_sequence;1 @  b* U' s1 Z. }
  19. DELETE FROM dba_online_daily;
    3 C+ e4 U1 z9 H3 i  `
  20. DELETE FROM dba_online_daily_notok;$ y3 h! W! Q' a, w
  21. DELETE FROM Tbl_KeepId;6 T2 d$ F  z& V- X1 q8 r
  22. DELETE FROM user_account;
    ) J+ R( m& w8 }
  23. DELETE FROM user_account;& y" E; g1 m( b6 @( L* B& U" _! J
  24. DELETE FROM user_charge_log;6 M! X" K) B+ J3 c
  25. DELETE FROM user_everyday_use_info;9 F) ^2 u7 J$ e3 N" R, W
  26. DELETE FROM user_give_log;  N3 J; g& p8 v+ [
  27. DELETE FROM user_use_log;* }( T; k1 s# T) X
  28. DELETE FROM user_use_log_bk;
    & p* Z. M6 X" g; N8 o
  29. GO1 `  `3 q1 ?$ W3 i+ H( o2 \
  30. use cash;) Y- T% @2 x' N, @7 M- b9 F0 }' U& _
  31. DELETE FROM bl_error_log;
    - x' q2 w+ Z. d2 }, h) f
  32. DELETE FROM Tbl_Cash_zj;
    4 P) p$ y# z; y: C$ V: q
  33. DELETE FROM user_cash;' V9 Z& w+ U- K1 l. Z+ v
  34. DELETE FROM user_charge_log;
    1 F  H! ]6 j1 U3 _% ~7 Q* L
  35. DELETE FROM user_use_log;+ Q3 Y* [  }3 ~$ S$ a- ?7 m8 v1 B8 J
  36. GO
    5 P9 c5 D8 U# x2 i( k  r) t6 |8 n
  37. use character;: s9 L& V* ]  {" w! D; O6 ^
  38. DELETE FROM C_EVENT_ITEM_OP
    . ]$ _- Z+ d8 d; Q1 e6 |
  39. DELETE FROM c_restword;
    8 l6 p. `  o/ M, D0 L( m
  40. DELETE FROM char_connlog;9 N. r6 c8 l% D# [, U
  41. DELETE FROM CHAR_CONNLOG_KEY;3 h5 o. S$ T' Q# b9 w0 k' ?
  42. DELETE FROM DEL_USER_CHAR_LIST;
    ' f3 `  J9 P5 B/ W5 {! v
  43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;2 {/ k+ L8 r- j. z  [0 G
  44. DELETE FROM GM_ITEM_MST;- G3 v  E4 R( Q3 b$ X, |8 w
  45. DELETE FROM GUILD_CHAR_INFO;
      X1 _! s. M. f. v
  46. DELETE FROM GUILD_INFO& H" O! K, e. Q0 t! K. c
  47. WHERE guild_code NOT LIKE 'MASTERCODE';
    5 C- n: U- m! X& |$ f
  48. DELETE FROM GUILD_INFO_SECEDE;  U0 P  T5 t* m. C% D. f8 i
  49. DELETE FROM GUILD_PEERAGE
    & g! f+ Z: a9 v, X! q& n
  50. WHERE guild_code NOT LIKE 'MASTERCODE';3 E! y/ ^+ W/ p( Q. L
  51. DELETE FROM MSSNGR_CHAR_LIST;9 P  z) G  |  y3 e) F* y' y- n
  52. DELETE FROM SIEGE_INFO;. h( Q, ~2 X  z) E( _
  53. DELETE FROM SIEGE_RESULT_LOG;" \3 D0 I7 B  P. L+ B
  54. DELETE FROM user_bag% M! A, C) q- H' @$ j
  55. WHERE character_no NOT LIKE 'DEKARON_000001';
    ( p/ n5 B6 P, A8 c& I
  56. DELETE FROM user_bag_copy;
    & H0 G( [4 l/ l+ g: R' f# d
  57. DELETE FROM user_bag_secede;- f& f+ A! p8 P& ?
  58. DELETE FROM user_character5 Y6 ]7 M# }( y+ v
  59. WHERE character_no NOT LIKE 'DEKARON_000001';, y, V+ [" S  }: i+ T
  60. DELETE FROM user_character_secede;
    9 i' b# J+ ?$ K: d" A$ X: W
  61. DELETE FROM USER_POSTBOX;
    % c0 M) e+ W* v$ y2 M
  62. DELETE FROM USER_POSTBOX_SECEDE;/ b6 x  A# A- A! D$ A
  63. DELETE FROM User_Quest_Doing;9 F5 q/ [1 n: X' d0 h1 b8 \6 X
  64. DELETE FROM user_quest_doing_secede;
    7 l% H& e  h, h6 x/ D9 D
  65. DELETE FROM User_Quest_Done;* d2 m* M. s' o
  66. DELETE FROM user_quest_done_secede;
    # J( W- \2 {. ^' p  y8 ?. a
  67. DELETE FROM user_skill
    + L) s0 V, C. k2 \0 j) V
  68. WHERE character_no NOT LIKE 'DEKARON_000001';
    3 D( x7 h3 s+ f8 U* x- L
  69. DELETE FROM user_skill_secede
    & u. i/ d0 F7 J' K
  70. DELETE FROM user_slot
    * j# _/ }  e# ^. M
  71. WHERE character_no NOT LIKE 'DEKARON_000001';
    / O. n" q  Z/ [
  72. DELETE FROM user_storage;
    . [: _* X2 V  X; }- H3 c1 l
  73. DELETE FROM user_storage_copy;* L( k1 @/ i  i+ m1 L) w  e
  74. DELETE FROM USER_STORE;9 f  o. k; M6 t7 Q3 ?5 b3 x$ v* r
  75. DELETE FROM USER_STORE_copy;" p% f% o# l% z$ C1 T$ \9 x. @
  76. DELETE FROM USER_STORE_SECEDE;
    # l+ i# h8 H* D1 ]6 G6 h1 `6 R4 I
  77. DELETE FROM user_suit7 b5 g' C7 K: L
  78. WHERE character_no NOT LIKE 'DEKARON_000001';1 g, F) |# v0 w2 j6 l
  79. DELETE FROM user_suit_copy;/ E- h8 K1 Z4 b, q# x7 Q
  80. DELETE FROM user_suit_secede;: I  N8 G2 a7 F$ r! S
  81. GO
复制代码

9 B8 p. {* [' B' D) i- M4 ^& z0 x* S! J4 |6 c5 C+ N# B: m
商业服务端 登录器 网站 出售

9

主题

234

回帖

980

积分

高级会员

积分
980
金钱
587
贡献
145
注册时间
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

主题

128

回帖

610

积分

高级会员

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

0

主题

65

回帖

2582

积分

金牌会员

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

139

主题

236

回帖

4114

积分

管理员

积分
4114
金钱
1476
贡献
2263
注册时间
2023-11-3
QQ
 楼主| 发表于 2024-10-16 16:39:16 | 显示全部楼层
大张 发表于 2024-10-16 14:56. M4 X; n$ G; X, s) n7 k
语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~!
$ U+ `' g+ Y+ z* Z- G1 q: n
帖子里面有复制功能
商业服务端 登录器 网站 出售
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

Archiver|手机版|小黑屋|EGameol

GMT+8, 2025-6-9 07:27 , Processed in 0.076281 second(s), 21 queries .

Powered by Discuz! X3.5

Copyright © 2001-2020, Tencent Cloud.

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