简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Backend Development > PHP Tutorial > body text

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

WBOY
Release： 2016-06-13 13:33:36
Original
1784 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：
concat content text
source：php.cn
Previous article： smarty模板新手有关问题：提示在模板中发现未定义函数 Next article： 屏蔽国内IP，访问需要进行身份验证解决思路
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
Latest Articles by Author
Latest Issues
Where should I start to make this page responsive? <!DOCTYPEhtml><htmllang="en"><head><metacharset="UTF-8...
From 2024-04-04 21:21:25
0
1
457
PHP Tutorial: How to upload text and images to Linkedin using PHP? I try to upload text, images and links using LinkedinsRestAPI (https://learn.microsoft.com...
From 2024-04-03 18:42:29
0
1
420
Why doesn't my Jquery slider display correctly? I'm trying to implement the SlickSlider library in my WordPress custom theme to display an...
From 2024-04-03 10:43:26
0
1
397
How to get input value through onblur event? I'm trying to get the value input via onblur event but it doesn't work when I use JS modul...
From 2024-04-03 08:55:32
0
1
360
Getting table columns to stack on mobile view is my goal I have 5 columns and I'm making them as tables because that's the easiest way for me to co...
From 2024-04-02 20:50:17
0
1
274
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！