show variables like 'SQL_SAFE_UPDATES';
SET SQL_SAFE_UPDATES = 0;
update `tumor` set NONCODEId=replace(NONCODEId,'Not Found.','N.A.');
sql 替换某个字段的值
最新推荐文章于 2022-07-29 09:56:39 发布
show variables like 'SQL_SAFE_UPDATES';
SET SQL_SAFE_UPDATES = 0;
update `tumor` set NONCODEId=replace(NONCODEId,'Not Found.','N.A.');