[PHP-DB] NOT NULL - newbie

2005-10-05 Thread W Roothman
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

Re: [PHP-DB] NOT NULL - newbie

2005-10-05 Thread Constantin Brinzoi
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: