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

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

[复制链接]

161

主题

389

回帖

7476

积分

管理员

积分
7476
金钱
2161
贡献
4765
注册时间
2023-11-3
QQ
发表于 2024-1-28 20:00:01 | 显示全部楼层 |阅读模式
  1. : D+ t& \4 u/ P7 E
  2. 8 x5 _0 v/ R7 W/ U
  3. use account;
    : U" L7 R. {" t' u8 R
  4. DELETE FROM C_IP_BAN;* ?: a7 S3 I6 L1 @; q8 ~
  5. DELETE FROM C_IP_PERMIT;
    % m7 R7 ^4 h- O  P: ?
  6. DELETE FROM C_IP_PWD;/ z5 |0 r7 u6 s9 X; ?
  7. DELETE FROM C_LOGINIPBLOCK_LOG;' v8 S4 a7 m$ Y" y2 i: g
  8. DELETE FROM C_SEQUENCE;/ g# n0 I: z- M  V( h. {
  9. DELETE FROM CP_USER_PROFILE;
    1 F* `& v+ k1 W/ n1 y
  10. DELETE FROM MB_USR_IP;
    1 t, ^. d) j) C
  11. DELETE FROM MB_USR_PUN;
    $ q1 Q7 Y3 V* S7 K6 f) Q; L
  12. DELETE FROM Tbl_user;. Z' G! d  w& ^: e
  13. DELETE FROM USER_CONNLOG_KEY;
    5 e$ k3 p, f* E6 U* n4 G5 E
  14. DELETE FROM USER_PROFILE;1 R- U6 D& [6 i$ y0 u* O1 T5 q4 Q
  15. GO
    . m. ]  a% D, r4 N0 T
  16. use billing;5 ^- _2 ^! T/ Z; g7 J! F* {: a  r, o
  17. DELETE FROM bl_error_log;8 b; i- o" a2 H# a6 X& G
  18. DELETE FROM c_sequence;
    ; Q1 F; x+ X2 Q/ l8 x
  19. DELETE FROM dba_online_daily;# @* B' W& f7 |+ T0 y+ |$ v
  20. DELETE FROM dba_online_daily_notok;: z4 A' R, R. a
  21. DELETE FROM Tbl_KeepId;
    . a: w# ^: P6 ^. F" M1 ?$ W% }
  22. DELETE FROM user_account;  K; E; q3 D: E
  23. DELETE FROM user_account;
    , h4 O) n7 D* T( |0 M/ `
  24. DELETE FROM user_charge_log;3 R3 r5 M" _0 N, {
  25. DELETE FROM user_everyday_use_info;8 a5 B/ ^8 t' Y3 s. Z( Y
  26. DELETE FROM user_give_log;: a7 y* ~8 w' d6 c; \9 s* E, S! g8 h6 w
  27. DELETE FROM user_use_log;
    * X& G, b) a6 Z
  28. DELETE FROM user_use_log_bk;
    ; X% S) B* w5 J# G) ^3 r1 ]
  29. GO
    ! q# g! ]1 `: p- X7 y
  30. use cash;# K4 N$ T+ ~3 ]& E# r. f! e
  31. DELETE FROM bl_error_log;
    ; C% U9 D% M7 x% d. o
  32. DELETE FROM Tbl_Cash_zj;' |9 L8 q; V1 n/ S5 ]1 U& E
  33. DELETE FROM user_cash;
    + K1 \; c) M- s3 }& ~# @
  34. DELETE FROM user_charge_log;
    & d8 g& G( F6 [5 x
  35. DELETE FROM user_use_log;
    ' M$ G3 L* l7 v: \7 y
  36. GO
    : ^4 ]8 R7 j1 r  m8 s3 t
  37. use character;
    ( I/ }7 v! u0 M- o  J. \) C, i5 m& V
  38. DELETE FROM C_EVENT_ITEM_OP
    5 K' V* ?/ n" C9 F) \+ r9 N6 Z: M
  39. DELETE FROM c_restword;
    % Y2 ]- W* D6 Y# q1 W/ o
  40. DELETE FROM char_connlog;5 Z9 n4 W& ]- X3 ]
  41. DELETE FROM CHAR_CONNLOG_KEY;/ l3 |) ^- v9 k3 v* f( i0 f
  42. DELETE FROM DEL_USER_CHAR_LIST;
    1 O5 |  H  ^3 K8 V! J9 w3 o/ e
  43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    ! l" K+ H9 t" w
  44. DELETE FROM GM_ITEM_MST;8 \, h# Y+ J1 H8 J; l
  45. DELETE FROM GUILD_CHAR_INFO;# h! J6 F1 V9 l. f, q; w$ w( B
  46. DELETE FROM GUILD_INFO; {0 m. c% `% L4 I) ?8 v
  47. WHERE guild_code NOT LIKE 'MASTERCODE';
    2 y8 x; _4 Y0 E6 j
  48. DELETE FROM GUILD_INFO_SECEDE;
    3 p' l* U+ j" n1 ^5 z
  49. DELETE FROM GUILD_PEERAGE
    ' @$ [7 b3 P$ x6 D2 c0 {
  50. WHERE guild_code NOT LIKE 'MASTERCODE';
      y& \6 ^% @0 L0 g8 V5 H7 y) J
  51. DELETE FROM MSSNGR_CHAR_LIST;
    ( K6 e( [& X  x3 R5 |2 H
  52. DELETE FROM SIEGE_INFO;
    ' h5 U; E% }9 `
  53. DELETE FROM SIEGE_RESULT_LOG;: b, r* Y) T  W1 A
  54. DELETE FROM user_bag
    ; u1 u7 y0 R" e
  55. WHERE character_no NOT LIKE 'DEKARON_000001';
    7 D$ b: b( I4 h. e6 O' c
  56. DELETE FROM user_bag_copy;8 d2 w( ?9 o% j# b
  57. DELETE FROM user_bag_secede;
    . C$ a# O2 ]8 O& M  n  e5 u" `
  58. DELETE FROM user_character' V. X6 i8 D+ j1 a- @2 Q
  59. WHERE character_no NOT LIKE 'DEKARON_000001';
    * a$ ?& c2 t) v7 U( V  i
  60. DELETE FROM user_character_secede;% V' J! ?7 l4 Y% u* ~  ]
  61. DELETE FROM USER_POSTBOX;: u4 x+ ^2 r! z, F, n+ r+ O
  62. DELETE FROM USER_POSTBOX_SECEDE;: g& y6 x. a6 t( C! G; b$ ~0 z
  63. DELETE FROM User_Quest_Doing;2 I" W2 w9 K9 H. }; [1 p
  64. DELETE FROM user_quest_doing_secede;2 P8 ]% r! _' ?! Y
  65. DELETE FROM User_Quest_Done;% N) }* n: @' V. z" }/ f
  66. DELETE FROM user_quest_done_secede;
    ) [1 o  l3 ^' ]# _" s0 S- K
  67. DELETE FROM user_skill
      |9 y5 e4 c: _
  68. WHERE character_no NOT LIKE 'DEKARON_000001';- a8 A5 T: i* p4 V( r
  69. DELETE FROM user_skill_secede
    - L, \- O$ a& A9 ~4 l$ ?. T- v
  70. DELETE FROM user_slot
    / l: c+ S) x! N) z/ r- @7 |1 l
  71. WHERE character_no NOT LIKE 'DEKARON_000001';( }8 M" `; w2 L1 {* `
  72. DELETE FROM user_storage;
    0 L( Z. j0 S( q" Q- d! i
  73. DELETE FROM user_storage_copy;1 B9 |' c  r: Y( }9 E
  74. DELETE FROM USER_STORE;
    3 k1 q" x# ?4 i3 F/ ^8 _5 U  @
  75. DELETE FROM USER_STORE_copy;& P7 T. D) k  C7 V" j
  76. DELETE FROM USER_STORE_SECEDE;
    . C+ r8 C: c% o/ I' ~4 G+ L, y
  77. DELETE FROM user_suit
    / Z3 ?& f* a" I5 A: A3 c
  78. WHERE character_no NOT LIKE 'DEKARON_000001';
    * {: a) X  Q" f' J- X% h
  79. DELETE FROM user_suit_copy;; f1 V; C6 [# |
  80. DELETE FROM user_suit_secede;
    , Q" ^8 J, b, d, Z
  81. GO
复制代码

9 i' s2 P6 J; g) M, V" H- H+ A
7 b. @! x/ [: O
商业服务端 登录器 网站 出售

15

主题

260

回帖

1313

积分

金牌会员

积分
1313
金钱
945
贡献
88
注册时间
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

主题

70

回帖

9015

积分

论坛元老

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

161

主题

389

回帖

7476

积分

管理员

积分
7476
金钱
2161
贡献
4765
注册时间
2023-11-3
QQ
 楼主| 发表于 2024-10-16 16:39:16 | 显示全部楼层
大张 发表于 2024-10-16 14:56  h* W' L. _) N5 ^8 H
语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~!

6 {9 k7 U( {8 M; l% I9 A帖子里面有复制功能
商业服务端 登录器 网站 出售
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则


Archiver|小黑屋|EGameol

GMT+8, 2026-5-13 22:19 , Processed in 0.157180 second(s), 23 queries .

Powered by Discuz! X3.5

Copyright © 2001-2020, Tencent Cloud.

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