522
522
#create table t1(f1 int);
523
523
#alter table t1 add column f2 datetime not null, add column f21 date not null;
524
524
#insert into t1 values(1,'2000-01-01','2000-01-01');
526
526
#alter table t1 add column f3 datetime not null;
528
528
#alter table t1 add column f3 date not null;
530
530
#alter table t1 add column f4 datetime not null default '2002-02-02',
531
531
# add column f41 date not null;
532
532
#alter table t1 add column f4 datetime not null default '2002-02-02',