|
|
mysql> select * from maan ;
; `1 N) \0 ?. z9 Y! J+-------+------+-----+-----+
5 [. I6 Y8 S4 j0 ?3 R' v4 t |) r| name | sex | age | QQ |3 E" f! S! J. v5 M
+-------+------+-----+-----+
* B! U$ ~% d5 R+ g, x" i| yang3 | man | 22 | 123 |
' e6 J1 W( P" x; v| yang1 | man | 27 | |: w5 Q# V7 A, M& w$ _/ u9 _$ h5 [
+-------+------+-----+-----+$ {0 U& G) v/ Y# Y8 B1 _0 V b. S- P! c
2 rows in set (0.00 sec); Z1 e( o j& @& q- L8 A; ^
mysql> update sichuan.maan set qq="1234561" where name='yang3';
) S4 F6 V5 U1 f7 ^1 N1 K) ?* @+ dQuery OK, 1 row affected (0.14 sec)) p; v3 k9 Z1 [. a# c1 |: p9 L1 h
Rows matched: 1 Changed: 1 Warnings: 0$ I. o1 ?" g S/ W. Q+ ~+ Y
mysql> select * from maan ;+ U5 \( [3 k. B; l
+-------+------+-----+---------+
- Z0 k8 g# q8 o5 _2 g| name | sex | age | QQ |
) n+ J8 i' l5 o6 Q5 \9 y+-------+------+-----+---------+
; K2 d9 H1 O) y9 ]" _7 s9 [/ || yang3 | man | 22 | 1234561 |* G! u- N( y( @3 c1 _
| yang1 | man | 27 | |" `1 z1 K$ [5 S0 f# T% T
+-------+------+-----+---------+
! C+ u; z0 V, x5 d1 _1 C2 rows in set (0.00 sec) H3 e. w+ u% N! E) }0 ^
|
|
发表于 2020-6-15 12:00:27