ソフトウェアエンジニアの技術ブログ：Software engineer tech blog

mysql> create table news(
    -> id int auto_increment PRIMARY KEY,
    -> content varchar(10)
    -> );
Query OK, 0 rows affected (0.25 sec)

mysql> insert into news(news) values('テスト');
ERROR 1054 (42S22): Unknown column 'news' in 'field list'
mysql> insert into news(content) values('テスト');
Query OK, 1 row affected (0.04 sec)

mysql> select * from news;
+----+-----------+
| id | content   |
+----+-----------+
|  1 | テスト    |
+----+-----------+
1 row in set (0.00 sec)

mysql> insert into news(content) values('10byte以上を入れてみたいと思う.さてどうなるでしょうか？');
Query OK, 1 row affected, 1 warning (0.10 sec)

mysql> select * from news;
+----+--------------------+
| id | content            |
+----+--------------------+
|  1 | テスト             |
|  2 | 10byte以上を入     |
+----+--------------------+
2 rows in set (0.00 sec)

If I enter an amount that exceeds data type, only the acceptable number of bytes will be in the record.

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)

すげー、なるほど^^