blob: bd3bcd8d04ca1e4a538846865ad1bda70abb27e4 (
plain)
1
2
3
4
5
6
7
8
9
10
|
#
# test of ISNULL()
#
drop table if exists t1;
create table t1 (id int auto_increment primary key not null, mydate date not null);
insert into t1 values (0,"2002-05-01"),(0,"2002-05-01"),(0,"2002-05-01");
flush tables;
select * from t1 where isnull(to_days(mydate));
drop table t1;
|
