您可以使用

You can use the CONCAT function to do that:

UPDATE tbl SET col=CONCAT('test',col);

如果您想变得更聪明，并且只更新尚未预先进行测试的列，请尝试

If you want to get cleverer and only update columns which don't already have test prepended, try

UPDATE tbl SET col=CONCAT('test',col)
WHERE col NOT LIKE 'test%';