mysql 数据库更新数据 update 命令

admin

mysql> select * from maan ;
* L6 s, I/ N9 L7 \3 q! A+-------+------+-----+-----+
4 t9 }9 H' h9 j9 b$ C3 Y# R| name  | sex  | age | QQ  |
4 K" X# W' d  Y' r$ h' R1 e, y( t+-------+------+-----+-----+
1 u2 @5 a+ ^6 e, m| yang3 | man  |  22 | 123 |
| yang1 | man  |  27 |     |
+-------+------+-----+-----+
2 rows in set (0.00 sec)
mysql> update sichuan.maan set qq="1234561"  where name='yang3';
0 H) G; V( \/ NQuery OK, 1 row affected (0.14 sec)
Rows matched: 1  Changed: 1  Warnings: 0
7 t$ h, l5 e: j4 lmysql> select * from maan ;
+-------+------+-----+---------+
- ]2 T4 e0 Y0 z# X! q3 A| name  | sex  | age | QQ      |
+-------+------+-----+---------+
| yang3 | man  |  22 | 1234561 |
% {: o* {3 o% v| yang1 | man  |  27 |         |
+-------+------+-----+---------+
2 rows in set (0.00 sec)
5 x& P3 Z3 ^# t& z) ?" d