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.