mysql 数据库更新数据 update 命令

admin

mysql> select * from maan ;
+-------+------+-----+-----+
| name  | sex  | age | QQ  |
+-------+------+-----+-----+
" Z% f. c( w2 c" S- v0 M| yang3 | man  |  22 | 123 |
3 Q8 u. ]8 M7 d6 u& C' v1 u, X| yang1 | man  |  27 |     |
" e% @- A9 R# C+-------+------+-----+-----+
3 o9 ]3 [; x0 W  q6 R3 V9 c2 rows in set (0.00 sec)
mysql> update sichuan.maan set qq="1234561"  where name='yang3';
Query OK, 1 row affected (0.14 sec)
6 H) C7 P& q- Q# [8 ~9 g* bRows matched: 1  Changed: 1  Warnings: 0
+ ], U+ W. N# o2 Q4 M) Cmysql> select * from maan ;
+-------+------+-----+---------+
| name  | sex  | age | QQ      |
7 N! D! h+ J# D2 V  U6 c) v+-------+------+-----+---------+
0 j2 J4 V% s) @2 n. a2 E& W2 I| yang3 | man  |  22 | 1234561 |
, `( v- ^/ x8 |* d| yang1 | man  |  27 |         |
+-------+------+-----+---------+
2 rows in set (0.00 sec)
9 ~% g7 ~9 M9 y' G1 T) T6 X) O