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

admin

mysql delete 删除数据库表信息数据
" |3 `6 }( A0 i- A3 H& k' emysql> delete from sl where name='y';
9 R( |: G6 p: @  L8 kQuery OK, 4 rows affected (0.00 sec)

9 k* N6 }' p+ q% @" P! e5 M  o9 O
. o! h0 Q* ^; h& o# C- U: ?. {( vmysql> select * from sl;
. J0 l7 r7 h  h1 y! C/ @+-------+-------+-----+
+ p3 j6 k& j& [2 z# e| name  | sex   | age |
+-------+-------+-----+
| y     | m     |  25 |
- H1 q- D& }: |: [! V( b3 P| y     | w     |  22 |
| y     | m     |  21 |
| y     | m     |  20 |
( G( |+ ?" \7 a1 |$ i5 D" y| yang1 | woman |  22 |
  N* }' h2 y% n2 n; o. H2 L- ^, Y| yang2 | man   |  21 |
| yang3 | man   |  20 |
. d& j) A3 Z" J  D5 ]* U1 G. D& z+-------+-------+-----+
4 x) P. w1 z$ y9 F  V' E7 rows in set (0.00 sec)
/ e$ F4 {; B& J% l. O3 w( m0 Omysql> delete from sl where name='y';
Query OK, 4 rows affected (0.00 sec)
- n* l8 v9 ]+ r- B2 _: ~mysql> select * from sl;
6 D0 @% M, c) y( e0 }+-------+-------+-----+
, [2 v9 t# J1 j4 P+ M( ]| name  | sex   | age |
# v% m. ?2 `5 w! l5 g  B  ]5 H# [+-------+-------+-----+
9 ^) l% B' {, `; A5 m! L' Y8 v| yang1 | woman |  22 |
  D# n: S9 p0 l( A( N1 q5 c% L| yang2 | man   |  21 |
| yang3 | man   |  20 |
+-------+-------+-----+
6 x2 b$ S, z  A. \; e  b3 rows in set (0.00 sec)
1 j- L! C# b' V6 W" p