2 questions

[Anon]

Is there an equivalent of the MS SQLserver ISNULL(columnname,'do this') function in MYSQL.
are there defaults in MYSQL, like put CURRENT_DATE if date_col is NULL
at the table level

at the code level
ISNULL(date_col,CURRENT_DATE())

[toma42]

update table set date_col = current_date() where date_col is null;

[Anon]

Can I do something like this while I insert

insert into table
values (isnull(date_col,current_date()))