Both r same :) Primary Key= (Unique + Not Null)

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS
NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY
WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT
ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT
DUPLICATE VALUES?
SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND
PRIMARY KEY??????

Question Posted / banti

8 Answers
10447 Views
rsystems, I also Faced
E-Mail Answers

Answer Posted / banti

Both r same :)
Primary Key= (Unique + Not Null)

Is This Answer Correct ?

2 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how to include comments in sql statements? : Sql dba

946

write an sql query to find names of employee start with 'a'? : Sql dba

1020

how to create a test table in your mysql server? : Sql dba

996

how to return query output in html format? : Sql dba

1067

Explain the savepoint statement.

1088

What are inner outer left and right joins in sql?

1006

How are functions and procedures called in PL/SQL?

1210

What are the two types of exceptions in pl/sql?

1043

Why does sql need a server?

1028

What is the purpose of design view?

1004

Why do we go for stored procedures?

1046

What are all the common sql functions?

1007

What is bind reference and how can it be created?

1010

how is myisam table stored? : Sql dba

1048

What is the difference between subquery and correlated query?

1054