Dear All,
When declaring values for an identifier with unsigned auto_increment, is it
necessary to include NOT NULL?
my_id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
or
my_id INT NOT NULL UNSIGNED AUTO_INCREMENT PRIMARY KEY,
Regards,
Will
Hi!
I think that NOT NULL comes together with PRIMARY KEY and not with
AUTO_INCREMENT.
Follow this link http://dev.mysql.com/doc/mysql/en/create-table.html for
detailed information about creating tables in MySQL.
Have a nice day!
Aurel
On Wed, 2005-10-05 at 12:15 +0200, W Roothman wrote: