|
|
操作步骤如下：$ c3 F! G) S2 h# U
MariaDB [(none)]> use glance7 s+ F( V' n, o
Reading table information for completion of table and column names
Q) e3 r# R2 y2 Z* JYou can turn off this feature to get a quicker startup with -A
# M. r3 r: L& C/ |+ y1 G0 x0 h% ]
Database changed
' c0 s6 W! \* Y: D$ R+ [: X1 O' B9 x2 G2 s
MariaDB [glance]> select id,name,deleted,status from images;3 ]( s/ S8 u" S {# c
+--------------------------------------+----------------------------------+---------+---------+
7 ~! S3 l7 M; i| id | name | deleted | status |) g& X v: D, `- |$ J; x4 ?# j0 P, o
+--------------------------------------+----------------------------------+---------+---------+3 w9 L- O4 O" e+ o4 o l8 K8 p4 a
| 020f070c-b3e6-4623-8035-3b0bbbf8c005 | Windows-xp | 0 | active |6 R+ I# C9 w% e1 _, |9 Q+ o2 {
| 0470245c-ee24-488f-89c9-622fd85e9ade | centOS7.9-x86-ssd | 1 | deleted | S, a7 U4 G% [, o8 V
| 097295bd-4a1d-4a91-bfd0-d0ad64e971ff | Ubuntu-20.04 | 1 | deleted |
& D6 {7 I8 d4 r, ] }0 g. W& u, b| 16f278e3-809b-47e8-b6b1-ae96cba1c29c | windows7 | 0 | active |3 h A6 {( _5 H8 ~' _0 y- t
| 18804abd-9cba-4a94-8ceb-ba9b12f9fc47 | RHEL-Server-7.9-hdd-2.4T | 1 | active |
9 `/ b, ]* M) V# v3 ?# d- G| 1d45630e-510c-4e65-b89d-ae8b615dd344 | RHEL-Server-6.9-hdd-2.4T-volumes | 1 | deleted |6 ~" z* }) {& b* l
| 20b59ace-b0d1-4b1f-a5da-bc786aa80be1 | Windows-xp-q1 | 1 | deleted |
3 m+ Z" u H" Z. O3 G# {4 H- }| 240389c3-4df0-4313-91b4-7e801fa4c12c | RHEL-Server-6.9-hdd-2.4T-volumes | 1 | deleted |
* k/ U: a8 u2 Y) u3 p# b* t| 2c06a4cc-b62f-4e97-bc91-39e97e62aafe | windows_2016-hdd-8T | 1 | deleted |
( K) g; J5 k8 ?| 2d208a0c-3bc5-4ab5-979a-0b6ac5e592dd | Ubuntu-20.04-1 | 1 | deleted |
$ M* O" D6 `% c" p| 3196221b-c211-422b-bc25-d2a23acdd276 | CentOS-7.9-hdd-8T-volumes | 0 | active |
4 h9 _0 J2 b6 r% \' w- b2 G" ?; C| 39a2e9a9-2ce5-454a-bd66-47f15eeb11ea | RHEL-Server-7.9-hdd-8T-volumes | 0 | active |
9 w8 ]! B7 |& E* d Q4 y: k| 441e4f7c-6d1b-4257-90b3-e2cce50f2142 | RHEL-Server-6.9-hdd-2.4T-volumes | 1 | deleted |
* x Q: ~5 ?6 _0 R, Z| 55bf968d-6fb0-4da9-93e4-942b0667af9b | windows_2016-hdd-8T | 0 | active |" z) B, O5 I/ j" \! Q5 C, i
| 636cd370-b4c5-4358-ba71-ab1b34bb4f29 | debian11 | 1 | deleted | D) _4 }: Y; H/ D" V
| 6a679a2a-3269-4467-af91-8d2e6bb6b13c | Windows2012 | 1 | deleted |& I4 w4 {1 D, d, X0 f/ o4 D8 ^+ F
| 6b7238ea-9005-497e-8ce2-1195cad17dde | windows7 | 1 | deleted |
% ?2 b/ m8 ]; N5 W: h7 c: N* a3 s3 o| 7af4b3c7-7de6-4b51-b00e-4ae11a1c639a | Windows2012 | 1 | deleted |* A. I: S" L! _7 N# W; z
| 8abfab0f-5859-45ac-ba94-d968ff85bdab | windows_2016-hdd-8T | 1 | deleted |" c" o6 j8 x5 y' ^
| 8b3f63a8-524d-442d-9bdf-59c5b57f0b98 | RHEL-Server-7.9-ssd | 0 | active |! S* n! O# Z1 H0 S# }
| 92f5512b-1928-4bd0-b8fd-087fffedcf3b | Windows10 | 1 | deleted |& c0 j' ?: f) e; a/ |& d- |
| 938eb113-a5d0-4762-abe5-efb6871c14a4 | RHEL-Server-7.9-ssd | 1 | deleted |
: p9 u9 g8 i, Q3 [/ g6 f) ]| 95910378-8d87-4877-b409-7264dcc90e76 | RHEL-Server-6.9-hdd-2.4T-volumes | 1 | deleted |3 @; K4 X) f; ~2 M& ~
| 993b7f85-f589-484c-a34d-63a37ae4089f | Windows2012 | 0 | active |. [( b& y) g, g& e1 Z: |4 R
| a0069fef-46e9-404d-ae2b-7e35a0f62532 | RHEL-Server-7.9-hdd-2.4T | 1 | deleted |
' E( \; ~2 s7 \( M| a822c008-3f1b-403e-b1f2-69ff729e8c5f | RHEL-Server-7.9-hdd-8T-volumes | 0 | saving |
6 i" |9 D$ W4 o7 A( _| aada273b-f74b-4723-bef8-a2e39da29c5c | CentOS-7.9-hdd-8T-volumes | 1 | deleted |- G& Y, R# A6 U8 k; j! G
| ac76737d-3a05-4869-8a78-573999a5cb5f | Ubuntu20.04 | 1 | deleted |6 o+ k' K7 Y! A Q/ ]
| b97a827c-45c3-432c-b905-44d12b395159 | Centos7.9 | 0 | active |
& @4 F% q5 r0 _6 k6 T9 O| b9c335c4-34a8-498c-a735-82567f7ef186 | rhel-server-7.9-ssd | 1 | deleted |
8 e. H9 D# g: K* i| be80198f-6554-4cef-9eea-a5562a59c4ad | Ubuntu-20.04 | 0 | active |
: |& e6 g; t( }! }8 u/ u| c5858416-b69d-4593-b07a-688b67377280 | Windows2008R2 | 0 | active |
3 O2 ?# f' X% u| ce11d362-88b0-48de-8fd0-3eec4b567733 | Windows-xp-q1 | 1 | deleted |
0 Z* [% |0 S% p% j# X| df76dcba-d60e-45b3-8e5b-2d453b46641d | RHEL-Server-7.9-hdd-2.4T-volumes | 1 | active |4 ?( p3 \8 |/ Z
| e0957ba4-782e-4030-874b-19a1b07156f5 | RHEL-Server-6.9-hdd-8T-volumes | 0 | active |
8 u' u1 I, ~4 N! P| ea333f95-79c3-4ce4-856b-a397cc963d77 | windows_2019_x64-hdd-8T | 0 | active |2 i- [( R/ q5 S0 z
| f5e9e921-3f9b-4f8e-a32a-0b96679483fc | Windows7 | 1 | deleted |
% F4 o5 x" v v0 ]5 E1 g6 U| fb5fe7ed-ba56-4ae2-a483-af3cc0cce891 | RHEL-Server-7.9-ssd | 1 | active |
0 R1 W7 V, i7 ? s% ^9 @0 C2 e8 V0 Y% r| fd6d646f-6c61-4793-87d8-cc180a3259c3 | RHEL-Server-6.9-hdd-2.4T-volumes | 1 | deleted |
( ?- g; d' s) z9 N! T* P7 s( T| fd91972f-726e-43af-855c-636854815b0c | Windows10 | 0 | active |
. Y* e, g! `, R9 w+--------------------------------------+----------------------------------+---------+---------+
4 R( ]. n6 Z& E" L; W* _! A) Y40 rows in set (0.00 sec)
7 [- F; I) P9 E5 R% g! {9 v3 {( R% O
配置：
8 {6 g6 U- ~4 V( X" A4 KMariaDB [glance]> select id,name,deleted,status from images where id="39a2e9a9-2ce5-454a-bd66-47f15eeb11ea";6 ? ^! h1 o: Q8 N; F
+--------------------------------------+--------------------------------+---------+--------+: E% r v, T4 Q2 Y e4 d; q6 v
| id | name | deleted | status |
0 O3 I, Z% C5 }# a4 S% O6 _+--------------------------------------+--------------------------------+---------+--------+
g' u0 l. G; O. T8 d' a) }| 39a2e9a9-2ce5-454a-bd66-47f15eeb11ea | RHEL-Server-7.9-hdd-8T-volumes | 0 | active |
& w& ~8 P( `- X+ s+--------------------------------------+--------------------------------+---------+--------+
% m9 a1 d( ]! [3 O1 row in set (0.01 sec)
3 q9 ]8 L- c3 y, h% ~1 @' B/ Q; r$ W5 `' Y! K! s
6 j2 M+ k* y& [2 ?' J5 U) uMariaDB [glance]> update glance.images set deleted=" 1 " where id="39a2e9a9-2ce5-454a-bd66-47f15eeb11ea";, E% y" j6 p5 q4 C" s: P
Query OK, 1 row affected, 1 warning (0.01 sec)
. y1 |8 P) o3 g HRows matched: 1 Changed: 1 Warnings: 1! W0 h/ p0 f1 b- A0 T2 ^
6 f9 B/ x4 M! D) b3 i% L+ N) k" m$ j9 |1 W1 E
MariaDB [glance]> select id,name,deleted,status from images where id="39a2e9a9-2ce5-454a-bd66-47f15eeb11ea";; v1 w$ ^9 V; t4 a+ v/ t
+--------------------------------------+--------------------------------+---------+--------+
! a4 G) Y. G/ N8 Z/ N5 g| id | name | deleted | status |) h% j. R# j M. V
+--------------------------------------+--------------------------------+---------+--------+, ]$ V1 b- P* a* Z! `
| 39a2e9a9-2ce5-454a-bd66-47f15eeb11ea | RHEL-Server-7.9-hdd-8T-volumes | 1 | active |
" i! w% N6 O; ^( x9 o# M! t+--------------------------------------+--------------------------------+---------+--------+
& }, D8 B& j! Z3 p+ R2 R- s5 W1 row in set (0.00 sec)) q+ }6 f' B4 |0 W6 Y, \) q
8 h9 s# @8 G5 q0 w8 I3 n
$ B! U% y, A) x8 C
9 Z; Z' r+ K& ^- o2 P/ c# I2 m
. e6 l" x) H! b7 | |
|
发表于 2022-7-5 10:48:23