If a field is null the database engine makes the field to be 0 if not null

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.

Question Posted / g priya

6 Answers
8662 Views
I also Faced
E-Mail Answers

Answer Posted / g priya

If a field is null the database engine makes the field to be 0
if not null is specified ,field must be given a value
Primary key is unique,not null,index where as Unique key has
1 null value

Is This Answer Correct ?

2 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to show certain selected rows with the value "pcds".

919

What is a heap table?

933

What are the different column comparison operators in mysql?

932

what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba

1028

How do I delete a mysql user?

835

How to calculate expressions with sql statements?

1095

What is a longblob?

929

Is mysql a good database?

931

How do you stop an access query?

894

Which software is used for mysql?

961

What are the advantages of a procedure?

904

Is foreign key indexed mysql?

875

can you tell the order of sql select statement? : Mysql dba

892

Is mysql better than oracle?

913

In mysql, what is joins? Explain

954