|
|
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';5 q1 T: e/ f2 G$ O
Query OK, 1 row affected (0.11 sec); H" b: ` J6 a
mysql> select * from jjj;0 b6 m% C3 _- B/ I; j+ K: g
+----+------+------+- n* g1 x( C. w o4 K$ R
| id | name | age |
& C$ D8 q0 K! z% {& V9 q, k+----+------+------+
; g5 o, \4 p# n3 o| 1 | yang | 23 |" r" x1 u7 h" p0 M T; o" M7 q
| 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 |( S& h7 T4 R2 p
| 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)% d# Z- J% C2 C& H
# a4 T" A! t7 b( G, P5 L |
|