|
|
操作步骤如下：( |! J% b0 P1 d5 U# s
MariaDB [(none)]> use glance6 f( j0 ~8 S$ d5 z, y, p" u
Reading table information for completion of table and column names* a, ~3 k. n* X( e
You can turn off this feature to get a quicker startup with -A
6 N2 E* q$ u6 a
# M( h3 A) E+ MDatabase changed
6 t a2 b, A# Y5 w& k
+ o4 f% b" ?- ?4 j: ^/ CMariaDB [glance]> select id,name,deleted,status from images;7 E- g' j A8 X/ ^# G* f
+--------------------------------------+----------------------------------+---------+---------+
# z" c2 M$ `! A% [. W0 k' U| id | name | deleted | status |9 Z' m. j. D: B- e9 f
+--------------------------------------+----------------------------------+---------+---------+% D0 O3 Y1 \' S# z6 Z! A2 Y
| 020f070c-b3e6-4623-8035-3b0bbbf8c005 | Windows-xp | 0 | active |, u; G" X# y4 q6 u
| 0470245c-ee24-488f-89c9-622fd85e9ade | centOS7.9-x86-ssd | 1 | deleted |$ K- ?+ G4 `* C8 ~
| 097295bd-4a1d-4a91-bfd0-d0ad64e971ff | Ubuntu-20.04 | 1 | deleted |
) Q! K: N$ U2 j" a| 16f278e3-809b-47e8-b6b1-ae96cba1c29c | windows7 | 0 | active |
8 I) M3 t; D: `5 Q" ^3 N| 18804abd-9cba-4a94-8ceb-ba9b12f9fc47 | RHEL-Server-7.9-hdd-2.4T | 1 | active |( h; ]0 j9 Y" u
| 1d45630e-510c-4e65-b89d-ae8b615dd344 | RHEL-Server-6.9-hdd-2.4T-volumes | 1 | deleted |
6 s+ t$ a. d3 E* A( g; c2 [* m| 20b59ace-b0d1-4b1f-a5da-bc786aa80be1 | Windows-xp-q1 | 1 | deleted |
2 L% D0 ^% p9 `4 N, E| 240389c3-4df0-4313-91b4-7e801fa4c12c | RHEL-Server-6.9-hdd-2.4T-volumes | 1 | deleted |& h+ r) N: H7 T
| 2c06a4cc-b62f-4e97-bc91-39e97e62aafe | windows_2016-hdd-8T | 1 | deleted |) o5 Q1 h2 }5 N, Y. Q4 j
| 2d208a0c-3bc5-4ab5-979a-0b6ac5e592dd | Ubuntu-20.04-1 | 1 | deleted |
: J; |. j+ p+ u; x% g, f+ v: U, s| 3196221b-c211-422b-bc25-d2a23acdd276 | CentOS-7.9-hdd-8T-volumes | 0 | active |; q, P4 |' s- B1 J
| 39a2e9a9-2ce5-454a-bd66-47f15eeb11ea | RHEL-Server-7.9-hdd-8T-volumes | 0 | active |
9 b' H) i% L+ A q# Q| 441e4f7c-6d1b-4257-90b3-e2cce50f2142 | RHEL-Server-6.9-hdd-2.4T-volumes | 1 | deleted |
, p+ x Z! t+ h; f( i4 E& l| 55bf968d-6fb0-4da9-93e4-942b0667af9b | windows_2016-hdd-8T | 0 | active |" _' h( Y# H1 A$ J/ i( \
| 636cd370-b4c5-4358-ba71-ab1b34bb4f29 | debian11 | 1 | deleted |
( E6 k2 g7 i5 s& G0 \) o8 W$ N6 o| 6a679a2a-3269-4467-af91-8d2e6bb6b13c | Windows2012 | 1 | deleted |
, _: R+ n; ]! \' ], _- r| 6b7238ea-9005-497e-8ce2-1195cad17dde | windows7 | 1 | deleted |" F {) e' ~" L8 F
| 7af4b3c7-7de6-4b51-b00e-4ae11a1c639a | Windows2012 | 1 | deleted |
2 ]; x: v1 \* K6 i5 x| 8abfab0f-5859-45ac-ba94-d968ff85bdab | windows_2016-hdd-8T | 1 | deleted |8 |& o( f' c5 w4 m1 T; a
| 8b3f63a8-524d-442d-9bdf-59c5b57f0b98 | RHEL-Server-7.9-ssd | 0 | active |
3 y* q& P* o% u$ Y8 q$ K3 ~. I| 92f5512b-1928-4bd0-b8fd-087fffedcf3b | Windows10 | 1 | deleted | w" n6 C- D% a
| 938eb113-a5d0-4762-abe5-efb6871c14a4 | RHEL-Server-7.9-ssd | 1 | deleted |1 E) F5 Y. ?! h$ d: K g0 q; z
| 95910378-8d87-4877-b409-7264dcc90e76 | RHEL-Server-6.9-hdd-2.4T-volumes | 1 | deleted |" k) p o2 l( T9 Z$ `' e
| 993b7f85-f589-484c-a34d-63a37ae4089f | Windows2012 | 0 | active |
! H0 g* _5 a, a+ k: X; R$ B| a0069fef-46e9-404d-ae2b-7e35a0f62532 | RHEL-Server-7.9-hdd-2.4T | 1 | deleted |, A e I9 @' X, Z# y: W
| a822c008-3f1b-403e-b1f2-69ff729e8c5f | RHEL-Server-7.9-hdd-8T-volumes | 0 | saving |
' @2 N7 j0 c' ]8 w: ^| aada273b-f74b-4723-bef8-a2e39da29c5c | CentOS-7.9-hdd-8T-volumes | 1 | deleted |; l; [! \3 S. q! d% i! p3 J" B/ |
| ac76737d-3a05-4869-8a78-573999a5cb5f | Ubuntu20.04 | 1 | deleted |
5 e& b8 L' M# ^( o( l. v| b97a827c-45c3-432c-b905-44d12b395159 | Centos7.9 | 0 | active |
& z1 F! e$ i" k* ~/ g| b9c335c4-34a8-498c-a735-82567f7ef186 | rhel-server-7.9-ssd | 1 | deleted |
: u$ P: D4 j$ k& @; I% `, I| be80198f-6554-4cef-9eea-a5562a59c4ad | Ubuntu-20.04 | 0 | active |. V* Y% z# K5 y2 Q
| c5858416-b69d-4593-b07a-688b67377280 | Windows2008R2 | 0 | active |; w& ?$ m- g) q
| ce11d362-88b0-48de-8fd0-3eec4b567733 | Windows-xp-q1 | 1 | deleted |$ G: r- Z6 `/ u
| df76dcba-d60e-45b3-8e5b-2d453b46641d | RHEL-Server-7.9-hdd-2.4T-volumes | 1 | active |
' Y! l# ]! p7 C7 H) b0 x. @| e0957ba4-782e-4030-874b-19a1b07156f5 | RHEL-Server-6.9-hdd-8T-volumes | 0 | active |6 q9 j# @+ G' D& Z# v+ I: \+ p+ n
| ea333f95-79c3-4ce4-856b-a397cc963d77 | windows_2019_x64-hdd-8T | 0 | active |
' P9 W% V7 Q' u: p1 M* O2 N ~) y' D| f5e9e921-3f9b-4f8e-a32a-0b96679483fc | Windows7 | 1 | deleted |5 h/ V. j1 u* [
| fb5fe7ed-ba56-4ae2-a483-af3cc0cce891 | RHEL-Server-7.9-ssd | 1 | active |
/ M0 E6 B H0 }( f% X$ T| fd6d646f-6c61-4793-87d8-cc180a3259c3 | RHEL-Server-6.9-hdd-2.4T-volumes | 1 | deleted |
& X" }" j, m/ J| fd91972f-726e-43af-855c-636854815b0c | Windows10 | 0 | active |7 N& y, z- }; I8 L
+--------------------------------------+----------------------------------+---------+---------+' U6 \, }! n# B" o. [
40 rows in set (0.00 sec)
4 K$ d R6 P% ]/ q' N: @! W: b4 ?) Q2 a, i' K9 m; `% Q0 ~
配置：$ ^0 k) ?; m1 v Q3 N% f5 ]
MariaDB [glance]> select id,name,deleted,status from images where id="39a2e9a9-2ce5-454a-bd66-47f15eeb11ea";8 t$ C# t% S% @% @
+--------------------------------------+--------------------------------+---------+--------+
- w" E2 |$ P1 {! c% \| id | name | deleted | status |- c! g3 {( K% a8 A7 _2 r$ `. N( R
+--------------------------------------+--------------------------------+---------+--------+. p3 a4 o* [! ^* x
| 39a2e9a9-2ce5-454a-bd66-47f15eeb11ea | RHEL-Server-7.9-hdd-8T-volumes | 0 | active |
# |# A) T: O& j* |. f. M) |# }& ]4 W( o+--------------------------------------+--------------------------------+---------+--------+6 A" Z' z- f" ^) {" T) e/ T7 y
1 row in set (0.01 sec)
0 o& h t# H8 P; e9 f3 W7 n9 T# H. G( c9 I
5 o3 k4 A) P+ H+ E* o9 |- I4 u
MariaDB [glance]> update glance.images set deleted=" 1 " where id="39a2e9a9-2ce5-454a-bd66-47f15eeb11ea";) a, W8 [8 k0 _. B. E# m
Query OK, 1 row affected, 1 warning (0.01 sec)
s) _0 T7 ]. d4 {8 ~4 ZRows matched: 1 Changed: 1 Warnings: 18 {4 v- g k, e$ f& Y. Q, |/ I1 ^8 r
) _# l* S1 S' N/ n3 h
% F( ]+ O: z$ k2 U& P# B3 ~/ Z
MariaDB [glance]> select id,name,deleted,status from images where id="39a2e9a9-2ce5-454a-bd66-47f15eeb11ea";7 N- u0 ]6 H- ~
+--------------------------------------+--------------------------------+---------+--------+
6 q! M( b# }9 t' G2 T| id | name | deleted | status |5 P& W5 l$ _# `) V- Y! j3 Q
+--------------------------------------+--------------------------------+---------+--------+" F; S- X' v3 p
| 39a2e9a9-2ce5-454a-bd66-47f15eeb11ea | RHEL-Server-7.9-hdd-8T-volumes | 1 | active |) Q' r$ d O! P' U9 Q
+--------------------------------------+--------------------------------+---------+--------+* Z& ?% d3 \, X+ l6 F* U, h4 O# ^
1 row in set (0.00 sec)
6 j2 v5 B6 n! e+ c& l7 P5 z
# f+ T+ W6 R, b. x( T# O+ R3 K3 {9 g" i4 e
- e# q+ Y- t; d, T
. y3 l1 y# Z. V/ N5 A0 z |
|
发表于 2022-7-5 10:48:23