试试这个-
CREATE TABLE table1(column1 TEXT);INSERT INTO table1 VALUES ('text1rntext2text3');SELECt * FROM table1;--------text1text2text3UPDATe table1 SET column1 = REPLACE(column1, 'rn', '');SELECT * FROM table1;--------text1text2text3
试试这个-
CREATE TABLE table1(column1 TEXT);INSERT INTO table1 VALUES ('text1rntext2text3');SELECt * FROM table1;--------text1text2text3UPDATe table1 SET column1 = REPLACE(column1, 'rn', '');SELECT * FROM table1;--------text1text2text3名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
