mysql 数据库更新数据 update 命令

admin

mysql> select * from maan ;
8 Z! h; ^2 x; c6 ~/ S4 [( V+-------+------+-----+-----+
| name  | sex  | age | QQ  |
5 L8 @. G1 Z' j' G) d! t+-------+------+-----+-----+
| yang3 | man  |  22 | 123 |
| yang1 | man  |  27 |     |
& ?( ^" z# G/ L  C5 G+-------+------+-----+-----+
2 rows in set (0.00 sec)
5 S4 U8 F1 ^" o$ E# D" a0 D2 ?mysql> update sichuan.maan set qq="1234561"  where name='yang3';
5 `# q% q, k1 @2 D5 kQuery OK, 1 row affected (0.14 sec)
Rows matched: 1  Changed: 1  Warnings: 0
% q, B: q( H5 K5 rmysql> select * from maan ;
+-------+------+-----+---------+
4 r7 a5 H5 Q0 }2 n% B7 P) K| name  | sex  | age | QQ      |
+-------+------+-----+---------+
| yang3 | man  |  22 | 1234561 |
| yang1 | man  |  27 |         |
+-------+------+-----+---------+
2 ~5 h2 Q4 A4 g. ]2 rows in set (0.00 sec)