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
Does mysql use t sql?
How is data stored in mysql?
I want to find out all databases starting with ‘test’, I have access to?
How to use like conditions?
Where MyISAM table will be stored and also give their formats of storage?
How will you export tables as an xml file in mysql?
Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba
What is a session in mysql?
how we will Show selected records sorted in an ascending (asc) or descending (desc).
Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.
What is mysql root?
What is MySQL?
What is key in mysql?
What's the latest version of mysql?
What is sqlyog?