将table表的url字段的www.abc.com/book/id/2.html修改为/book/id/2.html
sql语句为：update table SET url=REPLACE(url,‘www.abc.com/','/')
慕容的工作随笔
记录学习和工作
记录学习和工作
将table表的url字段的www.abc.com/book/id/2.html修改为/book/id/2.html
sql语句为：update table SET url=REPLACE(url,‘www.abc.com/','/')
评论 (0)