UPDATE test set code =REPLACE(code, ' ', '') WHERE code like '% '
SELECT TRIM(code) from test
SELECT REPLACE(code, 'a', 'b') WHERE id in (1)
7 数据库数据去空格
最新推荐文章于 2024-08-09 21:25:57 发布
UPDATE test set code =REPLACE(code, ' ', '') WHERE code like '% '
SELECT TRIM(code) from test
SELECT REPLACE(code, 'a', 'b') WHERE id in (1)