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

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

[复制链接]

157

主题

361

回帖

6821

积分

管理员

积分
6821
金钱
1939
贡献
4364
注册时间
2023-11-3
QQ
发表于 2024-1-28 20:00:01 | 显示全部楼层 |阅读模式
  1. 3 g& g# J3 y" G' c( ^/ H' Z
  2. 8 _) U! C+ D' V  U0 |& Q
  3. use account;
    4 k1 ^9 Q: a, a0 V8 j
  4. DELETE FROM C_IP_BAN;) w, ~0 F2 D+ t
  5. DELETE FROM C_IP_PERMIT;. ]; @% b/ u" t
  6. DELETE FROM C_IP_PWD;. v% c. ]2 ~6 h
  7. DELETE FROM C_LOGINIPBLOCK_LOG;
    3 @; |+ W; u( _3 m- O3 N
  8. DELETE FROM C_SEQUENCE;7 z) L2 c+ w# B/ W. R
  9. DELETE FROM CP_USER_PROFILE;: @7 k/ ?5 ?1 E5 }* g) U
  10. DELETE FROM MB_USR_IP;: J  h4 b2 T: f9 K
  11. DELETE FROM MB_USR_PUN;
    ( Z! Q* E1 H. p; V
  12. DELETE FROM Tbl_user;
    8 u, |  D. a+ L% q( W: C, w. [
  13. DELETE FROM USER_CONNLOG_KEY;( M) m$ l  g( l$ {* f+ r/ l( j
  14. DELETE FROM USER_PROFILE;
    ) n3 ]# s! k0 @$ a; X
  15. GO7 ~& R1 A' [3 l( K# O7 {- P
  16. use billing;
    . _& O: b) S; {) j, K: z
  17. DELETE FROM bl_error_log;
    * }. _# o/ T3 U9 m: D# s
  18. DELETE FROM c_sequence;
    : B3 J4 l$ t. |8 G' @" R
  19. DELETE FROM dba_online_daily;
    " h- q" p4 B2 a# U  c) T: B
  20. DELETE FROM dba_online_daily_notok;
    3 C+ S7 c5 I. V# q7 @
  21. DELETE FROM Tbl_KeepId;* N0 v) a3 a' _' O8 d1 K
  22. DELETE FROM user_account;
    ( Z3 }8 d: G1 H- I0 W9 K% b+ l* f1 p
  23. DELETE FROM user_account;2 t5 u5 ]/ H$ A2 L  U7 a
  24. DELETE FROM user_charge_log;2 w" a: A! v! K: L, q
  25. DELETE FROM user_everyday_use_info;
    " G0 G! J" K+ F  [4 Q1 {# G
  26. DELETE FROM user_give_log;! Y; j9 n, \! E8 V' u
  27. DELETE FROM user_use_log;
    7 N( {. U6 N# N% q9 [8 e
  28. DELETE FROM user_use_log_bk;
    8 K4 N9 e/ b- ^( ~0 k8 \$ e4 m
  29. GO  P) T: S& T8 m& X8 ^
  30. use cash;
    4 X8 H0 x' z& w9 F) ]' K8 ^% K( a
  31. DELETE FROM bl_error_log;
    3 g! j; U, W& `; ~0 j
  32. DELETE FROM Tbl_Cash_zj;
    " `. V3 s) u8 J5 e; i/ F% b
  33. DELETE FROM user_cash;
    9 T* A% a, z% u, K" P. X( e
  34. DELETE FROM user_charge_log;
    5 H; }4 R' i8 }, E" g
  35. DELETE FROM user_use_log;) }5 n3 C* d8 N
  36. GO
    * T4 N0 c, ], C" m9 q: ^& b: g% y( b* s
  37. use character;( H4 [! f+ c5 s( _1 k  v2 k: F" _
  38. DELETE FROM C_EVENT_ITEM_OP" w7 A* [: m" b, h
  39. DELETE FROM c_restword;7 q" `4 c' i( a/ h* W
  40. DELETE FROM char_connlog;
    ( F% _7 T$ O3 w" D1 a& u0 ~* f3 C2 p( M' x
  41. DELETE FROM CHAR_CONNLOG_KEY;
    $ y" [; I+ `0 y) R+ a
  42. DELETE FROM DEL_USER_CHAR_LIST;
    7 x0 M7 _1 K0 `( j' c8 T
  43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;+ M. b8 N' o' Y! T8 }3 G3 n0 }
  44. DELETE FROM GM_ITEM_MST;, R: a8 e: |7 N! O2 ]9 d
  45. DELETE FROM GUILD_CHAR_INFO;5 {* s. Y& C# P
  46. DELETE FROM GUILD_INFO6 `4 e" G" O5 \/ d2 x: i
  47. WHERE guild_code NOT LIKE 'MASTERCODE';. j1 m5 h4 y& u) ]
  48. DELETE FROM GUILD_INFO_SECEDE;
    : J* k# [; d( X
  49. DELETE FROM GUILD_PEERAGE1 q" L* G- t* @% f6 s
  50. WHERE guild_code NOT LIKE 'MASTERCODE';, y3 k9 c# i; d4 ~! G" P- @6 X+ n
  51. DELETE FROM MSSNGR_CHAR_LIST;  d4 i3 A% Q* L, R6 g; |
  52. DELETE FROM SIEGE_INFO;& i6 k2 t. R7 N! r$ }9 z2 J
  53. DELETE FROM SIEGE_RESULT_LOG;% ?" M( t  h6 e+ F3 L
  54. DELETE FROM user_bag0 _" H6 ]/ q( d/ _+ T
  55. WHERE character_no NOT LIKE 'DEKARON_000001';
    5 B4 ]; `: h; D
  56. DELETE FROM user_bag_copy;
    ) u1 Q- \% I7 g/ a' c
  57. DELETE FROM user_bag_secede;
    1 ~4 c, {% X1 ^( i# e
  58. DELETE FROM user_character
    6 E$ c9 m2 n/ m! D& M
  59. WHERE character_no NOT LIKE 'DEKARON_000001';' _2 S1 ]4 b1 r$ |+ A
  60. DELETE FROM user_character_secede;
    5 u4 Q5 B& ~6 M( ?& C/ ~
  61. DELETE FROM USER_POSTBOX;
    # q- b: P* d  ~2 \; J
  62. DELETE FROM USER_POSTBOX_SECEDE;8 ^8 Z9 y% F8 U- n# a9 p
  63. DELETE FROM User_Quest_Doing;
    8 v0 x6 t8 {% D) H7 k: q" F, @" D
  64. DELETE FROM user_quest_doing_secede;* L# G* }0 S* ~8 R1 n5 i! z
  65. DELETE FROM User_Quest_Done;" Y( S. Q! C; s
  66. DELETE FROM user_quest_done_secede;
    2 t# s/ V  k: y: K* t
  67. DELETE FROM user_skill
    6 J# e3 _. W* ]7 c- @; v) s
  68. WHERE character_no NOT LIKE 'DEKARON_000001';1 B- |8 b, j) z. ?! S3 B% k9 k3 M* I
  69. DELETE FROM user_skill_secede
    - p, i" x( \% _4 o. B* B3 D
  70. DELETE FROM user_slot% W' I4 o8 z5 F7 u7 N& n
  71. WHERE character_no NOT LIKE 'DEKARON_000001';* Q& o" v$ y$ Y, G
  72. DELETE FROM user_storage;
    7 a9 b, h* t0 i4 [( a
  73. DELETE FROM user_storage_copy;
    , ~& N7 I8 X" j2 ^$ O! c) w
  74. DELETE FROM USER_STORE;
    & S/ H! {. o' f2 `/ r  x3 B, e% N  b# H# B
  75. DELETE FROM USER_STORE_copy;& ^" d+ @' A' P8 |4 P4 C
  76. DELETE FROM USER_STORE_SECEDE;5 ]6 N+ ~; z0 K' ?
  77. DELETE FROM user_suit. D5 o% X2 {' }; G, g( [: _% F& G; T
  78. WHERE character_no NOT LIKE 'DEKARON_000001';& y$ B7 o* x" p. {: t* D# A6 Y7 z
  79. DELETE FROM user_suit_copy;8 M! w" b( ~8 ?, L3 R
  80. DELETE FROM user_suit_secede;
    8 V8 ?; o* [0 ~3 C* ~
  81. GO
复制代码

5 {* B: T  O2 O+ w+ R
3 T# a, c+ ?0 k
商业服务端 登录器 网站 出售

15

主题

256

回帖

1268

积分

金牌会员

积分
1268
金钱
871
贡献
121
注册时间
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

回帖

7321

积分

论坛元老

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

157

主题

361

回帖

6821

积分

管理员

积分
6821
金钱
1939
贡献
4364
注册时间
2023-11-3
QQ
 楼主| 发表于 2024-10-16 16:39:16 | 显示全部楼层
大张 发表于 2024-10-16 14:56
8 H$ X# _3 i2 n- D7 B- n* U; G& ~) C语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~!
: p$ |; _7 h. ]/ m- G
帖子里面有复制功能
商业服务端 登录器 网站 出售
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则


Archiver|小黑屋|EGameol

GMT+8, 2026-2-12 05:16 , Processed in 0.064010 second(s), 23 queries .

Powered by Discuz! X3.5

Copyright © 2001-2020, Tencent Cloud.

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