mysql字段内容替换
UPDATE 表名 SET 字段名= replace(字段名, '查找内容', '替换成内容');
UPDATE image_file SET path_nei = replace(path_nei, '/home/upload', '/opt/upload');
mysql复制一列数据到另一列
UPDATE 表名 SET 目标类名=源列名;
UPDATE `image_file` SET path_nei = path;
mysql字段内容替换
UPDATE 表名 SET 字段名= replace(字段名, '查找内容', '替换成内容');
UPDATE image_file SET path_nei = replace(path_nei, '/home/upload', '/opt/upload');
mysql复制一列数据到另一列
UPDATE 表名 SET 目标类名=源列名;
UPDATE `image_file` SET path_nei = path;