What is the diff. bwt. primary key and unique key?

Answer Posted / sonu kumar

primary of any table can't be null but unique can be
primary key may be a unique key but unique can't be a primary key b/c primary key of any relation cant be a null value

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to dump a table to a file with 'mysqldump'?

513


Is mysql workbench a dbms?

513


What is the difference between b-tree and hash indexes?

442


Does mysql automatically index foreign keys?

479


What is the use of mysql workbench?

508






Which software is used for mysql?

500


Is sql similar to mysql?

471


How to print message in mysql trigger?

987


How to create a new view in mysql?

523


1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?

1919


Is mariadb better than mysql?

540


How to show certain selected rows with the value "pcds".

497


What is the difference between sql and mysql and oracle?

428


Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T

1731


In which language mysql has been written?

861