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 / g priya
If a field is null the database engine makes the field to be 0
if not null is specified ,field must be given a value
Primary key is unique,not null,index where as Unique key has
1 null value
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
Does uninstalling mysql delete database?
What is database engine in mysql?
Explain the difference between primary key and candidate key in mysql?
How to return query output in html format?
How can I see connections in mysql?
What is the difference between the LIKE and REGEXP operators?
How can you see all indexes defined for a table?
How do you know if your mysql server is alive?
what is database black box testing? : Mysql dba
How to display top 10 rows in mysql?
What is max_used_connections in mysql?
What is the purpose of using timestamp data type?
What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?
What is mysql common?
Is mysql frontend or backend?