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

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

瀏覽:696
日期:2024-05-24
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:...看更多