更新时间:2021-10-27 09:52:15
您可以使用 CONCAT 函数来做到这一点:
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%';