mysql 数据库更新数据 update 命令

admin

mysql> select * from maan ;
+-------+------+-----+-----+
| name  | sex  | age | QQ  |
  i( r' o3 g; H+-------+------+-----+-----+
5 A1 P9 q$ ]) I( Z4 V( S| yang3 | man  |  22 | 123 |
0 w; S; Q4 U( z* J| yang1 | man  |  27 |     |
. K. {' R8 Q- C0 D- ?' L+-------+------+-----+-----+
2 rows in set (0.00 sec)
mysql> update sichuan.maan set qq="1234561"  where name='yang3';
Query OK, 1 row affected (0.14 sec)
Rows matched: 1  Changed: 1  Warnings: 0
* v# }  `: k! s$ Z- E0 j  Y$ r. x3 pmysql> select * from maan ;
  R0 e) f1 j% d2 ?$ v3 I+-------+------+-----+---------+
5 w# _0 Y/ K' Y( K8 E5 |$ k| name  | sex  | age | QQ      |
5 o. ^+ e  V; q. @9 N+ r% O9 ]+-------+------+-----+---------+
| yang3 | man  |  22 | 1234561 |
2 c3 ]' a" b9 h7 g3 r4 E| yang1 | man  |  27 |         |
+-------+------+-----+---------+
2 rows in set (0.00 sec)