delete删除数据 删除某个段落

admin

delete from表名 where 字段=某值 --即删除字段为某值的所有记录
9 B6 A0 a. ?! {1 R, O% K. Z例子：
mysql> delete from jjj where id='4';
& G0 T) n+ A. I4 @2 D" }. BQuery OK, 1 row affected (0.11 sec)
mysql> select * from jjj;
8 F6 Z5 y4 r: }. N0 |+----+------+------+
| id | name | age  |
3 n5 ]4 K9 U8 o8 D7 M+----+------+------+
|  1 | yang |   23 |
|  2 | ya   |   22 |
8 k$ |( q8 {% E" ~3 G6 l# o  N+ T3 }|  3 | yang |   23 |
|  5 | yang |   23 |
& V8 l3 f% i: b9 Y4 K( @/ t$ Z5 K|  6 | ya   |   22 |
+----+------+------+
5 rows in set (0.00 sec)
- |7 b+ k; u8 X2 @) E- ?6 `

admin

mysql> delete from jjj where id='5';
Query OK, 1 row affected (0.33 sec)