直接看SQL,亲测有效。
update
acutary_drug_hypothesis
set
indication_code = replace(replace(indication_code, CHR(13), ''), CHR(10), '')
直接看SQL,亲测有效。
update
acutary_drug_hypothesis
set
indication_code = replace(replace(indication_code, CHR(13), ''), CHR(10), '')