contact mysql column field

Solutions on MaxInterview for contact mysql column field by the best coders in the world

showing results for - "contact mysql column field"
Aaron
16 Jul 2020
1mysql> select * from t;
2+------+-------+
3| id   | data  |
4+------+-------+
5|    1 | max   |
6|    2 | linda |
7|    3 | sam   |
8|    4 | henry |
9+------+-------+
104 rows in set (0.02 sec)
11
12mysql> update t set data=concat(data, 'a');
13Query OK, 4 rows affected (0.01 sec)
14Rows matched: 4  Changed: 4  Warnings: 0
15
16mysql> select * from t;
17+------+--------+
18| id   | data   |
19+------+--------+
20|    1 | maxa   |
21|    2 | lindaa |
22|    3 | sama   |
23|    4 | henrya |
24+------+--------+
254 rows in set (0.00 sec)
26