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

0 vote130 views1 answer
How to check xampp mysql password
SQL
0 vote179 views1 answer
Sql server system messeges
SQL
1 vote120 views1 answer
Customer using hdfc bank sql query
SQL
8 votes146 views1 answer
Database backup in mysql server recovery
SQL
0 vote167 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote100 views1 answer
Sql runnignsum
SQL
0 vote130 views1 answer
Power bi dax add related shows column but not working
SQL
0 vote151 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
1 vote136 views1 answer
Check if mysql is installed
SQL
1 vote83 views1 answer
Python escape string for sql
SQL