Contact mysql column field

mysql> select * from t;
+------+-------+
| id   | data  |
+------+-------+
|    1 | max   |
|    2 | linda |
|    3 | sam   |
|    4 | henry |
+------+-------+
4 rows in set (0.02 sec)

mysql> update t set data=concat(data, 'a');
Query OK, 4 rows affected (0.01 sec)
Rows matched: 4  Changed: 4  Warnings: 0

mysql> select * from t;
+------+--------+
| id   | data   |
+------+--------+
|    1 | maxa   |
|    2 | lindaa |
|    3 | sama   |
|    4 | henrya |
+------+--------+
4 rows in set (0.00 sec)

Source: stackoverflow.com

Similar codes

2 votes277 views1 answer
Oracle index size
SQL
0 vote300 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote271 views1 answer
Mql5 list all available symbols
SQL
0 vote290 views1 answer
Mysql count unique in group statement
SQL
0 vote280 views1 answer
Find wordpress version in database
SQL
0 vote284 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
1 vote279 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote283 views2 answers
Getting customers with no orders sql
SQL
6 votes273 views3 answers
Mysql first day of year
SQL
1 vote270 views1 answer
Mysql select month and year
SQL