List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:August 24 1999 7:07am
Subject:Re: wrong description of columns
View as plain text  
At 10:43, 19990824, vlad@stripped wrote:
>Field "id" is declared as not null but default value is NULL

This isn't a bug.  When you insert the default (NULL), you get
the next ID.  That's the default behaviour.

If DESC didn't show NULL as the default, then you might have some
clients which would not insert NULL as the default value (e.g., a
gui client that adds rows to your table).

Anyway, it's the right thing for DESC to show, I think.  You just
have to understand what NULL means for an AUTO_INCREMENT column.

Tim
Thread
wrong description of columnsvlad24 Aug
  • Re: wrong description of columnsThimble Smith24 Aug