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 / nivedita
IF NULL is specified,the feild is allow to be left empty
without any value.
IF NOT NULL is specified,the field must be given a value. In
the absence of either a NULL or NOT NULL, NULL is assumed.
-------
Unique key can't be NULL.Primary key can be NULL.
Unique key always contain unique value,duplicate are not
allowed(genrally the system genrated key).Primary key maybe
repeated.
| Is This Answer Correct ? | 6 Yes | 35 No |
Post New Answer View All Answers
What is difference between schema and table?
Explain % and _ inside like statement?
Why do you think it is advised to not to use guid and character columns as clustered index arrays?
How to enter microseconds in sql statements?
How do I delete a mysql user?
What is mysql common?
What are the differences between mysql vs sql server?
What is the use of count function in mysql?
Why should I learn mysql?
Is there a free version of mysql?
How do I run mysql on a mac?
What is the difference between char and varchar?
What is mysql cursor?
Create table employee (eno int(2),ename varchar(10)) ?
What is the difference between having and where clause in mysql? Explain