delete删除数据 删除某个段落

admin

delete from表名 where 字段=某值 --即删除字段为某值的所有记录
  R5 L7 ?- N. W, n例子：
2 }% P  I7 g/ D: Z2 m% K) u2 y9 A& T  ymysql> delete from jjj where id='4';
Query OK, 1 row affected (0.11 sec)
mysql> select * from jjj;
+----+------+------+
| id | name | age  |
& C$ D8 q0 K! z% {& V9 q, k+----+------+------+
; g5 o, \4 p# n3 o|  1 | yang |   23 |
|  2 | ya   |   22 |
3 c( H. Z" n) R, p. ]( i|  3 | yang |   23 |
" X3 u' p1 Q) o( \, q5 h& U|  5 | yang |   23 |
|  6 | ya   |   22 |
5 X' K9 i2 c& b4 E3 g( \! u2 e+----+------+------+
  Z( r& \9 Z" S/ z  l5 rows in set (0.00 sec)

# a4 T" A! t7 b( G, P5 L

admin

mysql> delete from jjj where id='5';
0 d7 j" C" b% m7 W, ]( {2 X2 tQuery OK, 1 row affected (0.33 sec)