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
How do I select a database in mysql workbench?
What is pragma exception?
How to set mysql variable in php?
why not null is not allowed at table level
What is truncate command?
What is pragma serially_reusable and why is it used?
How do I disable mysql?
What causes mysql too many connections?
What is a heap table?
What's the difference between mysql and sql server?
Explain triggers and stored procedures?
How do I insert multiple rows in a table?
Can you tell a way to know the number of days between the two given dates in php?
Write a program using the select statement, while loop.
How to create a new table by selecting rows from another table in mysql?