1
drop table if exists t1;
2
create table t1 (y year,y2 year(2));
3
insert into t1 values (0,0),(1999,1999),(2000,2000),(2001,2001),(70,70),(69,69);
12
select * from t1 order by y;
20
select * from t1 order by y2;
29
create table t1 (y year);
30
insert into t1 values (now());
32
Warning 1265 Data truncated for column 'y' at row 1
33
select if(y = now(), 1, 0) from t1;