MySQL数据库中的text字段是用来存储可变长度的文本数据的,它可以存储非常大的数据,最大可以存储65535个字节(64KB)的数据。
CREATE TABLE table_name ( id INTEGER NOT NULL, name VARCHAR(50), description TEXT );
INSERT INTO table_name (id,name,description) VALUES (1,'name1','This is a description of name1');
UPDATE table_name SET description = 'This is a new description of name1' WHERE id = 1;
SELECT id,name,description FROM table_name WHERE id = 1;
DELETE FROM table_name WHERE id = 1;
本文链接:http://task.lmcjl.com/news/10741.html