更新替换内容MYsql数据库

单独更新表字段内容，比如
将path字段里的 “D” 替换为 “E” ，如下
update p_11 set path=replace(path,'D:','E:') where id<8

将address字段里的 “九” 替换为 “十” 显示，如下
select *,replace(address,'九','十') AS rep from test_tb where id in (4,6)

将address字段里的 “区” 替换为 “呕” 显示，如下
select *,replace(address,'区','呕') AS rep from test_tb

插入替换
将id=6的name字段值改为wokou
replace into test_tb VALUES(6,'wokou','新九州岛','日本')