delete删除数据 删除某个段落

admin

delete from表名 where 字段=某值 --即删除字段为某值的所有记录
2 Z7 f3 Q) C* p! ~$ ~5 y) a例子：
5 y" H: y1 U( zmysql> delete from jjj where id='4';
9 K9 q3 y0 {: b* s9 k" c2 AQuery OK, 1 row affected (0.11 sec)
mysql> select * from jjj;
( e# x* m7 w! p. [. u+----+------+------+
: |: h) c" n# l9 M| id | name | age  |
+----+------+------+
0 S; d3 D+ b0 l: ]" b. S7 A* d|  1 | yang |   23 |
" b) S4 Q2 a8 R6 Q/ d' H|  2 | ya   |   22 |
|  3 | yang |   23 |
|  5 | yang |   23 |
* @- O4 |. F  C' l/ i|  6 | ya   |   22 |
+----+------+------+
" E: N6 z4 m7 v/ R5 rows in set (0.00 sec)

& B' f5 O$ o2 U) B9 D7 D

admin

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