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 do I clear the screen in mysql?

528


What is mysql workbench used for?

514


How to set the time zone for MySQL to particular country time?

2732


What is mysql url?

478


How to drop an existing table in mysql?

561






How do you concatenate strings in mysql?

535


What is mysql default port number?

537


What is mysql_query?

470


How do I get a list of table names in mysql?

496


how to dump all databases for backup. Backup file is sql commands to recreate all db's.

458


What is the return type of mysqli_query?

469


What is a transaction? Describe mysql transaction properties.

546


How do I start and stop mysql server?

483


How many mysql connections can handle?

490


How do I download mysql on my laptop?

488