mysql - SQL UPDATE all values in a field with appended string CONCAT not working - Stack Overflow

Here is what I want to do: current table: +----+ + | id | data | +----+ + | 1 | max | | 2 | linda | | 3 | sam | | 4 | henry | +----+ + Mystery Query ( something like "UPDATE table SET data = CONCAT(data, 'a')" ) ` result table:

stackoverflow.com