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: > 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
