What?s the difference between PRIMARY KEY and UNIQUE in
MyISAM?

Answer Posted / niraj kumar

primary key is not accept the null value.primary key is
always autoincrement.unique key is accept the one null
value.it is not a autoincrement.

Is This Answer Correct ?    4 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is mysql data directory? How to determine the location of the data directory?

532


What are the different mysql database engines?

535


What does it mean to be case sensitive?

477


How do I find users in mysql?

533


What is action query?

506






What is difference between statement and preparedstatement?

480


What is key in mysql?

502


How do you connect MySQL database with PHP?

536


What are different types of queries?

488


What is the difference between BLOB AND TEXT?

590


Explain the difference between delete and truncate.

541


Why does mysql have so many connections?

491


How to include comments in sql statements?

573


Is mysql a backend?

522


What is the current root password of mysql?

494