is it possible to assign two primary key in a table

Answer Posted / vignesh lakshmirajan

Answer is strictly NO...!!!

we may have morethan one unique column in a table but we should assign only one primary key...!!

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I free up space in mysql?

495


What is the difference between mysql_fetch_array() and ysql_fetch_object() ?

511


What are triggers mysql?

485


Write a query to fetch common records between two tables using mysql?

542


How do you backup a database in mysql?

581






What is mysql slow query?

524


Is mysql free download?

482


In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?

541


How do I clear the screen in mysql?

526


How to change the database engine in mysql?

455


What is join in mysql? What are the different types of join?

512


What is innodb_buffer_pool_size?

472


Is null in mysql?

452


Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

2424


What is mysql and why it is used?

564