|
|
delete from表名 where 字段=某值 --即删除字段为某值的所有记录. y4 k/ b. A# C7 e9 H
例子：- s( S9 g* r/ N/ H
mysql> delete from jjj where id='4';0 x8 t+ a( s2 ^% P: j( G/ g8 c" l! x
Query OK, 1 row affected (0.11 sec)
+ g% ]7 F9 J6 @( Amysql> select * from jjj;
^2 O8 d2 H5 J, q, t, A" H+----+------+------+) a5 [. d( I% N8 `% Y* Z) m3 {
| id | name | age |
. f/ m/ r8 e1 T+----+------+------+
( ~! F5 G' c3 \2 k; ~| 1 | yang | 23 |4 l* Q* A$ t3 W
| 2 | ya | 22 |
+ i* g! y I8 F| 3 | yang | 23 |
1 f6 q8 k. j/ ~! C| 5 | yang | 23 |5 ]. `8 t1 F" B) K$ i
| 6 | ya | 22 |0 @+ ^7 V' f7 I2 _( Q+ c' i/ o( w
+----+------+------+
T9 k9 f9 q/ Z) r' m* W5 M; D5 rows in set (0.00 sec)
$ l) u+ J7 G( d5 X+ j* g4 y& E" ?' c7 d
|
|
发表于 2020-6-18 10:07:59