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

Does uninstalling mysql delete database?

492


How to show table names with 'mysqlshow'?

540


What is localhost in mysql?

531


What are the differences between mysql vs sql server?

475


How to delete a database from mysql server.

516






How can you retrieve a particular number of records from a table?

497


What are slow queries?

476


What is regex in mysql?

527


What is difference between oracle sql and mysql?

491


Why phpmyadmin is used for mysql?

500


What is a tinyint?

509


What is the difference between BLOB AND TEXT?

583


How to load a csv file into a table

545


What is the limitation of mysql?

475


What does mysql workbench do?

465