Mysql 警告问题? [英] Mysql Warning Question?
本文介绍了Mysql 警告问题?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在我的 mysql 数据库中插入了一些信息,但出现以下错误.这是什么意思,我该如何解决?
I inserted some info into my mysql database and I got the following error listed below. What does this mean and how can I fix it?
1 row(s) inserted.
Inserted row id: 1
Warning: #1265 Data truncated for column 'summary' at row 1
下面是我的 Mysql 表结构.
Here is my Mysql tables structure below.
CREATE TABLE mem_articles (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
member_id INT UNSIGNED NOT NULL,
title VARCHAR(255) NOT NULL,
summary VARCHAR(255) DEFAULT NULL,
content LONGTEXT NOT NULL,
date_created DATETIME NOT NULL,
date_updated DATETIME DEFAULT NULL,
PRIMARY KEY (id)
);
推荐答案
我认为这意味着您尝试插入 summary
列的字符数超过 255,也许您应该将其更改为是 TEXT
而不是 VARCHAR(255)
.
I think it means that the amount of characters you attempted to insert into the summary
column exceeded 255, perhaps you should alter it to be TEXT
instead of VARCHAR(255)
.
http://dev.mysql.com/doc/refman/5.1/en/alter-table.html
这篇关于Mysql 警告问题?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文