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 a longblob?

948


How can I see mysql database?

906


What you can use regular expression for in mysql?

946


How to list or view all databases from the mysql server.

921


What is RMS Migrations

2395


What is strict mode in mysql?

903


What is difference between function and procedure in mysql?

955


What is the current root password of mysql?

918


how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.

910


How to get current MySQL version?

1089


How large can a mysql database become?

1001


What is max connections in mysql?

930


Restore database (or database table) from backup.

1024


Is oracle better than mysql?

886


How database are managed?

990