default when no data is supplied

[bobby_123]

I'm having real trouble trying to get the MySQL database to add the default value I have specified when no data is added to that field.

I've created a "varchar(60) not null default 'na.gif'" row which should return na.gif when no data is supplied, i've tried all sorts of ways to make it work - using "", NULL, 0, ,, but the default never kicks in.

What am I doing wrong?
Please help

[Pig]

You say have tried entering all those things, but have you left it out entirely? Just left out the column name from the query? All those things are values, not null. Even setting something to NULL is still SETTING it. Default means what it does when you don't give it anything, not when it you give it zero.

[Percadan]

Can't you just set the Default property of that column to wahtever you need the default to be?

[Pig]

Yes, but the default is only used if a value is not specified. If you use zero, null, or anything else, that is still a value. In these terms, 0 is the same as 5, 'string', etc. You are setting a value, so the default is not used. Just leave that column out of the insert if you want the default used.