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 processlist in mysql?

479


Which is faster mysql or mongodb?

473


How can you increase the performance of mysql select query?

472


What are the similarities between a function and a procedure?

440


How would concatenate strings in mysql?

516






Is postgresql better than mysql?

498


What is database engine in mysql?

480


What you can use regular expression for in mysql? Support your answer with an example?

469


Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?

458


How do I run mysql from command line?

466


What is mysql community server?

475


What is max_used_connections in mysql?

472


How to rename an existing table in mysql?

524


How to returns the columns and column information pertaining to the designated table.

561


How do I restore a mysql database?

532