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

admin

mysql delete 删除数据库表信息数据
; o/ X: I8 }8 F, |3 n% m* l, Gmysql> delete from sl where name='y';
Query OK, 4 rows affected (0.00 sec)
. w& v6 i9 Y7 Y7 r7 C! L6 Y% Y& P

0 q1 o: p8 |7 j% L$ Z6 \" Umysql> select * from sl;
+-------+-------+-----+
  t& m# \) A3 J0 J| name  | sex   | age |
+-------+-------+-----+
' ~% M% u2 D( }% k! H0 R% M3 L# R| y     | m     |  25 |
| y     | w     |  22 |
| y     | m     |  21 |
4 ?  n! W6 J7 B) I| y     | m     |  20 |
| yang1 | woman |  22 |
  v' j1 P6 x/ L5 P1 s; I| yang2 | man   |  21 |
| yang3 | man   |  20 |
: W+ v0 i$ o& I( P+-------+-------+-----+
7 rows in set (0.00 sec)
3 E8 F1 F! i: V: h) b$ Omysql> delete from sl where name='y';
5 f' i6 E  T( E' ^  xQuery OK, 4 rows affected (0.00 sec)
9 c% {" I: A1 C' b/ ^mysql> select * from sl;
+-------+-------+-----+
| name  | sex   | age |
+-------+-------+-----+
| yang1 | woman |  22 |
6 \' W% s! F/ N| yang2 | man   |  21 |
8 q) V) \; O& h| yang3 | man   |  20 |
+-------+-------+-----+
3 rows in set (0.00 sec)
. N  y! f# o" u