Update 表名 Set 列名 = Replace(列名,‘被替换的字符’,‘要替换的字符’)
Demo:
UPDATE BPM_Daily
SET Workstation = REPLACE(Workstation, '_', '-')
Update 表名 Set 列名 = Replace(列名,‘被替换的字符’,‘要替换的字符’)
Demo:
UPDATE BPM_Daily
SET Workstation = REPLACE(Workstation, '_', '-')
转载于:https://www.cnblogs.com/fengyie55/p/5116367.html