how we can use more then one primary key in Single Table
Answer Posted / sonu kumar
we can more than one primary key in a single table in case of self joining
eg:-if want to details of employee and their manager in same table than empid,mngid both treated as primary key
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I automate a backup in mysql?
What is the query to display top 20 rows?
What is the usage of ENUMs in MySQL?
What are the three types of queries?
Can you tell which of the following where clauses is faster?
Write a query to stop mysql in unix
What does mysqli_fetch_assoc do?
Which command is used to view the content of the table in mysql?
How can you change the password of a mysql user?
How to rename an existing table in mysql?
What is insert query in mysql?
What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?
What is pdo connection?
How to connect html form to mysql database using php?
How do I select a table in mysql?