Interested to Buy Any Domain ? << Click Here >> for more details...
how we can use more then one primary key in Single Table
- 9 Answers
- 15696 Views
- Systematix, I also Faced
- E-Mail Answers
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
What is the difference between primary key and candidate key?
What is blob in mysql?
Write a query to count the number of rows of a table in mysql.
How do we delete a row in a table?
What is difference between mysql_connect and mysql_pconnect?
How to set the time zone for MySQL to particular country time?
What is the use of mysqli_fetch_assoc?
How can you handle the –secure-file-priv in mysql?
What is trigger in mysql with example?
How does mysql encrypt passwords?
How to returns the columns and column information pertaining to the designated table.
How many primary keys can be there in a table?
How would you enter characters as hex numbers?
What is the use of count function in mysql?
What are the functions used to encrypt and decrypt the data present in mysql?
