需求
将表(Ws_FormMain)的字段(order_Number)内容为XSRK201706080001修改为WXSK201706080001
update 表名 set 字段 = replace(字段, '要修改的内容' , '修改后的内容');
UPDATE Ws_FormMain SET order_Number = REPLACE(order_Number, 'XSRK', 'WXSK') WHERE orderDefId = 513
需求
将表(Ws_FormMain)的字段(order_Number)内容为XSRK201706080001修改为WXSK201706080001
update 表名 set 字段 = replace(字段, '要修改的内容' , '修改后的内容');
UPDATE Ws_FormMain SET order_Number = REPLACE(order_Number, 'XSRK', 'WXSK') WHERE orderDefId = 513