summaryrefslogtreecommitdiff
path: root/mysql-test/r/adddate_454.result
blob: 0993cdce32ca3b6e695a7677cfe7da5aafd08c28 (plain)
1
2
3
4
5
6
7
8
9
10
create table t1 (d date);
insert into t1 values ('2012-00-00');
select * from t1;
d
2012-00-00
update t1 set d = adddate(d, interval 1 day);
select * from t1;
d
NULL
drop table t1;