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 vote292 views1 answer
Add user mysql wordpress
SQL
0 vote181 views1 answer
Hw to delete a procedure in pl sql
SQL
3 votes216 views2 answers
Synonym oracle
SQL
3 votes179 views1 answer
How to remove characters from string in mysql
SQL
1 vote184 views1 answer
How to remove identity from a column in sql server
SQL
7 votes175 views3 answers
Add primary key to database sql
SQL
6 votes246 views2 answers
Install psql mac
SQL
1 vote183 views2 answers
Find a column in all tables mysql
SQL
4 votes185 views1 answer
Oracle error compilation line
SQL
0 vote182 views1 answer
Mysql grant all on all databases
SQL