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

admin

mysql delete 删除数据库表信息数据
) ?: a" o5 b+ E- Y7 |) b) y& J  y3 tmysql> delete from sl where name='y';
( t+ d) y0 Z9 C2 UQuery OK, 4 rows affected (0.00 sec)

! n) P: p0 r) L7 M
mysql> select * from sl;
+-------+-------+-----+
  R) n0 G0 j3 [' M& B! y: s, H$ _& b| name  | sex   | age |
+-------+-------+-----+
| y     | m     |  25 |
| y     | w     |  22 |
: y3 w7 L/ Q. a- @5 ]: H| y     | m     |  21 |
9 w. `  C( s/ p# j/ \| y     | m     |  20 |
| yang1 | woman |  22 |
0 y3 I' x. s* ?  L: c. w* T| yang2 | man   |  21 |
1 h. A/ }7 \) D5 T1 x% g| yang3 | man   |  20 |
+-------+-------+-----+
$ u& \. B% a) c0 V8 i% T7 F0 c7 rows in set (0.00 sec)
2 ]; A3 o$ J* G5 [  w6 zmysql> delete from sl where name='y';
% |+ y2 v+ H: N5 G4 q' pQuery OK, 4 rows affected (0.00 sec)
: D' H8 u  `4 C: p1 i) Mmysql> select * from sl;
2 G/ ~+ J3 I( p7 H1 s+-------+-------+-----+
| name  | sex   | age |
+-------+-------+-----+
| yang1 | woman |  22 |
| yang2 | man   |  21 |
| yang3 | man   |  20 |
! z$ p+ B. p- ~- A  B+-------+-------+-----+
0 A/ E5 @9 L8 H! G" r9 i3 rows in set (0.00 sec)