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

admin

mysql delete 删除数据库表信息数据
* t  g6 N5 k. l* n/ U* D, Mmysql> delete from sl where name='y';
Query OK, 4 rows affected (0.00 sec)
$ T+ w# c$ P" y3 _. H" A! K

mysql> select * from sl;
, B: m. N% D% }' p" h' V: V4 F+-------+-------+-----+
| name  | sex   | age |
0 k9 o. ?: b' W2 s- H) g7 v9 q+-------+-------+-----+
* q4 V5 ^  I, i3 L| y     | m     |  25 |
  o# }$ L- z$ v' o5 `- U. a* ?| y     | w     |  22 |
! {* w" v- l$ G) v7 d1 J1 ]| y     | m     |  21 |
$ b1 }& q2 ]3 [$ E9 c# s| y     | m     |  20 |
| yang1 | woman |  22 |
| yang2 | man   |  21 |
6 c! s) R& n3 V/ N+ ?4 k  i| yang3 | man   |  20 |
+-------+-------+-----+
# a( k3 l  p1 L5 v7 rows in set (0.00 sec)
+ i: _% v3 v4 k) zmysql> delete from sl where name='y';
0 t- L+ q/ W! b% b! @' n  jQuery OK, 4 rows affected (0.00 sec)
5 A3 U/ |9 Y8 M! y  j! hmysql> select * from sl;
+-------+-------+-----+
| name  | sex   | age |
+-------+-------+-----+
| yang1 | woman |  22 |
| yang2 | man   |  21 |
" l$ ?7 o% K2 {| yang3 | man   |  20 |
+-------+-------+-----+
4 Z0 S. ]; u- u( R% n$ j7 P# e3 rows in set (0.00 sec)