1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
# # test of ISNULL() # --disable_warnings drop table if exists t1; --enable_warnings create table t1 (id int auto_increment primary key not null, mydate date not null); insert into t1 values (NULL,"2002-05-01"),(NULL,"2002-05-01"),(NULL,"2002-05-01"); flush tables; select * from t1 where isnull(to_days(mydate)); drop table t1; # End of 4.1 tests |