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

admin

mysql delete 删除数据库表信息数据
  K- o: s( n9 ^2 H7 y; `& jmysql> delete from sl where name='y';
! A+ F! k+ w. f4 P! h* fQuery OK, 4 rows affected (0.00 sec)

7 S$ K# [7 X. M" r7 b% k8 B
mysql> select * from sl;
+-------+-------+-----+
| name  | sex   | age |
0 K0 T3 L" L9 G+-------+-------+-----+
* ^& h7 ?/ x1 r) F| y     | m     |  25 |
| y     | w     |  22 |
7 v) W+ ~2 P" Y  O9 B0 u9 o$ e) v| y     | m     |  21 |
$ I0 d) G' M$ r" u" J2 J- P| y     | m     |  20 |
3 p7 q, |7 i2 ~+ I- Y1 m+ U| yang1 | woman |  22 |
) w; }2 t/ X* L* r+ R; r| yang2 | man   |  21 |
| yang3 | man   |  20 |
' |; J* z8 j7 I9 |5 p/ @6 q6 U; _+-------+-------+-----+
7 rows in set (0.00 sec)
mysql> delete from sl where name='y';
( q% K) p: I7 i# R$ i  a  mQuery OK, 4 rows affected (0.00 sec)
& E0 x( l9 M7 S9 F# w; ?mysql> select * from sl;
+-------+-------+-----+
| name  | sex   | age |
3 |/ B7 V7 y5 W7 m, C9 |: F) V7 w+-------+-------+-----+
# j9 A0 F) W, A; z4 F+ Y0 S; `| yang1 | woman |  22 |
; H5 ]1 O* C! h| yang2 | man   |  21 |
; H' c3 [- @2 j  @  q- a| yang3 | man   |  20 |
! o3 _* u# ~, S/ U/ q6 u' O+-------+-------+-----+
9 ~7 u7 C; @$ O3 `  b4 b9 j; t3 rows in set (0.00 sec)