delete删除数据 删除某个段落

admin

delete from表名 where 字段=某值 --即删除字段为某值的所有记录
0 p: q, X9 l+ I5 X- g例子：
mysql> delete from jjj where id='4';
" X& w& h! Q( ~6 A, h; X7 TQuery OK, 1 row affected (0.11 sec)
mysql> select * from jjj;
. E0 X& N+ i  i4 K% R! i0 D5 o4 m$ q+----+------+------+
3 m( T/ t* B2 G* C* a1 V| id | name | age  |
+ X6 C1 l6 j. f  B. }& L+----+------+------+
- f' [" D9 |- g3 Y9 C* c% y|  1 | yang |   23 |
|  2 | ya   |   22 |
. t! H2 p5 m' C# O' |+ J|  3 | yang |   23 |
2 C9 X4 r- Q, t. G0 j|  5 | yang |   23 |
" J/ `/ }" m0 D- k8 w|  6 | ya   |   22 |
' Q6 E$ n8 Q, V5 m$ v+----+------+------+
5 rows in set (0.00 sec)
  _0 P+ R0 O4 S4 d2 m

admin

mysql> delete from jjj where id='5';
+ v: l/ G+ p' B1 r! a0 M" EQuery OK, 1 row affected (0.33 sec)