What is the main different between Null and NOT Null.
Difference between Primary and Unique Key.
How to Check the database from which application is it
possibe.

Answer Posted / amit kumar tiwari

primary key uniquely define each table and never allow NULL
value. But unique key may be NULL value.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How is myisam table stored?

551


Which statement is used to delete a table in MySQL.

477


Write a query to retrieve a hundred books starting from 20th.

961


Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

4206


What is the difference between is null & is not null?

518






Is pdo more secure than mysqli?

462


Does mysql support nosql?

473


Explain the difference between mysql_fetch_array(), mysql_fetch_object()?

458


How many ways to get the current time?

506


How do I change global variables in mysql?

471


What is mysqladmin flush hosts?

496


What are the differences between mysql vs sql server?

475


What is difference between unix timestamp and mysql timestamp?

534


How do I find users in mysql?

526


How to see the create table statement of an existing table?

576