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.