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.
- 6 Answers
- 8470 Views
- I also Faced
- E-Mail Answers
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 are the applications required to support mysql?
How do I copy a table in mysql?
What are string data types?
What is schema in mysql?
HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE
Is mysql a scripting language?
How database are managed?
What is the use of mysql_close()?
Can we store files in mysql?
How do I edit a trigger in mysql?
How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.
How to change the database engine in mysql?
How do I backup mysql database on linux?
What is the maximum no of columns a table can have?
Is mysql written in c?
