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

admin

mysql delete 删除数据库表信息数据
! G- U2 n5 c1 }% d- }mysql> delete from sl where name='y';
2 @9 Q4 r& }1 IQuery OK, 4 rows affected (0.00 sec)

0 _- r- S3 k0 F# Z8 Y) T% z3 U( F( f
mysql> select * from sl;
+-------+-------+-----+
$ H1 X9 @& L' s6 e| name  | sex   | age |
+-------+-------+-----+
| y     | m     |  25 |
3 ?  w& B( M+ s  s| y     | w     |  22 |
| y     | m     |  21 |
| y     | m     |  20 |
| yang1 | woman |  22 |
| yang2 | man   |  21 |
| yang3 | man   |  20 |
+-------+-------+-----+
2 j& Y+ u- ?- U" |# Y7 rows in set (0.00 sec)
mysql> delete from sl where name='y';
Query OK, 4 rows affected (0.00 sec)
mysql> select * from sl;
+-------+-------+-----+
| name  | sex   | age |
+-------+-------+-----+
' E* _5 C; E* S7 P/ B! H+ h| yang1 | woman |  22 |
1 V# \. w' [  o* I| yang2 | man   |  21 |
| yang3 | man   |  20 |
7 y* C- n# q" p" Z3 t  l+-------+-------+-----+
( c* w! B1 H. z& v4 F1 T3 rows in set (0.00 sec)