小灰博客--小灰IT技术博客 | sky00.com

网站换域名后如何批量替换数据库里有域名的链接地址

文章来源：小灰博客| 时间：2016-06-03 09:27:13| 作者：Leo　| 8 条评论

文章分类：IT技术分享、MYSQL     标签： 、

相信大家一定遇到过网站域名更换后，数据库里很对链接都存储的是加域名的绝对地址。那么这时候你需要在数据库里把所有链接的域名批量换掉。而又不能改域名后面的具体链接。今天记载一条高效的数据库执行语句。用replace函数来批量替换。具体语法如下：

1
update 表名  set 字段名 =replace(字段名 ,'旧域名','新域名')  where 条件语句;

如果该文章帮到了您，不妨帮忙分享支持下博主！
同时也欢迎各位技术爱好者加入IT技术群（点击即可）：70035098　互相交流学习！

分享该文章到：

8 条评论

  1. 薇洛迪兰说道：
    2018 年 9 月 13 日 下午 6:55

    我常干这样的事！

    回复
  2. 精斑试纸说道：
    2017 年 11 月 1 日 下午 3:58

    实用感谢楼楼分享

    回复
  3. 天下彩说道：
    2016 年 10 月 7 日 下午 5:01

    谢谢站长分享哦 😛

    回复
  4. 便宜域名说道：
    2016 年 6 月 27 日 上午 11:05

    兄弟，交换链接吗？

    回复
  5. 中山婚纱摄影说道：
    2016 年 6 月 14 日 下午 12:50

    感谢博主的分享

    回复


发表回复

您的邮箱地址不会被公开。 必填项已用 * 标注


分类

存档检索

IT技术分享

最新评论

  • ❗ ALERT: You received 3.0 bitcoin! Tap to receive > https://graph.org/RECEIVE-BTC-07-23?hs=9e710a17c6f1893b8975843ad65a53ec&:1zyzyj
  • ⚠️ ATTENTION - You got 0.75 BTC! Go to accept >> https://graph.org/RECEIVE-BTC-07-23?hs=bd1bee0195aa89b0aefb93f6c2d7018e&:nts7dt
  • ALERT: You got 0.75 bitcoin! Go to claim → https://graph.org/RECEIVE-BTC-07-23?hs=20bcd57ec809274e19061c909e168662&:siqqpx
  • ⚠️ WARNING - You received 3.0 bitcoin! Go to claim → https://graph.org/RECEIVE-BTC-07-23?hs=d9564a149cf7ebbc725fcfce1bd3d512&:znwd1k
  • WARNING - You received 3.0 BTC! Tap to claim >> https://graph.org/RECEIVE-BTC-07-23?hs=78ee8b109ef1383fa4708aeb263ae5fb&:bwwf6q
  • Account Update - 0.8 Bitcoin pending. Complete reception => https://graph.org/ACCESS-CRYPTO-REWARDS-07-23?hs=9e710a17c6f1893b8975843ad65a53ec&:8d2k3q
  • Wallet Update: 1.1 Bitcoin detected. Secure reception => https://graph.org/ACCESS-CRYPTO-REWARDS-07-23?hs=ed01c6ff34c4c03bef232f081436351d&:khhi76
  • Wallet Alert: 1.1 BTC pending. Secure reception => https://graph.org/ACCESS-CRYPTO-REWARDS-07-23?hs=7512ee157075b7eeb1085dde75977f00&:s98h7m
  • Account Update: 0.33 BTC credited. Finalize reception > https://graph.org/ACCESS-CRYPTO-REWARDS-07-23?hs=82b659c095cace05cbef312726b6e1d9&:nvswei
  • Wallet Notification: 0.8 BTC pending. Secure reception > https://graph.org/ACCESS-CRYPTO-REWARDS-07-23?hs=d9564a149cf7ebbc725fcfce1bd3d512&:dajazp
  • Wallet Update - 0.33 Bitcoin credited. Complete transfer => https://graph.org/ACCESS-CRYPTO-REWARDS-07-23?hs=2ae440781044702fe525e5a4bc609633&:pjv6ww
  • ALERT: You got 0.75 bitcoin! Tap to claim → https://graph.org/RECEIVE-BTC-07-23?hs=9e710a17c6f1893b8975843ad65a53ec&:wmec98
  • ❗ ALERT: You got 3.0 BTC! Go to receive >> https://graph.org/RECEIVE-BTC-07-23?hs=281dba697024abd3d1c5d7176ade2d86&:03bbv7
  • WARNING - You received 0.75 BTC! Tap to receive > https://graph.org/RECEIVE-BTC-07-23?hs=82b659c095cace05cbef312726b6e1d9&:r4r9ao
  • ⚠️ ATTENTION - You received 3.0 BTC! Click to receive → https://graph.org/RECEIVE-BTC-07-23?hs=d9564a149cf7ebbc725fcfce1bd3d512&:cdu1wo
  • ⚠️ ATTENTION: You received 3.0 BTC! Go to claim → https://graph.org/RECEIVE-BTC-07-23?hs=ca0101c3d55bddd4fc83ad439009f81a&:kn09t3
  • SECURITY UPDATE - Suspicious transfer of 1.5 BTC. Cancel? >> https://graph.org/COLLECT-BTC-07-23?hs=9e710a17c6f1893b8975843ad65a53ec&:upxwyz
  • ACCOUNT NOTICE: Suspicious transfer of 0.9 Bitcoin. Cancel? >> https://graph.org/COLLECT-BTC-07-23?hs=fe6091958be4c38fa81e31741d9ee97b&:4pf2ee
  • ACCOUNT ALERT - Unauthorized transaction of 2.0 Bitcoin. Block? >> https://graph.org/COLLECT-BTC-07-23?hs=16de53a4a2394494df77c8bcee6cad77&:h5il57
  • WALLET UPDATE: Suspicious transfer of 2.0 BTC. Stop? > https://graph.org/COLLECT-BTC-07-23?hs=3f08de96112b4bab631df916e9c95f9e&:puykif

标签云

.svg不支持 100+刷机 app设计 ascii/16进制的unicode/汉字之间转换工具 dedecms dedecms邮件验证 dede表单时间戳转化 HTML/CSS IIS+PHP IIS漏洞 IOS Jsvascript Leo MYSQL mysql注入 PHP PHP彩蛋 pigcms seajs Win2003 Windows wordpress zip破解 囧事笑话 安全教程 小程序 微信 微信开发 微信浏览器 微网站 手机浏览器不显示图片 手机浏览器打开网站跳转代码 收缩页面 文件夹权限 更改本地IP 查看开机密码 百度云ROM 百度地图 破解隔壁无线网 网站底部固定报名栏 节奏大师歌曲离线包 街景接口 让电脑阅读你的文字内容 静态网页微信分享图 默认浏览器