SV: MySQL Bug?

[Martin Edelius]

>It did not like 'not null' declared before 'unsigned'.  This is not
intutitive

IMHO it's perfectly logical since NOT NULL can be assigned to any column
(char, int, blob, and so on) while UNSIGNED denotes that fact that a
numerical column (i.e. not text, blob, time, and so on) is unsigned.
UNSIGNED 'belongs' to int (in this case), NOT NULL is secondary.

I do agree that I was a bit miffed the first time I encountered this
problem too but the manual lists the keywords in the right order so when
I did as it said, it worked. 8)


Best regards,
Martin Edelius

Spirex Digital Design

--------------------------------
www: http://www.spirex.se
Mail: martin.edelius@stripped
Phone: [phone]
Fax: [phone]
S-422 43 Hisings Backa
--------------------------------