|
|
操作步骤如下：
$ K6 p7 h' d4 l8 t7 t* SMariaDB [(none)]> use glance
1 c+ m2 J7 T2 `. [Reading table information for completion of table and column names5 U$ }+ P! _6 `3 P E
You can turn off this feature to get a quicker startup with -A
0 o4 n/ j3 Q+ r& ~
; i5 Y( \4 [5 lDatabase changed
" j6 k$ Y* s+ t2 G* R" A% T' Q6 P. P: Y
MariaDB [glance]> select id,name,deleted,status from images;) b7 ~ R6 i& z9 ]
+--------------------------------------+----------------------------------+---------+---------+
2 |5 Z f+ `2 v6 K5 m4 r: t| id | name | deleted | status |
! t: ^: b: J% G/ W! P" ~+--------------------------------------+----------------------------------+---------+---------+
+ n7 C2 z( n8 t: U; X0 o5 q J| 020f070c-b3e6-4623-8035-3b0bbbf8c005 | Windows-xp | 0 | active |4 p9 H& Q- L: h* B9 w8 S
| 0470245c-ee24-488f-89c9-622fd85e9ade | centOS7.9-x86-ssd | 1 | deleted |6 p8 Y5 j6 d0 m5 c: r$ ~4 t
| 097295bd-4a1d-4a91-bfd0-d0ad64e971ff | Ubuntu-20.04 | 1 | deleted |
5 F0 X9 r$ X A& c6 O6 t& c| 16f278e3-809b-47e8-b6b1-ae96cba1c29c | windows7 | 0 | active |
, h5 L' s \9 X1 o5 U, z| 18804abd-9cba-4a94-8ceb-ba9b12f9fc47 | RHEL-Server-7.9-hdd-2.4T | 1 | active |
$ \; ?6 W3 N7 C e| 1d45630e-510c-4e65-b89d-ae8b615dd344 | RHEL-Server-6.9-hdd-2.4T-volumes | 1 | deleted |" |" S) H u! ?8 v* u0 Y
| 20b59ace-b0d1-4b1f-a5da-bc786aa80be1 | Windows-xp-q1 | 1 | deleted |
' |& U5 @- j4 p5 h| 240389c3-4df0-4313-91b4-7e801fa4c12c | RHEL-Server-6.9-hdd-2.4T-volumes | 1 | deleted |: S3 \5 ^9 Q1 Y8 [# }0 o; Z9 u
| 2c06a4cc-b62f-4e97-bc91-39e97e62aafe | windows_2016-hdd-8T | 1 | deleted |9 z) I, e- e! T6 r- u
| 2d208a0c-3bc5-4ab5-979a-0b6ac5e592dd | Ubuntu-20.04-1 | 1 | deleted |. M' C1 t0 Q7 M: U; N; {
| 3196221b-c211-422b-bc25-d2a23acdd276 | CentOS-7.9-hdd-8T-volumes | 0 | active |
5 w- `( u5 c. T3 C7 ~: ]| 39a2e9a9-2ce5-454a-bd66-47f15eeb11ea | RHEL-Server-7.9-hdd-8T-volumes | 0 | active |
0 j% h0 w5 A2 Y6 v7 p2 ^| 441e4f7c-6d1b-4257-90b3-e2cce50f2142 | RHEL-Server-6.9-hdd-2.4T-volumes | 1 | deleted |
5 o4 l: T0 y8 s+ e* I9 ?| 55bf968d-6fb0-4da9-93e4-942b0667af9b | windows_2016-hdd-8T | 0 | active |! R, A( g7 l1 j$ {" h/ d' s
| 636cd370-b4c5-4358-ba71-ab1b34bb4f29 | debian11 | 1 | deleted |
0 @& C! ?( J: d; f1 a; h| 6a679a2a-3269-4467-af91-8d2e6bb6b13c | Windows2012 | 1 | deleted |0 R+ L( m8 F, e! E+ I
| 6b7238ea-9005-497e-8ce2-1195cad17dde | windows7 | 1 | deleted |
2 p9 k& L* V/ _* N6 a" T| 7af4b3c7-7de6-4b51-b00e-4ae11a1c639a | Windows2012 | 1 | deleted |$ r) Z8 A7 s) B( M1 l$ p( r
| 8abfab0f-5859-45ac-ba94-d968ff85bdab | windows_2016-hdd-8T | 1 | deleted |
7 c6 X4 H' c7 k6 N! P$ h$ J| 8b3f63a8-524d-442d-9bdf-59c5b57f0b98 | RHEL-Server-7.9-ssd | 0 | active |
5 O+ W8 ~$ K2 |* d0 Q6 K| 92f5512b-1928-4bd0-b8fd-087fffedcf3b | Windows10 | 1 | deleted |6 l) y" Y; `! ^6 h
| 938eb113-a5d0-4762-abe5-efb6871c14a4 | RHEL-Server-7.9-ssd | 1 | deleted |
* l7 w4 M) x$ o) T| 95910378-8d87-4877-b409-7264dcc90e76 | RHEL-Server-6.9-hdd-2.4T-volumes | 1 | deleted |& `4 d: ^- h/ ~4 [: ^
| 993b7f85-f589-484c-a34d-63a37ae4089f | Windows2012 | 0 | active |
S. t9 e' q' Y; p| a0069fef-46e9-404d-ae2b-7e35a0f62532 | RHEL-Server-7.9-hdd-2.4T | 1 | deleted |
" I+ ~( a. [2 s| a822c008-3f1b-403e-b1f2-69ff729e8c5f | RHEL-Server-7.9-hdd-8T-volumes | 0 | saving |
' V0 L/ k/ _0 ]% G8 C Q| aada273b-f74b-4723-bef8-a2e39da29c5c | CentOS-7.9-hdd-8T-volumes | 1 | deleted |- P' {; K- P. \5 P& F/ \# U* w
| ac76737d-3a05-4869-8a78-573999a5cb5f | Ubuntu20.04 | 1 | deleted |
1 F) C7 `: d' J$ f# K+ V( y| b97a827c-45c3-432c-b905-44d12b395159 | Centos7.9 | 0 | active |3 Z$ e& ^) T( T# a- n0 U+ t
| b9c335c4-34a8-498c-a735-82567f7ef186 | rhel-server-7.9-ssd | 1 | deleted |. c9 ?2 ^2 y1 u( A1 D/ ]0 F, b
| be80198f-6554-4cef-9eea-a5562a59c4ad | Ubuntu-20.04 | 0 | active |
' }; y( N7 E- j j& O- S| c5858416-b69d-4593-b07a-688b67377280 | Windows2008R2 | 0 | active |0 n, d8 X* r {- ?* w
| ce11d362-88b0-48de-8fd0-3eec4b567733 | Windows-xp-q1 | 1 | deleted |; i5 Y- p1 ?" X4 Q. |
| df76dcba-d60e-45b3-8e5b-2d453b46641d | RHEL-Server-7.9-hdd-2.4T-volumes | 1 | active |! i2 e, C" H( ]! B& _" j1 v# M
| e0957ba4-782e-4030-874b-19a1b07156f5 | RHEL-Server-6.9-hdd-8T-volumes | 0 | active |% `, _# @$ W1 A5 r, d
| ea333f95-79c3-4ce4-856b-a397cc963d77 | windows_2019_x64-hdd-8T | 0 | active |
4 r% T, H) u7 }0 d| f5e9e921-3f9b-4f8e-a32a-0b96679483fc | Windows7 | 1 | deleted |
% m! I2 g3 O9 `7 k5 F% l" X| fb5fe7ed-ba56-4ae2-a483-af3cc0cce891 | RHEL-Server-7.9-ssd | 1 | active |! b& \$ ~5 r5 q( W
| fd6d646f-6c61-4793-87d8-cc180a3259c3 | RHEL-Server-6.9-hdd-2.4T-volumes | 1 | deleted |
$ m0 h5 @7 w$ h7 \# Z| fd91972f-726e-43af-855c-636854815b0c | Windows10 | 0 | active |$ n' s# {( F9 j: d! Z6 H, C
+--------------------------------------+----------------------------------+---------+---------+
9 @- Q) o, N5 h; s8 X/ R40 rows in set (0.00 sec)( I5 b1 T6 R1 g% S, t
, W3 q& N! ?: E配置：
. o" w5 t- S; o' F/ ~0 v% o( ?( }MariaDB [glance]> select id,name,deleted,status from images where id="39a2e9a9-2ce5-454a-bd66-47f15eeb11ea";/ y8 J2 R- ^- {: i: F2 n. c: u
+--------------------------------------+--------------------------------+---------+--------+
! m+ f5 U" C; T+ ?| id | name | deleted | status |, `# V+ f U( R$ M. `
+--------------------------------------+--------------------------------+---------+--------+
; Q( a P7 r4 B: I% [; m| 39a2e9a9-2ce5-454a-bd66-47f15eeb11ea | RHEL-Server-7.9-hdd-8T-volumes | 0 | active |
( q+ b' _0 }; b$ V3 @3 ?9 S+--------------------------------------+--------------------------------+---------+--------+; B4 z0 {3 O/ y# n
1 row in set (0.01 sec)# `7 }# E/ Q0 T9 K: @ h$ {" u! e
) d6 B$ P% k" Y) u& e; u
% x9 |& Y: W$ m) M6 SMariaDB [glance]> update glance.images set deleted=" 1 " where id="39a2e9a9-2ce5-454a-bd66-47f15eeb11ea";
, @# i3 O1 m/ O. s; AQuery OK, 1 row affected, 1 warning (0.01 sec)
! w9 C/ R: y- k! \9 L* pRows matched: 1 Changed: 1 Warnings: 1
" R8 b- e' R+ o! ^9 @/ ^
7 x# ]; k; g# h! [' @9 L2 S6 r. m; _& I/ z4 S {4 C
MariaDB [glance]> select id,name,deleted,status from images where id="39a2e9a9-2ce5-454a-bd66-47f15eeb11ea"; c! X }: D3 C+ z( O) j, W
+--------------------------------------+--------------------------------+---------+--------+
9 V- G; x+ y" Y+ j G4 f| id | name | deleted | status |
+ V, |/ O) k4 K4 e5 q# }; R+--------------------------------------+--------------------------------+---------+--------+! [. l# k& J* a( ^6 w( a4 o
| 39a2e9a9-2ce5-454a-bd66-47f15eeb11ea | RHEL-Server-7.9-hdd-8T-volumes | 1 | active |
& \" J9 _; M8 m, `+--------------------------------------+--------------------------------+---------+--------+3 O1 M. Y2 U" S0 c3 N* i% X
1 row in set (0.00 sec)
% |7 i* i6 j- O2 G4 [, R5 F7 V% G5 J' N( C
" @6 C5 }% w( f( ]! M
/ t5 Y' B# y( S! [3 k9 Q3 \9 F
4 J, o# ` U6 }5 d |
|
发表于 2022-7-5 10:48:23