default value

[mikerh9]

I use mysql 4. The table is

create table a(
first_name varhar NOT NULL default 'defaultname'
)

When I insert into the table
insert into a values('');

The value is NULL not 'defaultname'

What am I doing wrong?

[laserlight]

I think the value inserted is a blank string, not NULL. What you should do is exclude that column from the list of columns specified.