Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is difference between schema and table?

909


Explain % and _ inside like statement?

1005


Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1113


How to enter microseconds in sql statements?

975


How do I delete a mysql user?

841


What is mysql common?

896


What are the differences between mysql vs sql server?

1035


What is the use of count function in mysql?

1019


Why should I learn mysql?

909


Is there a free version of mysql?

934


How do I run mysql on a mac?

958


What is the difference between char and varchar?

1174


What is mysql cursor?

884


Create table employee (eno int(2),ename varchar(10)) ?

1001


What is the difference between having and where clause in mysql? Explain

1011