› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
ShunYea
V2EX  ›  MySQL

MySQL 用了个替换语句,为啥纯网址执行无效?求 SQL 语句指点。

  •  
  •   ShunYea · Jun 27, 2014 · 3874 views
    This topic created in 4508 days ago, the information mentioned may be changed or developed.
    想替换下网站里的附件路径,换了博客系统使路径变了。但是第一条执行成功:

    UPDATE zbp_post SET log_Content = replace(log_Content, '../../../upload', 'http://www.xxx.com/users/upload');

    第二条执行完了没效果,提示“影响了 0 行。 (查询花费 0.0123 秒。)”:

    UPDATE zbp_post SET log_Content = replace(log_Content, 'http://www.xxx.com/upload', 'http://www.xxx.com/users/upload');

    求高手解释,谢谢。
    Supplement 1  ·  Jun 28, 2014
    知道原因了,抱歉,自己犯错误。该博客下面域名都被模版函数代替了,怪不得我怎么也搜索不到域名。
    No Comments Yet
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   2291 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 26ms · UTC 04:32 · PVG 12:32 · LAX 21:32 · JFK 00:32
    ♥ Do have faith in what you're doing.