sir i am creating a database with name ams and 3 table with name article (fileds id(auto increment),title,image,contents and category) and 2 table login with user passwd as fileds 3rd table with category.
now i want in 1st table id,title,category as primary key but it gives error multiple primary key defined when i try to alter the table it gives error
1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key
so plz help me out how to define multiple primary key in table.