mysql> create table year1 (year_copyright year);query ok, 0 rows affected (0.21 sec)mysql> insert into year1(year_copyright) values (2017);query ok, 1 row affected (0.08 sec)mysql> select * from year1;+----------------+| year_copyright |+----------------+| 2017 |+----------------+1 row in set (0.00 sec)
以上就是mysql 如何使用 year 数据类型在表中存储年份值？的详细内容。