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 do I find the database name in mysql?

697


Write a query to select all teams that won either 1, 3, 5 or 7 games.

1053


What are the differences between innodb and myisam engines?

667


How do I optimize a selected query in mysql?

688


How to change the database engine in mysql?

662


Why we use mysql workbench?

660


How can you find out the version of the installed mysql?

968


What is the role of a limit in a mysql query?

766


What is latest version of mysql?

739


suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?

1910


How many queries can mysql handle?

713


What is max_used_connections in mysql?

700


How do I edit a stored procedure in mysql?

672


What do I do if I forgot my mysql root password?

657


What is a csv table?

757