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.