mysql 数据库更新数据 update 命令

admin

mysql> select * from maan ;
+-------+------+-----+-----+
| name  | sex  | age | QQ  |
$ c- {% N8 y+ n$ Z( d+-------+------+-----+-----+
| yang3 | man  |  22 | 123 |
| yang1 | man  |  27 |     |
  `& C) D4 K) Q- D/ C! H: _4 H+-------+------+-----+-----+
2 rows in set (0.00 sec)
( P6 j7 ~7 W! m( H) L* M# imysql> update sichuan.maan set qq="1234561"  where name='yang3';
Query OK, 1 row affected (0.14 sec)
: F. L# h& Q+ ~( nRows matched: 1  Changed: 1  Warnings: 0
mysql> select * from maan ;
1 O. r9 d0 q! V& |* f% \* O+-------+------+-----+---------+
, L4 }3 I* x* b2 V' `6 x% T$ U| name  | sex  | age | QQ      |
  i2 u2 @) a; S* j. K% v. Z1 |+-------+------+-----+---------+
| yang3 | man  |  22 | 1234561 |
| yang1 | man  |  27 |         |
; L# D1 s& A& V+-------+------+-----+---------+
# j9 t& e6 s. S. E) s0 K2 rows in set (0.00 sec)