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

admin

mysql delete 删除数据库表信息数据
mysql> delete from sl where name='y';
) F( X% k! N3 C4 O- a$ {Query OK, 4 rows affected (0.00 sec)

% e+ M" C$ G. s6 v+ n  ~
mysql> select * from sl;
+-------+-------+-----+
| name  | sex   | age |
+-------+-------+-----+
9 V7 y8 f, l! Y* y8 a& L! p! k| y     | m     |  25 |
( \2 L- Q. x- d6 {| y     | w     |  22 |
| y     | m     |  21 |
( Y& j0 {" w& ]9 e- e| y     | m     |  20 |
# G2 k4 }. j( H| yang1 | woman |  22 |
| yang2 | man   |  21 |
| yang3 | man   |  20 |
" ^8 I; @- M- R& y+-------+-------+-----+
( |! t, m4 d/ w7 rows in set (0.00 sec)
; S; j  u, n/ c& W) {/ K; `( Zmysql> delete from sl where name='y';
( s6 K& h6 ^! a/ Z1 y' {Query OK, 4 rows affected (0.00 sec)
6 P# D/ p- o! t, l5 K  pmysql> select * from sl;
+ G. m; b+ f  T; q" \+-------+-------+-----+
9 F  H; v: h$ H3 z) m| name  | sex   | age |
+-------+-------+-----+
| yang1 | woman |  22 |
| yang2 | man   |  21 |
| yang3 | man   |  20 |
: c. ^( E) n* v& I7 F+-------+-------+-----+
* [5 P, d- ^6 `- t. c$ j4 C  u3 rows in set (0.00 sec)