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 is innodb_buffer_pool_size?
How we get sum of column.
Write command to import an mysql file?
What is mysql architecture?
What are the advantages of MySQL when compared with Oracle?
what is database white box testing? : Mysql dba
How to enable or disable a row of a table using MySQL in struts?
How do I copy a table in mysql workbench?
What is processlist in mysql?
How to create a table index in mysql?
How to dump a table to a file with 'mysqldump'?
What data structure does mysql use?
What is max_used_connections in mysql?
How to change the database engine in mysql?
How do you create a schema?