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
What are date and time functions in mysql?
How do you concatenate strings in mysql?
How to show table names with 'mysqlshow'?
How do I use mysql?
Is mysql a programming language?
How is oracle different from mysql?
How to show all records starting with the letters 'sonia' and the phone number '9876543210'
What are the differences between innodb and myisam engines?
How do I show users in mysql?
How does triggers work in mysql?
What is difference between oracle sql and mysql?
Why is it called mysql?
What are the advantages and disadvantages of using mysql?
How many sql ddl commands are supported by 'mysql'?
What is mysqli_select_db?