1>新建临时表
2>
select * from grdk_sq_htxx where jkrxm='吴建广';---吴建广
update grdk_sq_htxx t set t.jkrxm = replace(jkrxm,' ','') where regexp_like(t.jkrxm,'[[:space:]]');
本文共 206 字，大约阅读时间需要 1 分钟。
1>新建临时表
2>
select * from grdk_sq_htxx where jkrxm='吴建广';---吴建广
update grdk_sq_htxx t set t.jkrxm = replace(jkrxm,' ','') where regexp_like(t.jkrxm,'[[:space:]]');
转载于:https://blog.51cto.com/11218855/2108243