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
8701 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

What are date and time functions in mysql?

1008

How do you concatenate strings in mysql?

999

How to show table names with 'mysqlshow'?

1026

How do I use mysql?

881

Is mysql a programming language?

885

How is oracle different from mysql?

1007

How to show all records starting with the letters 'sonia' and the phone number '9876543210'

930

What are the differences between innodb and myisam engines?

975

How do I show users in mysql?

1041

How does triggers work in mysql?

948

What is difference between oracle sql and mysql?

1006

Why is it called mysql?

904

What are the advantages and disadvantages of using mysql?

994

How many sql ddl commands are supported by 'mysql'?

1128

What is mysqli_select_db?

958