mysql delete 删除数据库表信息数据

admin

mysql delete 删除数据库表信息数据
, y. f' j1 G% q$ q$ |mysql> delete from sl where name='y';
& J1 h8 t8 N- ^7 Y& n$ LQuery OK, 4 rows affected (0.00 sec)


7 k4 t7 P2 I; h- Z0 f  {/ H* l8 |mysql> select * from sl;
+-------+-------+-----+
| name  | sex   | age |
) L0 w- N1 ^' t; V7 K: _! j+ z+-------+-------+-----+
| y     | m     |  25 |
7 y$ m. d4 [9 J/ x7 P* n| y     | w     |  22 |
/ @" P. [) H& T" q3 W6 O| y     | m     |  21 |
| y     | m     |  20 |
$ m2 h6 E" }# |1 W& N| yang1 | woman |  22 |
, Y8 D' O) S$ c7 I" b# _' C3 p' s| yang2 | man   |  21 |
( D. ]( Y) b  a, w| yang3 | man   |  20 |
+-------+-------+-----+
7 rows in set (0.00 sec)
/ d: }5 h2 J- e' }# X4 l1 ymysql> delete from sl where name='y';
Query OK, 4 rows affected (0.00 sec)
: H# `- f# k+ f+ Q9 Fmysql> select * from sl;
# N' a- Y; t0 h  \1 p8 P+-------+-------+-----+
| name  | sex   | age |
+-------+-------+-----+
| yang1 | woman |  22 |
, T( F, Q# w5 w, ?- x| yang2 | man   |  21 |
- X4 \9 F) Y- b5 u9 b; a& F/ }| yang3 | man   |  20 |
+ Y$ k/ ^$ J  M* s! Q+-------+-------+-----+
3 rows in set (0.00 sec)
8 s, \2 R& `" ^0 Q& ^