how we can use more then one primary key in Single Table

Answer Posted / frank

Can't, but can create primary key with multiple columns:

CREATE TABLE Test (id1 INT NOT NULL, id2 INT NOT NULL, name
CHAR(20) NOT NULL, PRIMARY KEY(id1,id2));

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I stop a mysql command?

475


Will mysql remain free?

499


What sql does mysql use?

481


Can't connect mysql server on localhost?

493


What is clob datatype?

474






How can you calculate the sum of any column of a table?

503


What does mysql workbench do?

465


What are the method you will follow while sql installing

1864


What are the benefits of mysql?

470


List some comparisons operators used in mysql?

521


How do I start and stop mysql server?

468


What is the maximum no of columns a table can have?

461


What is procedures in mysql?

500


what is mysql optimization in brief?

1931


What are procedures in mysql?

483