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

Answer Posted / sharad

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

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I delete a mysql user?

447


How do I change the max connections in mysql?

445


What is mysql optimization?

463


If you wish to encrypt the username and password using php, how will you do that?

497


What are the types of index?

493






Can python connect to mysql?

453


How do I create a database in mysql workbench?

427


What are the benefits of mysql?

454


What is database engine in mysql?

469


Can a table have multiple primary keys?

467


How do I flush privileges in mysql?

477


What are the steps involved in query processing?

464


Why do we use preparedstatement?

468


Does adding an index lock a table?

468


What is use command in mysql?

515