List:General Discussion« Previous MessageNext Message »
From:Tõnu Samuel Date:June 30 1999 8:39pm
Subject:Re: problems with DEFAULT statement in MySQL 3.22.23b
View as plain text  
Tim McQueen wrote:

> and INSERT the values ('joeuser','')
>
> shouldn't it populate the table with the values ('tmcqueen','password') ?

 INSERT the values ('joeuser',NULL)

must work. NULL and empty value are diffenet things. NULL means "no value at all" and "''"
means
value=empty string.

Thread
problems with DEFAULT statement in MySQL 3.22.23bTim McQueen1 Jul
  • Re: problems with DEFAULT statement in MySQL 3.22.23bTõnu Samuel1 Jul
  • Re: problems with DEFAULT statement in MySQL 3.22.23bSasha Pachev1 Jul
  • Re: problems with DEFAULT statement in MySQL 3.22.23bDaniel Koch1 Jul
RE: problems with DEFAULT statement in MySQL 3.22.23bdaniel.gardner1 Jul