问题描述
亲爱的所有人..在经过多次尝试和错误尝试后我放弃之前，有人可以在下面的查询中为我提供帮助吗.
我试图在"songlist"表下名为"filename"的mysql字段名称中将路径名D:\ Downloads \ Music \(注意斜线)替换为http://mysite.com/Music/.下面是我尝试过的查询代码，但没有任何反应，它只给我以下消息:0行受到影响. (查询时间为0.1428秒)
更新歌曲列表SET文件名=替换(文件名，"D:\ Downloads \ Music"，"http://mysite.com/Music/")
非常感谢您的帮助！
Dear all..before i give up after multiple trial and error attempts,can someone please help me with below query.
I am trying to replace the path name D:\Downloads\Music\ (note the slash) to http://mysite.com/Music/ in mysql field name called "filename" under "songlist" table.
Below is the query code that I tried with but nothing happens.It only gives me the following message : 0 row(s) affected. ( Query took 0.1428 sec )
UPDATE songlist SET filename = replace(filename, "D:\Downloads\Music", "http://mysite.com/Music/")
many thanks for the help!!!
推荐答案
这篇关于将目录路径替换为mysql数据库表中的url路径的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！