Home >Database >Mysql Tutorial >sql修改字段内容_MySQL
sql修改字段内容_MySQL
- WBOYOriginal
- 2016-06-01 13:17:451103browse
--sql 修改字段内容UPDATE 表 SET 字段=REPLACE(cast(字段 AS varchar(8000)),'被替换的内容','将要替换成的内容') UPDATE t_newsinfo SET [content]=REPLACE(cast([content] AS varchar(max)),'http://admin.thinkall.net.cn/','http://admin.xkpx.com/')
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MySQL创建计算字段――MySQL系列（五）_MySQLNext article：项目中我为什么用Mongodb取代Mysql_MySQL