As far as I know, if you have an auto_increment primary key, you cant have any other field in its primary key.
João Cândido. "Victor Subervi" <[email protected]> escreveu na mensagem news:[email protected]... > Hi; > I have the following: > > create table pics ( > picture_id int auto_increment primary key, > product_sku int not null primary key, > picture_num int not null, > picture_desc varchar(100), > picture_data longblob > ); > > which doesn't work I need to auto_increment and declare primary key on two > fields. How do? > TIA, > Victor > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected]
