Home > Backend Development > PHP Tutorial > 请教如何更新mysql数据库 text字段类型的数据

请教如何更新mysql数据库 text字段类型的数据

WBOY
Release: 2016-06-13 13:33:36
Original
1840 people have browsed it

请问怎么更新mysql数据库 text字段类型的数据?
以下语句 content 字段是text类型,

我使用 UPDATE table SET title='dhl333',content=CONCAT(content,'33333') WHERE article_id=15 

发现content字段的内容是不断叠加上去,而不是替换,我是要替换的效果。

------解决方案--------------------
CONCAT就是拼接字符串啊

要么直接='3333333'满足要求了吧

Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template