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


Please Help Members By Posting Answers For Below Questions

How to use mysqldump to create a copy of the database?

685


What is slow query log in mysql?

738


What is use command in mysql?

731


What is cursor in mysql?

663


How to insert dynamic values in mysql using php?

858


Is mysql relational database?

658


how to add a new column to an existing table?

726


What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

702


In which year mysql created?

704


How to create trigger in mysql workbench?

729


What is the use of mysql workbench?

745


How do I download mysql on my laptop?

660


What are the objects can be created using CREATE statement?

712


What is longblob?

738


What is mysql and how it works?

636