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 a longblob?
How can I see mysql database?
What you can use regular expression for in mysql?
How to list or view all databases from the mysql server.
What is RMS Migrations
What is strict mode in mysql?
What is difference between function and procedure in mysql?
What is the current root password of mysql?
how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.
How to get current MySQL version?
How large can a mysql database become?
What is max connections in mysql?
Restore database (or database table) from backup.
Is oracle better than mysql?
How database are managed?