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

Why do we use pragma autonomous transaction?

649


Where is the mysql data directory?

668


What is the difference between a heap table and temporary table?

670


Is Mysql query is case sensitive?

695


Can we store files in mysql?

644






How do I view a mysql database?

633


How can you create and drop view in mysql?

679


What language does mysql use?

603


How to create a new table by selecting rows from another table in mysql?

684


How can we optimize stored procedure?

663


How to start mysql server?

720


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

604


Where is mysql installed on linux?

654


I want to find out all databases starting with ‘test’, I have access to?

837


How many types of indexes are there in mysql?

649