Hi all, How can I create composite primary key on tables using phpmyadmin?
create table achintya
( foo smallint not null
, bar smallint not null
, primary key ( foo, bar )
, qux datetime not null
I know the sql but I want to do directly using phpmyadmin tools/menus. Can I do that?
yes, but not while initially setting up the table. after the table is created, you can add an index. it will give you the option to pick the number of columns you want to create the index on.