Question

mysql中字段为TEXT类型的内容怎么修改？

desc 是TEXT 类型的字段 name是VARCHAR 类型的字段
这个就报错
mysql> update cm_terminalinfo set desc='aa' where id=3022;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc='aa' where id=3022' at line 1
这个就正常
mysql> update cm_terminalinfo set name='aa' where id=3022;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0

Answer 1

可以把字段类型改成MEDIUMTEXT（最多存放16777215个字符）或者LONGTEXT（最多存放4294967295个字符）.

MySQL supports 4 TEXT field types (TINYTEXT, TEXT, MEDIUMTEXT and LONGTEXT) and this post looks at the maximum length of each of these field types.

MyISAM tables in MySQL have a maximum size of a row of 65,535 bytes, so all the data in a row must fit within that limit. However, the TEXT types are stored outside the table itself and only contribute 9 to 12 bytes towards that limit. (For more information about this refer to the MySQL Manual - Data Storage Requirements chapter).
TEXT data types are also able to store much more data than VARCHAR and CHAR text types so TEXT types are what you need to use when storing web page or similar content in a database.
The maximum amount of data that can be stored in each data type is as follows:
TINYTEXT 256 bytes
TEXT 65,535 bytes ~64kb
MEDIUMTEXT 16,777,215 bytes ~16MB
LONGTEXT 4,294,967,295 bytes ~4GB
In most circumstances the TEXT type is probably sufficient, but if you are coding a content management system it's probably best to use the MEDIUMTEXT type for longer pages to ensure there are no issues with data size limits.

Answer 2

desc是保留的
换其他字段名

Answer 3

一下VB代码，用来修改数据库
res.open "select * from txl where name='文文'",conn,4,2
res.Fileds("Phone")="12345675489"
res.Updata
res.Close

Answer 4

你在显示一个表的信息时是用desc tablename吗？所以说你的这个命令mysql不认识，或者你用
set [desc]='aa'来试一下

Answer 5

update 表名 set 字段='新内容'
你是指这样吗？还有问题的话，详细一点说明，我看看能不能帮你解决吧！

追问

update 表名 set 字段='新内容'
你是指这样吗？还有问题的话，详细一点说明，我看看能不能帮你解决吧

这个不好用，我试了，其他字段这么修改可以，都好用。就TEXT修饰的字段不好用。报错。