1INSERT INTO init_file.startup VALUES ( NOW() );
2SELECT * INTO @X FROM init_file.startup limit 0,1;
3SELECT * INTO @Y FROM init_file.startup limit 1,1;
4SELECT YEAR(@X)-YEAR(@Y);
5YEAR(@X)-YEAR(@Y)
60
7ok
8end of 4.1 tests
9select * from t1;
10x
113
125
137
1411
1513
16select * from t2;
17y
1830
193
2011
2113
22