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 command is used to delete the data from the table without deleting the table structure?
What are the 5 r's of managing behaviors?
How does mysql store dates?
What is the limitation of mysql?
What is difference between mysql_connect and mysql_pconnect?
What does mysqli stand for?
What are ddl statements in mysql?
Is mysql running ubuntu?
How do I completely remove mysql from windows?
What is row?
What is sql in mysql?
What is a storage engine? What are the differences between innodb and myisam engines?
What is text in mysql?
How can you move the master database
What is ntext?