数据库语句更新某个字段的某个内容
UPDATE upload SET save_directory=REPLACE (save_directory,'f:','d:') WHERE save_directory LIKE "%f:%"
update content_attach set savePath=replace(savePath,'f:','d:') where savePath like "%f:%"
数据库语句更新某个字段的某个内容
UPDATE upload SET save_directory=REPLACE (save_directory,'f:','d:') WHERE save_directory LIKE "%f:%"
update content_attach set savePath=replace(savePath,'f:','d:') where savePath like "%f:%"
转载于:https://www.cnblogs.com/oymx/p/4182296.html