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 · 3595 views
    This topic created in 4366 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   ·   Solana   ·   3932 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 38ms · UTC 05:05 · PVG 13:05 · LAX 22:05 · JFK 01:05
    ♥ Do have faith in what you're doing.