mysql 数据库更新数据 update 命令

admin

mysql> select * from maan ;
+-------+------+-----+-----+
| name  | sex  | age | QQ  |
+-------+------+-----+-----+
| yang3 | man  |  22 | 123 |
8 w5 f* q% K8 b+ u| yang1 | man  |  27 |     |
+-------+------+-----+-----+
2 rows in set (0.00 sec)
) P% K- d3 ^6 ?& C0 `) \! o# bmysql> update sichuan.maan set qq="1234561"  where name='yang3';
; Q9 [  y. g4 K- _Query OK, 1 row affected (0.14 sec)
Rows matched: 1  Changed: 1  Warnings: 0
0 w8 s8 _8 A: J  F6 P# O: `mysql> select * from maan ;
+-------+------+-----+---------+
$ P3 T0 Y/ m7 V3 W7 W6 f( L+ }$ @| name  | sex  | age | QQ      |
  Y5 P0 e& }, z( \& U0 y+-------+------+-----+---------+
| yang3 | man  |  22 | 1234561 |
| yang1 | man  |  27 |         |
+-------+------+-----+---------+
6 y3 X, W: D* b8 o! E2 rows in set (0.00 sec)
% R( _' o/ x! T  ]/ q9 s