mysql - How to add multiple primary keys in a single table -


i tried create table fillowing in phpmyadmin. gives error:

"#1075 - incorrect table definition; there can 1 auto column , must defined key"

please 1 me

create table itemlist (     uid varchar(15),     item_id int auto_increment,     item_name varchar(50) not null,     primary key (uid, item_id) ); 


Popular posts from this blog

php - How should I create my API for mobile applications (Needs Authentication) -

5 Reasons to Blog Anonymously (and 5 Reasons Not To)

Google AdWords and AdSense - A Dynamic Small Business Marketing Duo