TINYTEXT
character type large object column, maximum length is 255(2^8 -1) characters.
TEXT
Character type large object column, maximum length is 65,535(2^16 – 1) characters.
MEDIUMTEXT
Character type large object column, maximum length is 16,777,215(2^24 – 1) characters.
LONGTEXT
Character large object column, maximum length is 4,294,967,295(2^32 – 1) characters.
Let’s get started.
mysql> create table news(
-> id int,
-> news mediumtext
-> );
Query OK, 0 rows affected (0.54 sec)
mysql> describe news;
+-------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+------------+------+-----+---------+-------+
| id | int(11) | YES | | NULL | |
| news | mediumtext | YES | | NULL | |
+-------+------------+------+-----+---------+-------+
2 rows in set (0.03 sec)
すげー、なるほど^^
