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
- 8757 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 'mysql' command line options?
Is Mysql query is case sensitive?
What is blob datatype in mysql?
How to enable or disable a row of a table using MySQL in struts?
How do you select a table?
How can you change the password of a mysql user?
What is the difference between BLOB AND TEXT?
Create table employee (eno int(2),ename varchar(10)) ?
What is the difference between mysql_fetch_assoc and mysql_fetch_array?
How to show all tables with 'mysql'?
Why mongodb is faster than mysql?
What is query log in mysql?
Can we rollback truncate in mysql?
What is mysql and how it works?
What is mysql enterprise edition?
