|
|
操作步骤如下：4 k5 R; Y3 H+ C- a1 ^
MariaDB [(none)]> use glance& {8 S) m' s7 M( q7 q
Reading table information for completion of table and column names
3 k h, V ?, a' R6 r& tYou can turn off this feature to get a quicker startup with -A
L& v# S& r- y: r8 {
; u- b( v, X9 }7 wDatabase changed
2 O# t( P# V+ u" Y3 Y4 y/ I4 k- k# h$ z
MariaDB [glance]> select id,name,deleted,status from images;
! f7 l! D- t5 z3 b. {+--------------------------------------+----------------------------------+---------+---------+. E, q* b$ T) ~( |% r7 g# X7 h
| id | name | deleted | status |
/ S& o9 _/ g: P8 k+--------------------------------------+----------------------------------+---------+---------+
X- p* h# d: R| 020f070c-b3e6-4623-8035-3b0bbbf8c005 | Windows-xp | 0 | active |
9 r3 P/ o: L, d+ h3 J; ?| 0470245c-ee24-488f-89c9-622fd85e9ade | centOS7.9-x86-ssd | 1 | deleted |
. ?( h( T% r5 F' Z/ Y| 097295bd-4a1d-4a91-bfd0-d0ad64e971ff | Ubuntu-20.04 | 1 | deleted |- W: K1 K9 U( c! \! u, b2 b
| 16f278e3-809b-47e8-b6b1-ae96cba1c29c | windows7 | 0 | active |
' Z! \, R4 ~! _6 O| 18804abd-9cba-4a94-8ceb-ba9b12f9fc47 | RHEL-Server-7.9-hdd-2.4T | 1 | active |+ ]! v, B' d3 K
| 1d45630e-510c-4e65-b89d-ae8b615dd344 | RHEL-Server-6.9-hdd-2.4T-volumes | 1 | deleted |# |0 @& d! v2 B( w. a+ d" ^
| 20b59ace-b0d1-4b1f-a5da-bc786aa80be1 | Windows-xp-q1 | 1 | deleted |- B* M# K3 s- \& e1 d6 D
| 240389c3-4df0-4313-91b4-7e801fa4c12c | RHEL-Server-6.9-hdd-2.4T-volumes | 1 | deleted |
+ V: }+ G/ n/ o2 Y' S" u; c! h% R$ M| 2c06a4cc-b62f-4e97-bc91-39e97e62aafe | windows_2016-hdd-8T | 1 | deleted |
& k: k' r+ }$ n9 I7 Q| 2d208a0c-3bc5-4ab5-979a-0b6ac5e592dd | Ubuntu-20.04-1 | 1 | deleted |
' I! n& }6 u: h( F| 3196221b-c211-422b-bc25-d2a23acdd276 | CentOS-7.9-hdd-8T-volumes | 0 | active |
! |" i2 ]' C2 p8 V8 l% {* s' c| 39a2e9a9-2ce5-454a-bd66-47f15eeb11ea | RHEL-Server-7.9-hdd-8T-volumes | 0 | active |
) J3 ]3 w. C+ w' j& Q9 H| 441e4f7c-6d1b-4257-90b3-e2cce50f2142 | RHEL-Server-6.9-hdd-2.4T-volumes | 1 | deleted |
8 @. p2 t( O c| 55bf968d-6fb0-4da9-93e4-942b0667af9b | windows_2016-hdd-8T | 0 | active |' _3 U( m6 J- k0 W3 ~6 U0 G5 x* U
| 636cd370-b4c5-4358-ba71-ab1b34bb4f29 | debian11 | 1 | deleted |4 r( L5 R+ ] M+ {1 ]
| 6a679a2a-3269-4467-af91-8d2e6bb6b13c | Windows2012 | 1 | deleted |) }+ |0 ^4 O$ l' i( c) R" w9 j4 \
| 6b7238ea-9005-497e-8ce2-1195cad17dde | windows7 | 1 | deleted |( J2 s) R- h3 V) r; D" X
| 7af4b3c7-7de6-4b51-b00e-4ae11a1c639a | Windows2012 | 1 | deleted |
% V, ?* f+ @1 d; K! ]3 `| 8abfab0f-5859-45ac-ba94-d968ff85bdab | windows_2016-hdd-8T | 1 | deleted |
& \: x/ c, e7 Y j* V$ K' H| 8b3f63a8-524d-442d-9bdf-59c5b57f0b98 | RHEL-Server-7.9-ssd | 0 | active |9 Y: ]% a8 I" W' \7 ~/ i/ p
| 92f5512b-1928-4bd0-b8fd-087fffedcf3b | Windows10 | 1 | deleted |& I$ M* G+ ~6 z2 _% b" T
| 938eb113-a5d0-4762-abe5-efb6871c14a4 | RHEL-Server-7.9-ssd | 1 | deleted |
! o+ L. D; a/ z* ^| 95910378-8d87-4877-b409-7264dcc90e76 | RHEL-Server-6.9-hdd-2.4T-volumes | 1 | deleted |5 z( d" i: ~7 k4 e
| 993b7f85-f589-484c-a34d-63a37ae4089f | Windows2012 | 0 | active |
: H2 [4 x& {0 @" B- x| a0069fef-46e9-404d-ae2b-7e35a0f62532 | RHEL-Server-7.9-hdd-2.4T | 1 | deleted |
# p e: k4 ^' r4 `- C, S| a822c008-3f1b-403e-b1f2-69ff729e8c5f | RHEL-Server-7.9-hdd-8T-volumes | 0 | saving |
5 o: z+ P7 @; P% U| aada273b-f74b-4723-bef8-a2e39da29c5c | CentOS-7.9-hdd-8T-volumes | 1 | deleted |
7 N' e) o( \2 p$ l9 x| ac76737d-3a05-4869-8a78-573999a5cb5f | Ubuntu20.04 | 1 | deleted |
5 i+ A9 L% `3 W! U6 L. X| b97a827c-45c3-432c-b905-44d12b395159 | Centos7.9 | 0 | active |
8 c3 l2 g! @3 {+ T) F| b9c335c4-34a8-498c-a735-82567f7ef186 | rhel-server-7.9-ssd | 1 | deleted |& ?3 ]! V7 d/ n$ {0 N5 S
| be80198f-6554-4cef-9eea-a5562a59c4ad | Ubuntu-20.04 | 0 | active |& F$ D( N2 [2 ]3 s7 [6 g5 w
| c5858416-b69d-4593-b07a-688b67377280 | Windows2008R2 | 0 | active |
$ q8 z: z. i, i3 d& s( f/ Z| ce11d362-88b0-48de-8fd0-3eec4b567733 | Windows-xp-q1 | 1 | deleted |+ v: t: g1 {5 x; q" ^
| df76dcba-d60e-45b3-8e5b-2d453b46641d | RHEL-Server-7.9-hdd-2.4T-volumes | 1 | active |
G9 b+ n4 `4 T7 z+ N4 T; V! ^| e0957ba4-782e-4030-874b-19a1b07156f5 | RHEL-Server-6.9-hdd-8T-volumes | 0 | active |! W$ J9 a5 O& c5 r: C1 _
| ea333f95-79c3-4ce4-856b-a397cc963d77 | windows_2019_x64-hdd-8T | 0 | active |
$ B+ i- q% G- _, x| f5e9e921-3f9b-4f8e-a32a-0b96679483fc | Windows7 | 1 | deleted |
) D0 V# h4 |# U% f- t# w| fb5fe7ed-ba56-4ae2-a483-af3cc0cce891 | RHEL-Server-7.9-ssd | 1 | active |
- Z; c4 ]+ R9 t# Q1 u* Z| fd6d646f-6c61-4793-87d8-cc180a3259c3 | RHEL-Server-6.9-hdd-2.4T-volumes | 1 | deleted |
6 @( V4 u6 C' h| fd91972f-726e-43af-855c-636854815b0c | Windows10 | 0 | active |" E" \8 T4 X( Q6 A& F# J9 i7 G) b9 s
+--------------------------------------+----------------------------------+---------+---------+, R: A0 F G/ o. a" `
40 rows in set (0.00 sec)
1 Q9 H: g, k, z3 D0 g' F. d a4 d
# R, K% S: I: k! {/ f配置：, t+ i" S( {0 Y3 u" r2 V
MariaDB [glance]> select id,name,deleted,status from images where id="39a2e9a9-2ce5-454a-bd66-47f15eeb11ea";
) l O+ ]1 G& d3 A' }) T5 E O+ i9 H7 d+--------------------------------------+--------------------------------+---------+--------+- `$ G# j3 x" c
| id | name | deleted | status |6 Y5 Q: f' Q2 ]% O
+--------------------------------------+--------------------------------+---------+--------+2 c- u0 \+ I, p
| 39a2e9a9-2ce5-454a-bd66-47f15eeb11ea | RHEL-Server-7.9-hdd-8T-volumes | 0 | active |
# [: {2 b) [( U$ ^5 b+--------------------------------------+--------------------------------+---------+--------+
2 V1 C9 p9 n/ R% \* r/ J" d1 row in set (0.01 sec)
6 v9 O! Y8 a, _0 @) W* g
2 S0 B6 W: @7 z7 F) q* e5 g7 {( H. X; P" R4 Y0 s2 c
MariaDB [glance]> update glance.images set deleted=" 1 " where id="39a2e9a9-2ce5-454a-bd66-47f15eeb11ea";
# {% ~* P/ |' e9 G ]Query OK, 1 row affected, 1 warning (0.01 sec)
+ W% Y1 K# X1 }Rows matched: 1 Changed: 1 Warnings: 1$ \2 u" `( |! h7 a
& ]5 b% P# {; I m" s$ L8 a; r9 g6 q! I
" c' {- ~+ ~5 C. tMariaDB [glance]> select id,name,deleted,status from images where id="39a2e9a9-2ce5-454a-bd66-47f15eeb11ea";6 o) u+ f5 a% S
+--------------------------------------+--------------------------------+---------+--------+
) c) p, s# g: T/ [8 C| id | name | deleted | status |8 H0 M8 A" @' ]
+--------------------------------------+--------------------------------+---------+--------+
1 r; q: T4 h. b1 F| 39a2e9a9-2ce5-454a-bd66-47f15eeb11ea | RHEL-Server-7.9-hdd-8T-volumes | 1 | active |
$ J' n$ O$ A/ r/ m: }$ ^5 @+--------------------------------------+--------------------------------+---------+--------+* I5 b" p! Z) D8 \' c0 [3 O
1 row in set (0.00 sec)
' c* _5 ]# c5 Q; K; S6 D% {8 A+ L' @4 z1 b9 k% T
( ?4 O! B% _" Y* M# t c; p) l
' v8 z: }: P. M. U$ P1 {
8 T0 a. w: b1 d$ ?
|
|
发表于 2022-7-5 10:48:23