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

向mysql插入数据的时候，出现异常

WBOY
Release： 2016-06-13 13:37:15
Original
822 people have browsed it

向mysql插入数据的时候，出现错误
ERROR 1406 (22001): Data too long for column 'article_body' at row 1  

近期自己动手做个个人博客，我向数据库里插入了一篇文章，结果由于文章字数太长，导致插入失败。

如果可以用mysql插入大量字符的怎么解决。

如果不需要用数据库插入文章，是否有其他的方法呢？别个 博客发表文章，又是存在哪个地方，是数据库么



问题有点多，多多指教

------解决方案--------------------
修改字段 为text 类型

不使用数据库那就直接保存成文本文件.但是不利于检索和修改

Related labels：
error mysql
source：php.cn
Previous article： ThinkPHP框架,该怎么处理 Next article： 单引号与双引号的区别解决方案
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
How to list data in a section by ID using while loop in PHP? I have a mysql table with these columns: series_id, series_color, product_name In the outp...
From 2023-11-17 20:03:03
0
1
290
Using triggers and constraints to limit the number of records in MySQL I have a table called BFFs that stores user IDs and best friends' user IDs, and I want to ...
From 2023-11-14 13:35:02
0
4
434
Resolving django.db.utils.NotSupportedError error in Django I'm getting an error when running a project in Django. The problem is unfortunately I upgr...
From 2023-11-14 11:59:20
0
1
246
Retrieve MySql rows with the same column value Let us consider the following table - IDScore19521003884100573 I am a complete SQL noob, b...
From 2023-11-10 21:53:39
0
2
331
How to publish SQLite database data to an online MySQL database in Flutter? How to sync offline SQLite to MySQL online database in Flutter? Any suggestions?
From 2023-11-10 12:36:40
0
2
247
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！