|
|
mysql> select * from maan ;
9 B; ]1 C7 j" C: L% n3 L+-------+------+-----+-----++ T0 S. s# D4 _4 V8 [" l" X' b
| name | sex | age | QQ |% o a1 M5 t( r1 }" C
+-------+------+-----+-----+3 Z# ]1 ^$ e% i- u8 Y, c0 X i0 c
| yang3 | man | 22 | 123 |5 f! j7 i8 E1 ]" V8 R
| yang1 | man | 27 | |
! h2 z9 c& ~( G+-------+------+-----+-----+
- l0 ]8 F4 C/ K: H; G5 Z" M" B4 v2 rows in set (0.00 sec)1 D- H: R7 a9 r0 T2 _0 L
mysql> update sichuan.maan set qq="1234561" where name='yang3';
! h' R, z4 L" d1 Q5 z7 w |Query OK, 1 row affected (0.14 sec)0 y! ^( P, Q2 C: {' T
Rows matched: 1 Changed: 1 Warnings: 0
6 |5 e( I/ a; _1 P T8 Tmysql> select * from maan ;
8 Z4 v0 K: Z9 r$ H4 ~$ t2 H+-------+------+-----+---------+
; Q; v: J4 [6 c A( W| name | sex | age | QQ |/ E7 t" g" N, u5 `. b3 ^ r1 C& f
+-------+------+-----+---------+# V$ t6 i( O2 ~
| yang3 | man | 22 | 1234561 |: \/ ~: ]% _4 H
| yang1 | man | 27 | |7 D# k& r# ~! r+ _7 T2 ~. z: i
+-------+------+-----+---------+* T! d, {) \1 r# o
2 rows in set (0.00 sec)
5 q7 Z0 G9 j; M& i |
|
发表于 2020-6-15 12:00:27