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

Answer Posted / raj

primary key is something which uniquely identifies the table
row. the value in primary key declared field can't be null
On the other hand unique avoids the duplicacy of data.

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create a new view in mysql?

523


What is index length in mysql?

479


How do you create a schema?

490


What is the usage of ENUMs in MySQL?

629


What are the differences between a primary key and foreign key?

557






How many sql ddl commands are supported by 'mysql'?

578


What are the three types of queries?

452


What is the role of a limit in a mysql query?

543


What is striped backup

1822


What is clob in mysql

474


Can mysql handle big data?

513


Why is mysql used?

515


How do I free up space in mysql?

483


How can I see connections in mysql?

467


How many TRIGGERS are allowed in MySql table?

574