In the following table, I declare ID as a PRIMARY KEY. Is it then necessary to add the parameters NOT NULL AUTO_INCREMENT?
CREATE TABLE company ( ID INT NOT NULL AUTO_INCREMENT,
name VARCHAR(30),
admin_ID INT,
PRIMARY KEY ID, INDEX admin_ID, );
Or can I just declare the table like that? Does creating a primary key on an int immediatly involve this one to be not null, and to auto-incrément?
CREATE TABLE company ( ID INT,
name VARCHAR(30),
admin_ID INT,
PRIMARY KEY ID, INDEX admin_ID, );
Thank you very much.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]